Training‎ > ‎Microsoft Excel‎ > ‎Tips & Tricks‎ > ‎

Copy Formats to Multiple Cell Ranges

posted 10 Nov 2011, 12:10 by Gill Flynn   [ updated 11 Nov 2011, 17:10 ]

Microsoft Excel Format Painer

Select a cell or range of cells with formats you want to copy and click the Format Painter. Now "paint" the formats over the cell(s) to repeat with the mouse. Note that if you copy the formats from a column of 8 cells with different formats you can copy this to another column of 8 cells (see picture).

To copy to several non-contiguous cells - double-click the format painter. Press <Esc> when finished.