{"id":8441,"date":"2018-10-12T15:27:44","date_gmt":"2018-10-12T13:27:44","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=8441"},"modified":"2024-05-06T12:39:38","modified_gmt":"2024-05-06T10:39:38","slug":"how-to-view-multiple-worksheets-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-view-multiple-worksheets-in-excel\/","title":{"rendered":"How to View Multiple Worksheets in Excel"},"content":{"rendered":"<p>I usually have a workbook that has a lot of worksheets, and I have to view multiple sheets at the same time. Switching tabs back and forth just to compare the contents drives me nuts!!<\/p>\n<p>Did you know that you can\u00a0<strong>view multiple worksheets\u00a0<\/strong>in Excel? Let me show you how!<\/p>\n<p>I explain how you can do this and please go to the bottom of the page to see the animated gif tutorial:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/oDDKIgxEKKY?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"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<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-View-Multiple-Worksheets-in-Excel.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>View &gt; Window &gt; New Window<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to View Multiple Worksheets in Excel\" class=\"alignnone size-full wp-image-8462\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-01.jpg\" alt=\"How to View Multiple Worksheets in Excel\" width=\"913\" height=\"123\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-01.jpg 913w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-01-300x40.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-01-768x103.jpg 768w\" sizes=\"(max-width: 913px) 100vw, 913px\" \/><\/a><\/p>\n<p>You will notice that there is a new window that is opened. You can notice that there is a number at the end of the filename indicated the <strong>window number<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to View Multiple Worksheets in Excel\" class=\"alignnone size-full wp-image-8463\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-02.jpg\" alt=\"How to View Multiple Worksheets in Excel\" width=\"391\" height=\"71\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-02.jpg 391w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-02-300x54.jpg 300w\" sizes=\"(max-width: 391px) 100vw, 391px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0Now let&#8217;s arrange the windows to view all of them side by side!<\/p>\n<p>Go to\u00a0<em><strong>View &gt; Window &gt; Arrange All<\/strong><\/em><\/p>\n<p>Select\u00a0<strong>Vertical\u00a0<\/strong>and Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to View Multiple Worksheets in Excel\" class=\"alignnone size-full wp-image-8464\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-03.jpg\" alt=\"How to View Multiple Worksheets in Excel\" width=\"373\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-03.jpg 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-03-300x278.jpg 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>Now you can view multiple <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/auto-populate-from-another-worksheet\/\" target=\"_blank\" rel=\"noopener\">worksheets from the same Excel<\/a> file!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to View Multiple Worksheets in Excel\" class=\"alignnone size-full wp-image-8465\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-04.jpg\" alt=\"How to View Multiple Worksheets in Excel\" width=\"1366\" height=\"728\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-04.jpg 1366w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-04-300x160.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-04-1024x546.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/04\/How-to-View-Multiple-Worksheets-in-Excel-04-768x409.jpg 768w\" sizes=\"(max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><b>How to View Multiple Worksheets in Excel<\/b><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;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\/blog\/wp-content\/uploads\/2014\/09\/728x901-e1413496235820.gif\" alt=\"728x90\" width=\"599\" height=\"74\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I usually have a workbook that has a lot of worksheets, and I have to view multiple sheets at the same time. Switching tabs back and forth just to compare the contents drives me nuts!! Did you know that you can\u00a0view multiple worksheets\u00a0in Excel? Let me show you how! I explain how you can do [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17626,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to View Multiple Worksheets in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,7,10,41],"tags":[364,179],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/8441"}],"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=8441"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/8441\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17626"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=8441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=8441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=8441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}