Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Format Values in the Pivot Table in Excel 2013

Excel 2013 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data or list of data. All you need to do is click a cell of the pivot table to add the PivotTable Tools contextual tab to the Ribbon and then click its Design tab to display its command buttons.

To format the summed values entered as the data items of the pivot table with an Excel number format, you follow these steps:

1

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.

2

Click the Number Format command button in the Value Field Settings dialog box to open the Format Cells dialog box with its sole Number tab.

Excel opens the Format Cells dialog box.

3

Click the type of number format you want to assign to the values in the pivot table on the Category list box of the Number tab.

This allows you to manually enter the type of formatting for your pivot table.

4

Modify any other options for the selected number format, such as Decimal Places, Symbol, and Negative Numbers that are available for that format.

This is an optional step, but comes in handy for fine tuning to your needs.

5

Click OK twice, the first time to close the Format Cells dialog box, and the second to close the Value Field Settings dialog box.

Now you are ready to use your newly formatted pivot table.

 
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!