Helpdesk Baruch College

Replicate Excel Formatting the Easy Way with Format Painter

The Format Painter in Excel makes it simple to replicate the formatting of a cell and also apply it to one more. With simply a couple of clicks you can replicate formatting such as fonts, positioning, text dimension, boundary, and background shade.

On any kind of Excel worksheet, click on the cell with the formatting you ‘d like to duplicate. You will certainly see rushed lines around the picked cell. After that pick the Home tab and click on the Format Painter.

You’ll see your arrow now includes a paintbrush graphic. Relocate to the cell where you ‘d like to apply the format as well as click it.

Your target cell will certainly now have the new formatting.

If you double-clicking on Format Painter you can then click on several specific files to which to use the layout. Or, you can click as well as drag throughout a team of cells. When you are completed applying layouts, click Format Painter once more, or on the Esc key, to turn it off.

The Format Painter is an extremely straightforward, yet incredibly beneficial as well as time saving tool when producing intricate worksheets.

Exit mobile version
Skip to toolbar