{"id":3329,"date":"2018-11-10T10:14:17","date_gmt":"2018-11-10T10:14:17","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3329"},"modified":"2024-03-28T12:03:17","modified_gmt":"2024-03-28T12:03:17","slug":"pivot-table-field-list-missing","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/","title":{"rendered":"Pivot Table Field List Missing in Excel"},"content":{"rendered":"\n
Pivot-Table-Field-List-Missing<\/a>Download File<\/a><\/div>\n\n\n\n

After you create a pivot table, you can accidentally close the field list. If you click the pivot table it won\u2019t appear. It\u2019s easy to make it appear again. If you want to have it back, follow these steps.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
    \n
  1. Click inside the pivot table.<\/li>\n\n\n\n
  2. On the ribbon<\/a>, look at Analyze >> Show<\/strong> Here, you can find a toggle button called Field List<\/strong>. Currently, it\u2019s unchecked<\/li>\n\n\n\n
  3. Check this button to enable<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
      \n
    1. Now, the field list is on the right side, as it was before.<\/li>\n<\/ol>\n\n\n\n

      Show Field List using a contextual menu<\/h2>\n\n\n\n

      In this method, you can show Field List<\/strong> by right-clicking the pivot table and choosing the Show Field List<\/strong> option.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      When the Field List<\/strong> is present, you can turn it off, the same way, but this time by choosing Hide Field List<\/strong>.<\/p>\n\n\n\n

      Keyboard shortcut<\/h2>\n\n\n\n

      There is another way to do it if you want to access this option with a keyboard shortcut.<\/p>\n\n\n\n

      Click the pivot table and press the following buttons – one after another.<\/p>\n\n\n\n

      Left Ctrl >> j >> t >> l<\/p>\n\n\n\n

      It will turn on the Field List<\/strong> button. Do it again and it will turn it off.<\/p>\n","protected":false},"excerpt":{"rendered":"

      After you create a pivot table, you can accidentally close the field list. If you click the pivot table it won\u2019t appear. It\u2019s…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nPivot Table Field List Missing in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to show the missing Pivot Table Field List in Excel with our easy-to-follow guide. Follow simple steps or use a keyboard shortcut.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot Table Field List Missing in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to show the missing Pivot Table Field List in Excel with our easy-to-follow guide. Follow simple steps or use a keyboard shortcut.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-10T10:14:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T12:03:17+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Pivot Table Field List Missing in Excel\",\"datePublished\":\"2018-11-10T10:14:17+00:00\",\"dateModified\":\"2024-03-28T12:03:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/\"},\"wordCount\":207,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/\",\"name\":\"Pivot Table Field List Missing in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png\",\"datePublished\":\"2018-11-10T10:14:17+00:00\",\"dateModified\":\"2024-03-28T12:03:17+00:00\",\"description\":\"Learn how to show the missing Pivot Table Field List in Excel with our easy-to-follow guide. Follow simple steps or use a keyboard shortcut.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pivot Table Field List Missing in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pivot Table Field List Missing in Excel","description":"Learn how to show the missing Pivot Table Field List in Excel with our easy-to-follow guide. Follow simple steps or use a keyboard shortcut.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/","og_locale":"en_US","og_type":"article","og_title":"Pivot Table Field List Missing in Excel","og_description":"Learn how to show the missing Pivot Table Field List in Excel with our easy-to-follow guide. Follow simple steps or use a keyboard shortcut.","og_url":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/","article_published_time":"2018-11-10T10:14:17+00:00","article_modified_time":"2024-03-28T12:03:17+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Pivot Table Field List Missing in Excel","datePublished":"2018-11-10T10:14:17+00:00","dateModified":"2024-03-28T12:03:17+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/"},"wordCount":207,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/","url":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/","name":"Pivot Table Field List Missing in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png","datePublished":"2018-11-10T10:14:17+00:00","dateModified":"2024-03-28T12:03:17+00:00","description":"Learn how to show the missing Pivot Table Field List in Excel with our easy-to-follow guide. Follow simple steps or use a keyboard shortcut.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/pivot-table-field.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-field-list-missing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Pivot Table Field List Missing in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3329"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3329"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3329\/revisions"}],"predecessor-version":[{"id":15501,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3329\/revisions\/15501"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}