{"id":397275,"date":"2022-01-21T19:00:55","date_gmt":"2022-01-21T16:00:55","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-the-navigation-pane-in-microsoft-excel\/"},"modified":"2022-01-21T19:00:55","modified_gmt":"2022-01-21T16:00:55","slug":"how-to-use-the-navigation-pane-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/","title":{"rendered":"#How to Use the Navigation Pane in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2dd373170ef\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2dd373170ef\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/#What_Is_the_Navigation_Pane\" >What Is the Navigation Pane?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/#Show_the_Navigation_Pane_in_Excel\" >Show the Navigation Pane in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/#Use_the_Navigation_Pane_in_Excel\" >Use the Navigation Pane in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/#Navigation\" >Navigation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/#Actions\" >Actions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/#Search\" >Search<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-navigation-pane-in-microsoft-excel\/#Handy_Uses_for_the_Navigation_Pane\" >Handy Uses for the Navigation Pane<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use the Navigation Pane in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To move around your workbook easier, find the content you need faster, and update basic properties in one spot, the Navigation pane in Microsoft Excel is a handy tool. Let\u2019s take a look at how you can use it.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"What_Is_the_Navigation_Pane\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">What Is the Navigation Pane?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft introduced the Navigation pane to provide a better Excel experience to those with disabilities, those using an unfamiliar workbook, and those who have tons of sheets in a workbook. The tool offers a way to quickly move to a sheet, chart, table, or object as well as a search to find exactly what you need in a flash.<\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/inspiration-for-inclusive-features-comes-from-customers\/ba-p\/2567520\">The Navigation pane<\/a> is available to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/insider.office.com\/en-us\/\">Office Insiders<\/a> and will slowly roll out to Microsoft Excel on Windows users.<\/p><\/blockquote>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Show_the_Navigation_Pane_in_Excel\"><\/span>Show the Navigation Pane in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To open the Navigation pane, head to the View tab and click \u201cNavigation\u201d in the Show section of the ribbon. You\u2019ll then see the pane on the right side of the Excel window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-776733\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/ViewNavigation-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Navigation on the View tab\" width=\"650\" height=\"372\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_Navigation_Pane_in_Excel\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Use the Navigation Pane in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As mentioned, the Navigation pane helps you move to a spot in your workbook, adjust some basics for your sheets and items, and find what you want in the workbook. Let\u2019s delve into how this works.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Navigation\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Navigation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When you first open the Navigation pane, you\u2019ll see all of the sheets in the workbook listed in order. Simply click a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/276285\/how-to-rename-worksheet-tabs-in-excel\/\">sheet name in the list to move directly to it in the workbook. If you select a sheet tab, you\u2019ll also see the sheet name in bold font in the pane.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-776732\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/SheetList-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sheet list in the Navigation pane\" width=\"291\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Each sheet in the list also has an arrow to the left allowing you to expand it. You\u2019ll then see the various objects, tables, charts, and other items on the sheet. You can click an item to move directly to it on the sheet as well.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-776731\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/ExpandSheet-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Expand a sheet in the pane\" width=\"304\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Actions\"><\/span>Actions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To rename, delete, or <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/218611\/how-to-show-and-hide-the-worksheet-tabs-in-excel\/\">hide or show a sheet, both in the Navigation pane and in the workbook, right-click the sheet\u2019s name in the pane. This gives you an easy way to take one of these actions on a spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-776735\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/RenameDeleteHideSheet-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Rename, delete, or hide a sheet\" width=\"300\" height=\"302\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also adjust certain types of items on a sheet in the Navigation pane. For example, you can rename a table, hide a picture, or delete a chart. Expand the sheet containing the item and then right-click the item for the available actions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-776736\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/RenameDeleteHideChart-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Rename, delete, or hide a chart\" width=\"300\" height=\"222\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Search\"><\/span>Search<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>At the top of the Navigation pane is the Search box. This provides the fastest way to find what you need in your workbook. You can type \u201cTable\u201d to see where all of the tables are located or \u201cPicture\u201d to find all of the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/764451\/how-to-insert-a-picture-in-microsoft-excel\/\">images that have been inserted.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-776739\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/SearchTable-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Search for a table\" width=\"300\" height=\"308\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish using the Search box, click the \u201cX\u201d on the right to close it and return to the sheet list.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Handy_Uses_for_the_Navigation_Pane\"><\/span>Handy Uses for the Navigation Pane<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By using the Navigation pane, you can easily move between the spreadsheets you need. This eliminates <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/247834\/how-to-fix-arrow-key-scrolling-in-excel\/\">using the scroll arrows or dots to move across the bottom of the Excel window to the sheet you want. But there are some other convenient ways to use the Navigation pane.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Fix Arrow Key Scrolling in Excel<\/em><\/strong><\/p>\n<p>For instance, maybe you want to make sure you\u2019ve given all of the charts in the workbook titles. Type \u201cChart\u201d into the Search box and you\u2019ll see each one listed along with its title. You can then click to visit those without titles or using the default \u201cChart Title\u201d and give them those much-needed names.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-776738\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/SearchChart-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Search for a chart\" width=\"300\" height=\"318\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As another example, you may have inserted check boxes in your workbook but forgot to name them for backend references. You can type \u201cCheck Box\u201d into the Search field to see them all listed. Then, right-click to rename each one directly in the Navigation pane without having to open the containing sheets.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-776741 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/12\/SearchCheckBoxes-ExcelNavigationPane.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Search for and rename check boxes\" width=\"300\" height=\"278\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For an easier way to move around, find items, and take quick actions, check out the Navigation pane in Microsoft Excel for Windows.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Insert a Checkbox in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/776709\/how-to-use-the-navigation-pane-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use the Navigation Pane in Microsoft Excel&#8221; To move around your workbook easier, find the content you need faster, and update basic properties in one spot, the Navigation pane in Microsoft Excel is a handy tool. Let\u2019s take a look at how you can use it. What Is the Navigation Pane? Microsoft introduced&#8230;<\/p>\n","protected":false},"author":1,"featured_media":397276,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-397275","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/397275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=397275"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/397275\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/397276"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=397275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=397275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=397275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}