copy header/footer btwn sheets

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

On Wed, 26 May 2004 09:51:26 -0400, "Trevor"
wrote:

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

"DDM" wrote in message
...
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.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Trevor" wrote in message
...
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.