web analytics

Tag Archives: how to format your pivot tables in Microsoft Excel

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