How to Add a Background Image to an Excel 2007 Worksheet
Adding a Standard Header or Footer in Excel 2007
Applying a Table Style to an Excel 2007 Table

Copying Excel 2007 Formatting with Format Painter

Use the Format Painter button on the Home tab of the Excel 2007 Ribbon to save time when copying formatting between cells in your worksheets. You also can use Format Painter to quickly copy the width of one column to another column. Just select the heading of the first column, click the Format Painter button, and then click the heading of the column where you want to apply the column width.

Double-click the Format Painter tool (instead of clicking it once) to lock it in so you can paint additional cells without having to reselect the tool. Click the Format Painter tool again to unlock it.


Click a cell containing formatting you want to copy.

You only need to select a single cell that contains the desired formatting.


Click the Format Painter button in the Clipboard group on the Home tab.

The mouse pointer changes to a white plus sign with a paintbrush. A marquee displays around the selected cell.


Click or drag across the cells you want to format.

Excel immediately applies formats such as font, size, colors, borders, and alignment.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Hide and Unhide Rows and Columns in Excel 2007
Previewing Excel 2007 Formatting with Live Preview
Hiding and Unhiding Excel 2007 Worksheets
Renaming an Excel 2007 Worksheet
Applying Conditional Formatting in Excel 2007