Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Add Comments to Excel 2013 Worksheet Cells
How to Select Cells in Excel 2013 with Go To
How to Merge Custom Styles into Other Excel 2013 Workbooks

How to Use the Excel 2013 Format Painter

Step 3 of 3
Next Slideshow
Next Slideshow

Drag the mouse pointer through the range of cells that you want formatted identically to the sample cell.

The moment that you release the mouse button, the cells in the range that you just selected with the Format Painter become formatted the same way as the sample cell.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Select Cells in Excel 2013
How to Create a Custom Cell Style in Excel 2013
Highlight Cells Rules in Excel Dashboards and Reports
Use Symbols to Enhance Reporting in Excel
Format Cells from the Ribbon in Excel 2013
Advertisement

Inside Dummies.com