copying row heights

[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

 

[Lady Layla]

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
:
:

 

[JulieD]

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]

Many thanks,

KK

 

[Gord Dibben]

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