Bring Up Pivot Table Options Again
Bottom line: If the pivot tabular array field list went missing on you, this article and video will explicate a few means to make information technology visible again. I besides share a few other tips for working with the field list.
Skill level: Beginner
Scout on YouTube (and requite it a thumbs upwards)
The Pin Table Field Listing Disappeared
Typically when you select a cell inside a pin tabular array, the pivot table field list automatically appears on the right side of the Excel application window in a task pane.
However, the pivot table field list can go missing (go disabled) if you accidentally printing the shut button in the top right corner of the field listing.
The close button hides the field list. This means that it volition NOT reappear when you select a cell inside a pin table.
So how do nosotros make it visible again? Here are a few quick ways to do it.
Method #1: Show the Pin Table Field List with the Correct-click Menu
Probably the fastest way to get it back is to use the right-click bill of fare.
Right-click any prison cell in the pivot table and select Show Field List from the card. This will make the field listing visible again and restore it'due south normal behavior.
The field list volition disappear when a jail cell outside the pivot table is selected, and it volition reappear again when a prison cell inside the pin tabular array is selected.
The Field List Push button is a toggle push. This ways we only have to plough it on/off one time to keep the setting. When nosotros click the close button in the meridian-correct corner of the field list, the toggle will exist turned off. The field list will be hidden until we toggle information technology back on.
Method #ii: Show the Field List from the Ribbon
The field listing can as well exist toggled on/off from the ribbon carte.
- Outset select whatever prison cell inside the pin table.
- Click on the Analyze/Options tab in the ribbon. The tab is chosen Options in Excel 2010 and before.
- Click the Field List push on the correct side of the ribbon. This is as well a toggle push button that will show or hibernate the field listing.
Field List Tip: Undock and Move the Job Pane
The near mutual reason the field listingshut button gets clicked is because the field listing is in the way. Sometimes it covers up the pivot table and forces you lot to gyre horizontally.
We tin really move the field list outside of the Excel application window. You lot tin can even motion it to some other screen if you lot have multiple monitors.
- When y'all hover the mouse over the peak of the field list, the cursor volition turn to cantankerous arrows.
- Left-click and concord to drag and move the field list.
To re-dock the field list,double-click the top of the field list window. That will automatically move it back to its default location on the right side of the Excel awarding window.
Utilize PivotPal to Modify the Pivot Table from the Source Data Sheet
The field listing always disappears when you click a cell outside the pivot table. I have ever thought it would be prissy to be able to run across the field list while working with the source data sheet for the pin table.
So I built this feature into the PivotPal add-in. In the video in a higher place I explain how you can use PivotPal to build and modify the pin table while looking at the source data sail.
This feature saves me a ton of time every twenty-four hour period. I don't have to jump back and forth between the source data and pin tabular array sheets. This is especially useful when searching for a field that I don't know the proper name of.
PivotPal is an Excel Add-in that is packed with features. It will relieve you lot a lot of time when working with pivot tables.
Click hither to learn more about PivotPal
What Are Your Favorite Field List Tips?
Exercise you have any other tips for working with the pin table field list? Please share by leaving a comment below. Thanks!
Source: https://www.excelcampus.com/pivot-tables/pivot-table-field-list-missing/
0 Response to "Bring Up Pivot Table Options Again"
Post a Comment