{"id":7121,"date":"2021-03-30T14:53:18","date_gmt":"2021-03-30T12:53:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=7121"},"modified":"2024-02-06T16:17:41","modified_gmt":"2024-02-06T15:17:41","slug":"show-hide-field-list-in-excel-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-hide-field-list-in-excel-pivot-table\/","title":{"rendered":"Show &#038; Hide Field List in Excel Pivot Table"},"content":{"rendered":"<p>Have you ever had the scenario where you are working on your <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> and the Field List disappears?<\/p>\n<p>Lots of Excel users get annoyed with this but luckily I&#8217;m here to help you out and explain to you How to Show Pivot Table Fields \ud83d\ude42<\/p>\n<p>There are <strong>several methods<\/strong> to show &amp; hide Pivot Table Field List:<\/p>\n<ul>\n<li><a href=\"#using-right-click\"><strong>Using Right Click<\/strong><\/a><\/li>\n<li><a href=\"#using-ribbon\"><strong>Using Ribbon<\/strong><\/a><\/li>\n<li><a href=\"#using-vba\"><strong>Using VBA<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at each method one-by-one!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"using-right-click\"><\/a>Using Right Click<\/span><\/h3>\n<p>If your Pivot Table Field List disappears, you can easily\u00a0bring it back as I show you below!<\/p>\n<p>For our example, this is our <strong>Pivot Table<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-7124\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-01.jpg\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"410\" height=\"321\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-01.jpg 410w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-01-300x235.jpg 300w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/FtN5Il3f8Ag\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/FtN5Il3f8Ag?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<div class=\"after-post-box\">\n<h4>Follow the<strong>\u00a0step-by-step tutorial<\/strong>\u00a0on How to Show Pivot Table Fields\u00a0and\u00a0<strong>download this Excel workbook<\/strong>\u00a0to practice along:<\/h4>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Show-Hide-Field-List.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0To show the field list, <strong>Right Click on your Pivot Table<\/strong> and select <strong>Show Field List.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-7125\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-02.jpg\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"347\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-02.jpg 347w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-02-262x300.jpg 262w\" sizes=\"(max-width: 347px) 100vw, 347px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Your <em><strong>PivotTable\u00a0Field List<\/strong><\/em>\u00a0(renamed to <em><strong>PivotTable Fields<\/strong><\/em> in Excel 2013 and onwards) is now showing!<\/p>\n<p>Let us show in the next step how to hide this.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-7126\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-03.jpg\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"354\" height=\"538\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-03.jpg 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-03-197x300.jpg 197w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong>\u00a0<\/span>To hide the Field List, <strong>Right Click on your Pivot Table<\/strong> and select <strong>Hide Field List.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-7127\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-04.jpg\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"349\" height=\"394\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-04.jpg 349w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-04-266x300.jpg 266w\" sizes=\"(max-width: 349px) 100vw, 349px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Your Pivot Table\u00a0Field List<strong>\u00a0<\/strong>is now hidden!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone wp-image-7128 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-05.jpg\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"410\" height=\"321\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-05.jpg 410w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/09\/Show-Hide-Field-List-05-300x235.jpg 300w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"using-ribbon\"><\/a>Using Ribbon<\/strong><\/span><\/h3>\n<p>The field list for Pivot Table can easily be toggled on and off using the ribbon menu.<\/p>\n<p>&nbsp;<\/p>\n<p>Follow the steps below to show\/hide Pivot Table Field List using the ribbon menu:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong>\u00a0<\/span>Click on any cell in the Pivot Table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23103\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"508\" height=\"445\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png 508w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307-300x263.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong>\u00a0<\/span>Go to <strong>PivotTable Analyze<\/strong> &gt; <strong>Field List<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-308.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23104\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-308.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"1328\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-308.png 1328w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-308-300x29.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-308-1024x98.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-308-768x73.png 768w\" sizes=\"(max-width: 1328px) 100vw, 1328px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>The field list will appear next to the Pivot Table!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-309.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23105\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-309.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"1339\" height=\"476\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-309.png 1339w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-309-300x107.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-309-1024x364.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-309-768x273.png 768w\" sizes=\"(max-width: 1339px) 100vw, 1339px\" \/><\/a><\/p>\n<p>You can hide the list using the same steps.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Go to <strong>PivotTable Analyze<\/strong> &gt; <strong>Field List<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-310.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23106\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-310.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"1331\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-310.png 1331w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-310-300x29.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-310-1024x98.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-310-768x73.png 768w\" sizes=\"(max-width: 1331px) 100vw, 1331px\" \/><\/a><\/p>\n<p>This will hide the field list section from the worksheet!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23103\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"508\" height=\"445\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png 508w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307-300x263.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"using-vba\"><\/a>Using VBA<\/strong><\/span><\/h3>\n<p>You can even use <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"VBA\" data-wpil-keyword-link=\"linked\">VBA<\/a> to show and hide Pivot Table Fields in Excel. Let&#8217;s see how it can be done:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Press<strong> Alt + F11<\/strong> to open the window for <strong>Microsoft Visual Basic for Applications<\/strong>.<\/p>\n<p>Or, Go to <strong>Developer<\/strong> &gt; <strong>Visual Basic<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-311.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23108\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-311.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"1018\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-311.png 1018w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-311-300x37.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-311-768x96.png 768w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Go to <strong>Insert<\/strong> &gt; <strong>Module<\/strong> and copy-paste the following code in it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-349.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23245\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-349.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"555\" height=\"187\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-349.png 555w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-349-300x101.png 300w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>Copy-paste the following code in it:<\/p>\n<p><em>Sub HideFieldList()<\/em><br \/>\n<em>ActiveWorkbook.ShowPivotTableFieldList = False<\/em><br \/>\n<em>End Sub<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-350.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23246\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-350.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"681\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-350.png 681w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-350-300x73.png 300w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Press <strong>Ctrl + S<\/strong> to save the Excel Workbook.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5: <\/strong><\/span>In the dialog box, select <strong>No<\/strong> to save the WorkBook as <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"Macro\" data-wpil-keyword-link=\"linked\">Macro<\/a> enabled.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-351.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23247\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-351.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"652\" height=\"221\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-351.png 652w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-351-300x102.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6: <\/strong><\/span>In the Save as dialog box, select <strong>Excel Macro-Enabled Workbook<\/strong> from Save as type dropdown. Click Save.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-353.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23249\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-353.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"667\" height=\"499\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-353.png 667w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-353-300x224.png 300w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<p><em>Open this Macro-Enabled Workbook!<\/em><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7: <\/strong><\/span>Go to <strong>Developer<\/strong> &gt; <strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"Macros\" data-wpil-keyword-link=\"linked\">Macros<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-354.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23250\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-354.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"830\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-354.png 830w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-354-300x46.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-354-768x117.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 8: <\/span><\/strong>Select HideFieldList and Click Run.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-355.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23251\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-355.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"372\" height=\"365\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-355.png 372w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-355-300x294.png 300w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><\/a><\/p>\n<p>This will hide the field list section from the worksheet!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show &amp; Hide Field List in Excel Pivot Table\"  class=\"alignnone size-full wp-image-23103\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png\" alt=\"Show &amp; Hide Field List in Excel Pivot Table\" width=\"508\" height=\"445\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307.png 508w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/Screenshot-307-300x263.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" title=\"Show The Difference From Previous Years With Excel Pivot Tables | MyExcelOnline\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" sizes=\"(max-width: 300px) 100vw, 300px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" alt=\"Microsoft Excel Training\" width=\"300\" height=\"200\" \/><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>,\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>,\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/power-query-data-cleansing-webinar.html\" target=\"_blank\">Power Query<\/a>,<\/strong>\u00a0and\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever had the scenario where you are working on your Pivot Table and the Field List disappears? Lots of Excel users get annoyed with this but luckily I&#8217;m here to help you out and explain to you How to Show Pivot Table Fields \ud83d\ude42 There are several methods to show &amp; hide Pivot [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17564,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,17],"tags":[268,139],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7121"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7121"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7121\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17564"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}