How to Move the Excel 2007 PivotTable Field List
The PivotTable Field List is viewable in any Microsoft Excel 2007 worksheet that contains a PivotTable. While the Field List is not always visible, users can make it appear and disappear with the click of a mouse button and move it in just a couple of steps. Moving the Field List frees up space on the Excel screen for viewing more of a PivotTable.
Other People Are Reading
Things You'll Need
- Computer with Excel 2007 installed
- Excel workbook containing a PivotTable
Instructions
-
-
1
Open the Excel workbook and navigate to the worksheet containing your PivotTable.
-
2
If the Field List is not visible on the screen, click the “Field List” button in the Show/Hide group. The Field List appears on the right side of the Excel window. Click “Field List” or the “X” at the far right of the title bar to hide the Field List.
-
-
3
Move the Field List by moving the mouse pointer to the title bar of the Field List, clicking and holding down the left-side mouse button and dragging the mouse across the screen. You may also left-click on the down arrow on the Field List title bar, click “Move” from the resulting menu and drag the mouse across the screen. Note that the Field List changes from a box as tall as the spreadsheet display to a shorter box when you drag it away from the right side of the window.
-
4
Moving the Field List or any task pane or toolbar to its original location with a set of toolbars or attached to one side of the screen is called “docking” it. Double click the PivotTable Field List title bar to return it to its previous docked position in the Excel window.
-
5
To dock the Field List on the left side of the window, click and drag the title bar across the screen until the box again becomes as tall as the spreadsheet display, and release the mouse button.
-
1
Tips & Warnings
Resize the PivotTable Field List by clicking the down arrow on the title bar and clicking “Size.” When the Field List is docked on either side of the window, resizing allows you to expand or contract the width of the list. When the Field List is not docked, you will be able to resize it both horizontally and vertically.
