Tip Printed from ExcelTip.com

---

Copying Formatting in Excel 2007


To copy the cell(s) formatting, use the Format Painter:

Select Home -> Format Painter icon
(in Clipboard Group).

Or

Right click the cell(s) and click the
Format Painter icon.

To repeatedly copy formatting:

Double-click the Format Painter icon to repeatedly apply formatting.