copy header/footer btwn sheets

T

Trevor

How do I copy the header/footer from one spreadsheet to another?

Copying the entire worksheet and using Edit->Paste Special->Formats leaves
out the Header/Footer. and I know how to craete a copy of an existing sheet,
but it's a pain to then delete the contents from Sheet1Copy, copy contents
from Sheet2 to Sheet1Copy, delete Sheet2, then rename Sheet1Copy to Sheet2.

I swear I saw somenoe do this years ago with a combination of holding down a
key or keys and clicking on sheet and dragging to another, but I can NOT
remember how to do it.
 
D

DDM

Trevor, group the worksheets, then do the header and footer. Same header and
footer will apply to all grouped sheets.

To group all worksheets: right-click any worksheet tab and select Select all
sheets.
To group some worksheets: From the current worksheet, hold down Crtl and
left-click the other sheets, one by one.

With the sheets grouped, File > Page Setup > Header/Footer.

When done, right-click the current sheet tab and select Ungroup Sheets.
 
T

Trevor

Well, that's cetrainly helpful, but what if I add another sheet later, and I
want it to have the same header/footer? If I add the new sheet, it starts
with no header/footer, and then if I group them and edit the header/footer,
Excel shows me that they're blank, so it would still be helpful to know if
that options still exists - those special/hidden keys to hold down to enable
dragging the header/footers from one spreadsheet to another.... Well, I'll
keep digging myself, as well....
 
G

Gord Dibben

Trevor

Just make sure that the newly inserted worksheet is not the active sheet when
you select the sheets for grouping.

First select a sheet that has the header/footer formatting you want to be
replicated, then group the sheets.

There is no drag/copy option. No special hidden keys to hold down.

You could use VBA to copy from one sheet to the new one.

Gord Dibben Excel MVP
 
D

DebbieG

Gord,

What a great tip! This saved me a great amount of time and no errors.

Thanks,
Debbie


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Trevor

Just make sure that the newly inserted worksheet is not the active sheet
when
you select the sheets for grouping.

First select a sheet that has the header/footer formatting you want to be
replicated, then group the sheets.

There is no drag/copy option. No special hidden keys to hold down.

You could use VBA to copy from one sheet to the new one.

Gord Dibben Excel MVP
 
Top