Thursday, September 26, 2013

How to Move the Excel 2007 Pivot Table Field List


1. Open the Microsoft Excel 2007 application on your computer. Click on the 'Microsoft Office' button and the select the 'Open' option.
2. Locate the Excel 2007 file that contains the PivotTable that you want work with and then click on the 'Open' button to load the file onto your spreadsheet.
3. Click on the 'Options' tab if you don't see the PivotTable Field List after you've clicked on your PivotTable. Click on the 'Field List' option from the 'Show/Hide' group.
4. Locate the layout section at the bottom of the Field List and then click on the 'Move Up' option to move any select field in the list up one position. Click on the 'Move Down' option to move a field down one position.
5. Click on the 'Move to Beginning' option to move a field to the top of the list. Click on the 'Move to End' option to move the field to the bottom of the list.
6. Click one of the options to move a field to the 'Report Filter,' 'Row Labels,' 'Column Labels' or 'Values' area of your PivotTable.

Blogger news