In Excel 2003, I thought there was a shortcut key for applying sheet level
formatting (e.g., margins, headers, footers, etc) from one sheet to another,
but can't seem to find it anywhere.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

If an existing sheet is already setup, you could group the sheets.
And with the good one active
file|page setup
click ok
and then ungroup the sheets.

Lots of those print settings get copied to the other sheets in the group.

It can be lots easier to copy the worksheet that's setup, then make changes to
the data--instead of starting with an empty worksheet.

If you have lots of these to do, you may want to make a worksheet and use it as
a template for other new worksheets.

M Kan wrote:

In Excel 2003, I thought there was a shortcut key for applying sheet level
formatting (e.g., margins, headers, footers, etc) from one sheet to another,
but can't seem to find it anywhere.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

--

Dave Peterson

OK, now I feel stupid. The last time I tried to do that was probably on an
older version of Excel, where it didn't work. Thanks
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Dave Peterson" wrote:

If an existing sheet is already setup, you could group the sheets.
And with the good one active
file|page setup
click ok
and then ungroup the sheets.

Lots of those print settings get copied to the other sheets in the group.

It can be lots easier to copy the worksheet that's setup, then make changes to
the data--instead of starting with an empty worksheet.

If you have lots of these to do, you may want to make a worksheet and use it as
a template for other new worksheets.

M Kan wrote:

In Excel 2003, I thought there was a shortcut key for applying sheet level
formatting (e.g., margins, headers, footers, etc) from one sheet to another,
but can't seem to find it anywhere.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

--

Dave Peterson

Select the sheet with the formatting you want to replicate.

CTRL + Click on other sheet.

FilePage SetupOK


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 08:40:03 -0700, M Kan <tipsoftheweek at gmail dot com
wrote:

In Excel 2003, I thought there was a shortcut key for applying sheet level
formatting (e.g., margins, headers, footers, etc) from one sheet to another,
but can't seem to find it anywhere.