Copy formats from one cell or range to another

Microsoft Office Excel 2003

Show All Show All

Copy formats from one cell or range to another

  1. Select a cell or range that has the formatting you want to copy.
  2. Do one of the following:
    • To copy the formatting to a cell or range, click Format Painter Button image 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.