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 '

1. Pivot Tables -- Dynamic Data Source 2. Pivot Tables -- Data Field Layout 3. Pivot Tables -- Show and Hide Items 4. Pivot Tables -- Clear Old Items 5. Pivot Tables -- Field Settings 6. Pivot Tables -- GetPivotData 7. Pivot Tables -- Grouping Data 8. Pivot Tables -- Multiple Consolidation Ranges 9. Pivot Tables -- Printing    10. Pivot Tables -- Custom Calculations  11. Pivot Tables -- Pivot Cache        12. Pivot Tables -- Protection      13. Pivot Tables -- Grand Totals		Table of Contents  Dec 20, 2007

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