{"id":563,"date":"2014-10-05T13:55:08","date_gmt":"2014-10-05T11:55:08","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=563"},"modified":"2023-11-30T01:30:20","modified_gmt":"2023-11-30T00:30:20","slug":"excel-sheet-navigator","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-sheet-navigator\/","title":{"rendered":"Excel Sheet Navigator"},"content":{"rendered":"<p>A cool tip that most people may not know and one that is very very handy is the what I call the Sheet Navigator.<\/p>\n<p>If you have lots of worksheets in your workbook and you quickly want to navigate to the last worksheets, all you need to do is Right Click in the bottom left hand corner of your workbook where the sheet arrows are located and this will bring up a list of all your worksheets.<\/p>\n<p>You can also flip back between worksheets but this cool trick is available via the Awesome <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/tab-hound-add-in\/\" target=\"_blank\" rel=\"noopener noreferrer\">Tab Hound Add-In<\/a>.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/bkvz883ZKD4?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><\/p>\n<p><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<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Sheet-Navigator.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Sheet-Navigator.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> <strong>Right-click<\/strong> on the sheet arrows<br \/>\n<img loading=\"lazy\" decoding=\"async\" title=\"Excel Sheet Navigator\"  class=\"alignnone size-full wp-image-20082\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-01.jpg\" alt=\"Excel Sheet Navigator\" width=\"1041\" height=\"515\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-01.jpg 1041w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-01-300x148.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-01-1024x507.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-01-768x380.jpg 768w\" sizes=\"(max-width: 1041px) 100vw, 1041px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> <strong>Select the sheet<\/strong> that you want to navigate to. Click <strong>OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Sheet Navigator\"  class=\"alignnone size-full wp-image-20083\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-02.jpg\" alt=\"Excel Sheet Navigator\" width=\"673\" height=\"391\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-02.jpg 673w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-02-300x174.jpg 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/p>\n<p>You have now jumped to your selected sheet in an instant!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Sheet Navigator\"  class=\"alignnone size-full wp-image-20084\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-03.jpg\" alt=\"Excel Sheet Navigator\" width=\"1059\" height=\"539\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-03.jpg 1059w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-03-300x153.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-03-1024x521.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/excel-sheet-navigator-03-768x391.jpg 768w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/><\/p>\n<p><span style=\"color: #0000ff;\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-722 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/728x901-e1413496235820.gif\" alt=\"728x90\" width=\"599\" height=\"74\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A cool tip that most people may not know and one that is very very handy is the what I call the Sheet Navigator. If you have lots of worksheets in your workbook and you quickly want to navigate to the last worksheets, all you need to do is Right Click in the bottom left [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17498,"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":[7,10],"tags":[62],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/563"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=563"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/563\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17498"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}