ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 - Copying formatting through 12 worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/65674-excel-2003-copying-formatting-through-12-worksheets.html)

Peppermint

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?

Pete

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



All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com