Browse » Home
Thursday, July 28, 2011
How to Move the Excel 2007 PivotTable Field List
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.