How to format pivot tables in excel 2013

Select the check box next to each field name in the field section. On the Options tab, in the Data group, click Refresh.ДЇor more information about working with the PivotTable Field List, see Use the Field List to arrange fields in a PivotTable. If you don't see the fields that you want to use in the PivotTable Field List, you may need to refresh the PivotTable to display any new fields, calculated fields, measures, calculated measures, or dimensions that you have added since the last operation. If you still don't see the PivotTable Field List, on the Options tab, in the Show/Hide group, click Field List. If you don't see the PivotTable Field List, make sure that the PivotTable is selected. To get the final layout results that you want, you can add, rearrange, and remove fields by using the PivotTable Field List. To show field items in table-like form, click Show item labels in tabular form.Д¬hange the field arrangement in a PivotTable To display or hide labels from the next field in the same column in compact form, click Show item labels in outline form, and then select Display labels from the next field in the same column (compact form). To show field items in outline form, click Show item labels in outline form.

In the Field Settings dialog box, click the Layout & Print tab, and then under Layout, do one of the following:

On the Analyze or Options tab, in the Active Field group, click Field Settings. You can also double-click the row field in outline or tabular form, and continue with step 3. This displays the PivotTable Tools tab on the ribbon. To see all data in a traditional table format and to easily copy cells to another worksheet, click Show in Tabular Form.Д¬hange the way item labels are displayed in a layout form To outline the data in the classic PivotTable style, click Show in Outline Form. In compact form, fields are contained in one column and indented to show the nested column relationship. To keep related data from spreading horizontally off of the screen and to help minimize scrolling, click Show in Compact Form. On the Design tab, in the Layout group, click Report Layout, and then do one of the following: This displays the PivotTable Tools, tab on the ribbon. Outline form is similar to tabular form but it can display subtotals at the top of every group because items in the next column are displayed one row below the current item.Д¬hange a PivotTable to compact, outline, or tabular form Tabular form displays one column per field and provides space for field headers. Compact form is saves space and makes the PivotTable more readable and is therefore specified as the default layout form for PivotTables. Expand and Collapse buttons are displayed so that you can display or hide details in compact form. Row labels take up less space in compact form, which leaves more room for numeric data. To make substantial layout changes to a PivotTable or its various fields, you can use one of three forms:Д¬ompact form displays items from different row area fields in one column and uses indentation to distinguish between the items from different fields. Note that the procedures in this topic mention both Analyze and Options tabs together wherever applicable. Important:В The PivotTable Tools tab on the ribbon comes with two tabs - Analyze (in Excel 2013 and later versions) or Options (Excel 2010 and Excel 2010) and Design.

How to format pivot tables in excel 2013