Search Contextures Sites

Excel -- Pivot Tables -- Data Field Layout			Table of Contents
1. Arrange Multiple Data Fields 2. Rename Data Fields Download the zipped sample file

Arrange Multiple Data Fields If you place two fields in the Data area of a Pivot Table, they appear vertically arranged. To make the data easier to read, you can rearrange the table.
Point to the grey button for the Data field Hold the left mouse button, and drag the Data button onto the cell which contains the word 'Total' Release the mouse button
The Data fields will now be arranged horizontally. View video demonstration

Rename Data Fields When you add fields to the Data area, they are renamed, e.g. 'Units' becomes 'Sum of Units'. There are several ways to change the names, but the following is probably the easiest. Select the heading cell in the Pivot Table. Type a new heading. Press the Enter key. Note: The typed name can't be the same as the original field name, i.e., you can't change 'Sum of Units' to 'Units'. However, you can type the original field name, and add a space character at the end, e.g. 'Units '

Pivot Tables -- Introduction  Pivot Tables -- Create a Pivot Table in Excel 2007  Pivot Tables -- Data Field Layout Pivot Tables -- Show and Hide Items Pivot Tables -- Clear Old Items Pivot Tables -- Field Settings Pivot Tables -- GetPivotData Pivot Tables -- Grouping Data Pivot Tables -- Multiple Consolidation Ranges Pivot Tables -- Printing    Pivot Tables -- Custom Calculations  Pivot Tables -- Pivot Cache      Pivot Tables -- Protection   Pivot Tables -- Grand Totals Pivot Tables -- Running Totals   Pivot Tables -- Filter Source Data		Table of Contents

Home     Excel Tips     Excel Files      Blog    Contact
Privacy Policy		The Excel Store	Debra Dalgleish