In the video above I explain how you can use PivotPal to build and modify the pivot table while looking at the source data sheet. So I built this feature into the PivotPal add-in. I have always thought it would be nice to be able to see the field list while working with the source data sheet for the pivot table. The field list always disappears when you click a cell outside the pivot table. Use PivotPal to Modify the Pivot Table from the Source Data Sheet That will automatically move it back to its default location on the right side of the Excel application window. To re-dock the field list, double-click the top of the field list window.
Left-click and hold to drag and move the field list.When you hover the mouse over the top of the field list, the cursor will turn to cross arrows.You can even move it to another screen if you have multiple monitors. We can actually move the field list outside of the Excel application window. Sometimes it covers up the pivot table and forces you to scroll horizontally. The most common reason the field list close button gets clicked is because the field list is in the way. This is also a toggle button that will show or hide the field list.įield List Tip: Undock and Move the Task Pane Click the Field List button on the right side of the ribbon.The tab is called Options in Excel 2010 and earlier. Click on the Analyze/Options tab in the ribbon.First select any cell inside the pivot table.The field list can also be toggled on/off from the ribbon menu. Method #2: Show the Field List from the Ribbon The field list will be hidden until we toggle it back on. When we click the close button in the top-right corner of the field list, the toggle will be turned off. This means we only have to turn it on/off once to keep the setting. The Field List Button is a toggle button. The field list will disappear when a cell outside the pivot table is selected, and it will reappear again when a cell inside the pivot table is selected. This will make the field list visible again and restore it's normal behavior. Right-click any cell in the pivot table and select Show Field List from the menu. Probably the fastest way to get it back is to use the right-click menu. Method #1: Show the Pivot Table Field List with the Right-click Menu So how do we make it visible again? Here are a few quick ways to do it. This means that it will NOT reappear when you select a cell inside a pivot table. However, the pivot table field list can go missing (get disabled) if you accidentally press the close button in the top right corner of the field list. Typically when you select a cell inside a pivot table, the pivot table field list automatically appears on the right side of the Excel application window in a task pane. Watch on YouTube (and give it a thumbs up) The Pivot Table Field List Disappeared I also share a few other tips for working with the field list. Bottom line: If the pivot table field list went missing on you, this article and video will explain a few ways to make it visible again.
0 kommentar(er)
