Copy cell formats with Format Painter : Table Format « Table « Microsoft Office Excel 2007 Tutorial






Select the cell or range. 
           Double-click the Format Painter button on the Home tab
Select the cell or range. Double-click the Format Painter button on the Home tab
Select the cells to copy the style. 
           When you are done, click the Format Painter button again to turn it off
Select the cells. Click the Format Painter button again to turn it off








4.3.Table Format
4.3.1.Apply a Quick Style to a TableApply a Quick Style to a Table
4.3.2.Copy cell formats with Format PainterCopy cell formats with Format Painter
4.3.3.Remove or clear a table styleRemove or clear a table style
4.3.4.Create or Modify a Table StyleCreate or Modify a Table Style
4.3.5.Delete a custom table styleDelete a custom table style
4.3.6.Show or Hide Table Formatting ElementsShow or Hide Table Formatting Elements