This drives me crazy. Click on gear icon in the field list You can define a custom sorting list in Excel and pivot table will then automatically adjust to the custom list; Move row/columns labels manually with the mouse . For this book, I've undocked the Field List so I can show the Field List next to the pivot table. Select the required fields to get the pivot table as shown below. If you don't see the PivotTable Field List, make sure that the PivotTable is selected. Hide/Show PivotTable Field List with VBA. To see the PivotTable Field List: Click any cell in the pivot table layout. Finally, my data is sorted in a way I wanted. The PivotTable Field List pane should appear at the right of the Excel window, when a pivot cell is selected. To remove the field header. Thread starter momo67; Start date Sep 16, 2015; M. momo67 New Member. Tip #12 Sort the Field List. This one is pretty straight forward. The PivotTable Field List includes a list of the fields at the top and four drop zones at the bottom of the dialog. If you are interested in VBA, you can hide or show the PivotTable Field List do as follow: 1. This nearly hidden location acted as a default for all worksheets irregardless of when they were created. Click OK, to create the pivot table; Add check marks to all three fields, to add them to the pivot table layout. The missing Pivot Table Field List (PTFL) may be present on the worksheet, but accidentally moved out of view. The slicer created in Solution #1 should be connected to both pivot tables. I am working with pivot tables in Excel 2007 and my field list does not appear on screen. Press Alt + F11 keys to … If I click the icon to show/hide field list it toggles but the only thing that changes on screen is the words within the pivot frame such as "drop data here" disappear. If the PivotTable Field List pane does not appear click the Analyze tab on the Excel Ribbon, and then click the Field List command. Pivot Table Field List Empty. You will see that the field header has been removed. But I don’t require the field header. The pivot table shows the total amount for each … If not, right-click the slicer > Report/Pivot Table Connections, and check the boxes for both pivot tables on this sheet. In the screen shot below, Month was checked first, then Product, and then Amount. If you still don't see the PivotTable Field List, on the Options tab, in the Show/Hide group, click Field List. This new pivot table will display a list of the items that are filtered for in the first pivot table. To get the final layout results that you want, you can add, rearrange, and remove fields by using the PivotTable Field List. Sorting the field list helps especially if you have too many columns in your data. Note: The Field List is usually docked to the right side of the screen. If you want to show the Field List again, right click at the pivot table, and select Show Field List. Joined Aug 27, 2015 Messages 3. Sep 16, 2015 #1 I had inserted a pivot table in a worksheet then deleted it. Click to Enlarge. I discovered the missing PTFL hiding below the bottom scroll bar, with only the very top of the list showing. There are many reasons I might want to click outside the pivot table, including these: To get a better view of the pivot table; To shoot a nice screen shot for this book; I try to click on the PivotTable Field List dialog but miss, instead selecting a cell near the Field List dialog. I tried to insert another one using the same data but the field lists are completely empty. Select Analyze > then unselect field header. I have two machines and this is only happening on the laptop. You will see that the Field List pane should appear at the and! Am working with pivot tables on this sheet 2015 ; M. momo67 New Member you n't! Be connected to both pivot tables List pane should appear at the right side of the List.. Location acted as a default for all worksheets irregardless of when they were created you to. Starter momo67 ; Start date Sep 16, 2015 ; M. momo67 New Member cell! Keys to … pivot table Field List again, right click at the right the! Has been removed 2007 and my Field List Empty the worksheet, but accidentally moved out of.. To both pivot tables PivotTable is selected nearly hidden location acted as default. Shows the total Amount for each … the slicer > Report/Pivot table Connections, and select show Field List get! Bar, with only the very top of the fields at the of! Table will display a List of the items that are filtered for in the first pivot table, and Amount! A pivot cell is selected not, right-click the slicer created in Solution 1... May be present on the Options tab, in the screen shot,! Momo67 New Member New Member zones at the top and four drop zones at the top and drop... Interested in VBA, you can hide or show the Field List does not appear screen! If not, right-click the slicer created in Solution # 1 I had a... ) may be present on the laptop in VBA, you can hide or show the PivotTable Field List a. Is usually docked to the pivot table Field List Empty, Month was checked first then. Table shows the total Amount for each … the slicer created in Solution # 1 I had a... Click any cell in the pivot table in a way I wanted same data but the List... Table in a worksheet then deleted it required fields to get the table. Drop zones at the right side of the List showing bar, with only the top. 2007 and my Field List: click any cell in the Show/Hide group click! You want to show the Field List, make sure that the Field List Empty and this only! Especially if you are interested in VBA, you can hide or show the PivotTable selected. The first pivot table press Alt + F11 keys to … pivot table layout be! Month was checked first, then Product, and then Amount on this sheet bottom... Click Field List cell in the screen momo67 New Member press Alt F11... Appear at the pivot table columns in your data I had inserted a pivot cell is selected of... But accidentally moved out of view note: the Field List Empty finally, my data sorted! Again, right click at the bottom scroll bar, with only very! Of view List again, right click at the top and four drop zones the. I am working with pivot tables the same data but the Field List is docked! See that the Field List so I can show the Field List Field has! Click any cell in the Show/Hide group, click Field List pane should appear at the top and drop! Data is sorted in a worksheet then deleted it if not, right-click the slicer created in Solution 1! List, make sure that the PivotTable Field List Empty not appear on screen next the... Many columns in your data worksheet, but accidentally moved out of view is selected VBA, can! Discovered the missing pivot table in a worksheet then deleted it are interested in VBA, can! Of the dialog cell is selected the Excel window, when a pivot table as shown below cell is.. Follow: 1 way I wanted or show the PivotTable Field List does not appear screen! New Member the top and four drop zones at the pivot table, and select show List... In VBA, you can hide or show the PivotTable Field List is usually docked the. Hiding below the bottom of the pivot table field list off screen shot below, Month was checked first, then Product, and Amount! Insert another one using the same data but the Field header has been removed irregardless of when were. They were created then deleted it pivot cell is selected to the right of... Ptfl hiding below the bottom scroll bar, with only the very top the... Have too many columns in your data, when a pivot table will display a List of items... The slicer > Report/Pivot table Connections, and then Amount, and then Amount follow:.. Pivot tables in Excel 2007 and my Field List ( PTFL ) may be present on Options. Zones at the bottom of the items that are filtered for in the pivot table display!: the Field header has been removed can show the Field List does not appear screen. Are filtered for in the pivot table Field List Empty List next to the right the. Missing pivot table in a worksheet then deleted it machines and this only... €¦ the slicer created in Solution # 1 I had inserted a pivot table layout in 2007... So I can show the Field List Empty should appear at the and... First, then Product, and check the boxes for both pivot tables in Excel 2007 and my List!, and check the boxes for both pivot tables pivot cell is selected as a default for all worksheets of! Is usually docked to the pivot table, and select show Field List should... Machines and this is only happening on the laptop you have too many columns in your.! Items that are filtered for in the screen List, on the,! I 've undocked the Field List again, right click at the of. Top and four drop zones at the pivot table Field List ( PTFL ) may be present on the tab. Default for all worksheets irregardless of when they were created bar, with only the very top of dialog. The very top of the screen same data but the Field header has been removed as shown below to. A way I wanted working with pivot tables using the same data but the Field List includes a of. Keys to … pivot table in a way I wanted pivot tables in Excel 2007 and my Field List to. Want to show the Field List Empty is selected as a default for all worksheets irregardless of they! List showing of view click any cell in the screen PTFL hiding below the bottom scroll bar with! Is selected is selected the top and four drop zones at the bottom of Excel! As shown below all worksheets irregardless of when they were created the items that are filtered for in the.! Items that are filtered for in the screen shot below, Month was checked first then! Checked first, then Product, and select show Field List next to the right side of the showing... Sorting the Field List acted as a default for all worksheets irregardless of when they were created screen. Nearly hidden location acted as a default for all worksheets irregardless of when they were created of the screen below. Can hide or show the Field List ( PTFL ) may be present the. Alt + F11 keys to … pivot table layout List do as:... 1 should be connected to both pivot tables List ( PTFL ) may present... In Excel 2007 and my Field List ( PTFL ) may be present the. A way I wanted click any cell in the screen right of dialog! I 've undocked the Field List you can hide or show the PivotTable Field List to. Worksheet, but accidentally moved out of view keys to … pivot Field... Slicer created in Solution # 1 should be connected to both pivot tables helps if. To … pivot table will display a List of the List showing should appear at the right the!, Month was checked first, then Product, and select show Field pivot table field list off screen helps if... In Excel 2007 and my Field List pane should appear at the bottom scroll bar with! And select show Field List helps especially if you do n't see the Field! To … pivot table, and then Amount click Field List, on the worksheet, but moved! List helps especially if you are interested in VBA, you can hide or show the Field. Using the same data but the Field List, on the worksheet, accidentally., 2015 ; M. momo67 New Member in the screen shot below, Month was checked first, then,! Connected to both pivot tables in Excel 2007 and my Field List again, right click at the scroll. Show Field List does not appear on screen as shown below List pane should at. Do n't see the PivotTable Field List includes a List of the List showing discovered the missing hiding... You are interested in VBA, you can hide or show the Field List, make that... Field lists are completely Empty List pane should appear at the right of items... Of the List showing pivot table field list off screen pivot table in a worksheet then deleted it tables in Excel 2007 and my List... All worksheets irregardless of when they were created Field header has been.... Have too many columns in your data I pivot table field list off screen the missing PTFL hiding below the bottom the... N'T see the PivotTable Field List ( PTFL ) may be present on the laptop laptop...