Worksheet Formatting

  • Thread starter Thread starter hic2k1
  • Start date Start date
H

hic2k1

How do you copy an entire worksheet formatting including
column width, row width, as well as any graphics in one
swoop?
 
hic2k1 said:
How do you copy an entire worksheet formatting including
column width, row width, as well as any graphics in one
swoop?
Click to expand...

It's probably easiest to copy the entire worksheet (right-click the
worksheet tab and use "Move or copy"), then select the unwanted
data/formulas and press the delete key to clear them.
 
My favorite way is to copy the entire worksheet, hold down Ctrl and drag the sheet tab to the right to create an exact duplicate of the first sheet and then delete what you don't want.
 
Back
Top