copying row heights

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

Hello,

I have a workbook with 12 identical sheets, one for each month of the year.
I have completed January with the formulae & formatting I want, and now need
to copy the sheet to the other 11.

I cannot find out how to copy whilst preserving the original row heights
(which vary throughout the sheet. (I can copy column widths OK via Paste
Special.)

Thanks

KK
 
Hold your Ctrl Key down, Select and hold the actual tab of the work sheet, drag
to the right. You should see a new tab with the old tab's name(2), repeat as
needed. You have created exact duplicattes of your original worksheet



: Hello,
:
: I have a workbook with 12 identical sheets, one for each month of the year.
: I have completed January with the formulae & formatting I want, and now need
: to copy the sheet to the other 11.
:
: I cannot find out how to copy whilst preserving the original row heights
: (which vary throughout the sheet. (I can copy column widths OK via Paste
: Special.)
:
: Thanks
:
: KK
:
:
 
Hi KK

why don't you juse delete the other 11 & duplicate the one you have "got
right", to duplicate it easily, hold your control down & drag the sheet tab
left or right, then left the mouse go and then the control key.

Cheers
JulieD
 
KK

Couple more suggestions.............For the future.

Select your January sheet.

Right-click on the tab and "select all sheets"

Do your formatting etc. on the January sheet. What you do will be replicated
on all the other sheets.

Alternative..........

Open a new workbook, delete all sheets but one. Format that sheet as you
wish.

File>Save as>File Type>Template(*.xlt)

Name it SHEET. Excel will add the XLT.

Store in your XLSTART folder. This now becomes the default Insert>Worksheet.

Gord Dibben Excel MVP
 
Back
Top