Format Painter in Excel

Print Friendly, PDF & Email

I can never remember how to use the Format Painter in Excel.

Select the shape, text, or cell that has the format which you want to copy.

(Excel may then show the Format Painter symbol – a paint brush, but if it doesn’t then…)

On the Home tab, click on Format Painter (double click if you want to copy to multiple locations)

Select the shape, text, or cell that needs to be formatted – you can drag the pointer across a range of cells if you want to.

To stop formatting, press ESC.

To copy a column width, select the heading of the first column, click Format Painter, then click on the heading of the column you want to apply the width to.

Be Sociable, Share!

Leave a Reply

Your email address will not be published. Required fields are marked *