copy worksheet (keeping formats)

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I know I've found and save the answer to this question but I can't seem to
locate it.

I want to copy a worksheet and create another worksheet within the same
workbook and keep all it's formats and formulas. I will be changing some of
the formulas later, but will keep the formats.

Thanks,

Ken
 
Ken

Right-click on sheet tab and "move or copy".

Check "create a copy" and OK.

You have an exact duplicate of the sheet named Sheet(2)


Gord Dibben Excel MVP
 
If you right-click on the worksheet's tab, and select "Move or Copy", check
the "create a copy" checkbox and click "OK" might do what you want.
 
Thank you. I will make note of this and PUT IT WHERE I CAN FIND IT THIS
TIME.
Again thanks for your time.
Ken Williams
 
Back
Top