Menu
Cart 0

Copy Excel Formatting using the Format Painter

Posted by Roger Hyttinen on

Using the Format Painter button on the Home Ribbon allows you to copy the formatting from one cell or cell range to another cell or cell range. This procedure copies all formats including font typeface, number formatting, cell and font color, alignment, etc. to the new cell range. To copy the formatting to several locations, double-click the Format Painter button. It will then continue to be activated until you click its icon to deactivate it.

Format Painter icon

To Copy Formats from One Cell or Cell Range to Another

  1. Select the cell or cell range whose formatting you wish to copy.
  2. Click the Format Painter icon under the Clipboard command set on the Ribbon.
  3. To copy the formatting to several locations, double-click the Format Painter button.
  4. Click on the location(s) to receive the formatting.
  5. If applying formatting to more than one location, click the Format Painter button to deactivate it.

To Copy Column Widths from One Column to Another

  1. Select the heading of the column whose width you wish to copy.
  2. Click the Format Painter icon under the Clipboard command set on the Ribbon.
  3. Click the heading of the new column or column range to which you wish to copy the width.

 

Looking for more Excel tips? Check out our new book Excel 2016:Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks


Share this post



← Older Post Newer Post →


Leave a comment

Please note, comments must be approved before they are published.