Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Select Cells in Excel 2013
How to Select Cells in Excel 2013 with Go To
How to Create a Custom Cell Style in Excel 2013

How to Use the Excel 2013 Format Painter

Step 1 of 3
Previous
Next Slideshow
Next Slideshow

Position the cell cursor in a cell that contains the formatting that you want copied to another range of cells in the spreadsheet.

This cell becomes the sample cell whose formatting is taken up by Format Painter and copied in the cells that “paint” with its special mouse pointer.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Add Comments to Excel 2013 Worksheet Cells
How to Merge Custom Styles into Other Excel 2013 Workbooks
Excel Reports: Custom Number Formatting
Enhance Your Excel Reports with Conditional Formatting
Apply Top/Bottom Rules in Excel Dashboards and Reports
Advertisement

Inside Dummies.com