Excel 2003 - Copying formatting through 12 worksheets

P

Peppermint

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?
 
P

Pete

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top