Copy Formatting From One Excel Worksheet to Another

Have you ever taken the trouble to format a worksheet - adding bold to your titles, centering column headings, changing the number format to currency in some rows and comma format in others, changing the width of columns - and then wished you could just snap your fingers and take all that formatting over to another worksheet?

The process is actually performed almost as quickly as snapping your fingers. Here's how to copy all of your formatting (not the actual content of the cells, just how they look) from one sheet to another:

 

  1. Click on the Select All button in the upper left corner of the worksheet that contains the desired formatting. [The Select All button is the little gray square above row number 1 and to the left of column A.]

     

  2. Click on the Format Painter button on the Standard toolbar. [The Format Painter button is the one with the paintbrush.]

     

  3. Click on the sheet tab at the bottom of the screen for the sheet that is to receive the formatting, or open another Excel file that you want to format.

     

  4. Click on the Select All button in the new sheet. Presto! All of your formatting has transferred!

View more helpful tips!


Already a member? log in here.

Editor's Choice