Copying Excel page formatting to other pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a new user of Microsoft Office 2003 and am having trouble finding help
information on how to copy Excel formatted sheets (pages) to other sheets to
ensure the formatting is the same on additional sheets (pages).
 
One way is to just CTRL-drag the sheet - this will create a copy of the
original sheet (together with all formats and column widths), but, of
course, will also include any data or formulae.

Another way is to highlight all the cells in the first worksheet (click
the intersection of the row and column identifiers) and click <copy>,
then click the second worksheet tab, ensure that the cursor is in A1
and Edit | Paste Special | Formats (check) and OK, followed by <Esc>.

The Format Painter can also be used.

Hope this helps.

Pete
 
Back
Top