How to Use the Excel 2013 Quick Analysis Tool
How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool
Use Excel Pivot Tables to Get Top and Bottom Views

How to Format Values in the Pivot Table in Excel 2013

Step 1 of 5
Next Slideshow
Next Slideshow

Click on any field in the column you want to format. Click the Fields Settings button in the Active Field group of the Analyze tab.

Excel opens the Value Field Settings dialog box.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
How to Add Calculated Fields to Pivot Tables in Excel 2013
How to Move Pivot Charts in Excel 2013
How to Move Pivot Charts to Separate Sheets in Excel 2013
Create a Histogram with a Pivot Table for Excel Dashboards
How to Filter Column and Row Fields in Excel 2013