Format mulitple worksheets

  • Thread starter Thread starter DaveS
  • Start date Start date
D

DaveS

How can I copy formats such as margins, header and
footers and other page setups from one worksheet to
another. When I copy the entire worksheet, the formats
for the individual cells will copy, but not the page
formats.
 
How are you performing the copy ?

An *exact* copy can be made by simply right clicking in the tab,
Choose "Move or Copy",
Check the "Create a Copy" box,
Click <OK>,
And you now have an *exact* copy of the WS, where the tab has the name of
the original sheet with a (2) appended to it.
Right click in this tab, and rename it.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How can I copy formats such as margins, header and
footers and other page setups from one worksheet to
another. When I copy the entire worksheet, the formats
for the individual cells will copy, but not the page
formats.
 
Back
Top