Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peppermint
 
Posts: n/a
Default Excel 2003 - Copying formatting through 12 worksheets

I have 12 worksheets, one for each month, in the same spreadsheet file. I
have formatted the first one, but how can I copy the formatting (ONLY the
formatting) through to the others without having to do each one separately?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Excel 2003 - Copying formatting through 12 worksheets

If you click the intersection between the row and column identifiers in
your formatted sheet, this will highlight the complete worksheet. Then
click the Format Painter icon, click the second sheet tab and click in
cell A1. Repeat this ten times.

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
Turning off all Automatic Formatting in Excel 2003 Adam M Excel Discussion (Misc queries) 0 November 4th 05 01:07 PM
How copy Excel macros from Excel XP (or before) to Excel 2003? ixoye Excel Worksheet Functions 3 November 3rd 05 08:28 PM
How do I open a Quattro Pro 7.0 file in Excel 2003 cpatrick83 Excel Discussion (Misc queries) 0 August 22nd 05 09:41 PM
Text not copying as text from Word to Excel 2003 Christine Excel Discussion (Misc queries) 4 March 3rd 05 11:33 PM
quattro pro converter Excel 2003 dr88363 New Users to Excel 0 February 27th 05 05:00 PM


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

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

About Us

"It's about Microsoft Excel"