Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
crazycanuck
 
Posts: n/a
Default Copying Excel page formatting to other pages

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).
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Pete_UK
 
Posts: n/a
Default Copying Excel page formatting to other 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Launch new browser window from an excel web page Hal Anderson Excel Discussion (Misc queries) 2 January 20th 06 02:10 AM
Excel 2003 - Copying formatting through 12 worksheets Peppermint Excel Discussion (Misc queries) 1 January 17th 06 08:55 PM
Excel changing number formatting and source data in graphs on it's own!!! JohnHamer Excel Discussion (Misc queries) 2 September 22nd 05 02:29 PM
lose formatting (border) in excel cell after pasting from word Reverse_Solidus Excel Discussion (Misc queries) 2 March 16th 05 10:01 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"