Copy formats from one cell or range to another
Microsoft Office Excel 2003
Show All
Copy formats from one cell or range to another
- Select a cell or range that has the formatting you want to copy.
- Do one of the following:
- To copy the formatting to a cell or range, click Format Painter
on the Standard
toolbar.
- To copy the formatting in the selected cell or range to several locations, double-click the Format Painter button. When you finish copying the formatting, click the button again.
- To copy column widths, select the heading of the column that is the width you want to copy, click the Format Painter button, and then click the heading of the column you want to copy the width to.
