Format Painter

Use the Format Painter to quickly copy formatting from one thing in a document to another. Select the thing you like the look of, click Format Painter, and then click the thing you want to change to look the same. If you want to copy the formatting to more than one thing, double-click instead of single-clicking Format Painter. To exit the Format Painter, press Esc. Format Painter picks up all the formatting from your first thing, whether it’s a shape, cell, picture border, or piece of text, and applies it to the second. This way, you can spend your time getting the first thing right, and apply the same formatting wherever you want in your document with a couple of clicks. Pick your app to learn more. Select the shape, text, picture, or worksheet cell with the formatting you want to copy.Format Painter on the Home tab in Excel

Click Home, and in the Clipboard group, click Format Painter.

After the pointer changes to a paintbrush, select the shape, text, or worksheet cell that you want to format.To copy the formatting to a single cell, several cells, or a range or ranges of cells, drag the mouse pointer across the cells or ranges of cells that you want to format.

Tip: To quickly copy the width of one column to a second column, select the heading of the first column, click Format Painter, and then click the heading of the second column. You can’t copy the column width if the column contains a merged cell.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment