web analytics

HOW TO FORMAT YOUR PIVOT TABLES IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

With this article you will be able to learn how to format your pivot tables in Microsoft Excel 2013. Formatting a new pivot table in Excel 2013 is quick and easy. All you need to do is click a cell of the pivot table. To add the pivot table tools can textual tab to the ribbon and then click it’s designed tab to display the command buttons. The design tab is divided into three groups. The layout group lets you add subtitles and grand totals to the pivot table and modify its basic layout.

The pivot table style options group enables you to refine the pivot table style you select using the pivot table styles gallery to the right and the pivot table styles group contains the gallery of styles you can apply to the active pivot table by clicking the desired style thumbnail.

1

When selecting a formatting style for your pivot table you can use Excels live preview feature to see how the pivot table would look in any style that you highlight in the gallery with your mouse or touch pointer. You can then refine the style using the check box command buttons in the pivot table style options group.

To format the sums values entered as the data items of the pivot table with an Excel number format click the field in the table that contains the words Sum of and the name of the field whose values are summarized there. Click the field settings button in the active fields group on the analyze tab.

2

Put the number format command button in the value field settings dialog box to open the format cells dialog box with its all number tab.

3

In the category list box click the type of number format you want to assign to the values of the pivot table. Click ok twice, the first time to close the format cells dialog box and the second to close the value field settings dialog box.

4

Leave a Reply