{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-28T14:44:59+00:00","modifiedTime":"2016-03-30T18:24:29+00:00","timestamp":"2022-09-14T18:14:20+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"General Microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Viewing a File Through More Than One Window","strippedTitle":"viewing a file through more than one window","slug":"viewing-a-file-through-more-than-one-window","canonicalUrl":"","seo":{"metaDescription":"When you have a large file, especially a large spreadsheet in Excel, it's extremely helpful to view two parts of the file at once. This video discusses how to o","noIndex":0,"noFollow":0},"content":"<div class=\"x2 x2-top\">\r\n\r\n<div class=\"video-player-organism\"></div>\r\n\r\n</div>\r\nWhen you have a large file, especially a large spreadsheet in Excel, it's extremely helpful to view two parts of the file at once. This video discusses how to open two windows for one file, arrange them side by side, and scroll them side by side.","description":"<div class=\"x2 x2-top\">\r\n\r\n<div class=\"video-player-organism\"></div>\r\n\r\n</div>\r\nWhen you have a large file, especially a large spreadsheet in Excel, it's extremely helpful to view two parts of the file at once. This video discusses how to open two windows for one file, arrange them side by side, and scroll them side by side.","blurb":"","authors":[],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":210391,"title":"Choosing a Theme for a Word 2016 Document","slug":"choosing-a-theme-for-a-word-2016-document","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210391"}},{"articleId":210390,"title":"Creating a Template in Word 2016","slug":"creating-a-template-in-word-2016","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210390"}},{"articleId":210389,"title":"Introducing Word 2016 Styles","slug":"introducing-word-2016-styles","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210389"}},{"articleId":210388,"title":"Moving Around Quickly in Word 2016 Documents","slug":"moving-around-quickly-in-word-2016-documents","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210388"}},{"articleId":210387,"title":"Getting Acquainted with PowerPoint 2016","slug":"getting-acquainted-with-powerpoint-2016","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/210387"}}],"fromCategory":[{"articleId":294664,"title":"Windows 365 For Dummies Cheat Sheet","slug":"windows-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/294664"}},{"articleId":291623,"title":"Office 2021 For Macs For Dummies Cheat Sheet","slug":"office-2021-for-macs-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/291623"}},{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281797,"slug":"office-2016-all-in-one-for-dummies","isbn":"9781119083122","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119083125/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119083125/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119083125-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119083125/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119083125/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2016-all-in-one-for-dummies-cover-9781119083122-203x255.jpg","width":203,"height":255},"title":"Office 2016 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran <i>For Dummies</i> author. In addition to previous books on Microsoft Office, Peter has written guides to Windows, the Internet, and Quicken. </p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Peter Weverka</b> is a veteran <i>For Dummies</i> author who has written about a wide variety of applications. Along with two bestselling editions of <i>Office All-in-One For Dummies</i>, Peter has written <i>PowerPoint All-in-One For Dummies</i> and <i>Microsoft Money For Dummies</i>.</p>","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","general-microsoft"]},{"key":"isbn","values":["9781119083122"]}]\" id=\"du-slot-632219fca797d\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","general-microsoft"]},{"key":"isbn","values":["9781119083122"]}]\" id=\"du-slot-632219fca7f3e\"></div></div>"},"articleType":{"articleType":"Videos","articleList":null,"content":null,"videoInfo":{"videoId":"4732551678001","name":"Viewing a File Through More Than One Window","accountId":"622696558001","playerId":"default","thumbnailUrl":"https://cf-images.us-east-1.prod.boltdns.net/v1/static/622696558001/7eff19e9-935c-4d2a-9e7b-1ddac51481ef/603c00fd-7403-4f9e-9958-3fb9430e7539/160x90/match/image.jpg","description":"When you have a large file, especially a large spreadsheet in Excel, it's extremely helpful to view two parts of the file at once. This video discusses how to open two windows for one file, arrange them side by side, and scroll them side by side.","uploadDate":"2022-07-01T00:52:28.126Z"}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":210392},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2023-01-02T10:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for http://www.dummies.com -->\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":287569,"title":"For the Hopeless Romantic","hasSubCategories":false,"url":"/collection/for-the-hopeless-romantic-287569"},{"collectionId":296450,"title":"For the Spring Term Learner","hasSubCategories":false,"url":"/collection/for-the-spring-term-student-296450"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":{"term":"210392","count":5,"total":349,"topCategory":0,"items":[{"objectType":"article","id":210392,"data":{"title":"Viewing a File Through More Than One Window","slug":"viewing-a-file-through-more-than-one-window","update_time":"2016-03-30T18:24:29+00:00","object_type":"article","image":null,"breadcrumbs":[{"name":"Technology","slug":"technology","categoryId":33512},{"name":"Software","slug":"software","categoryId":33618},{"name":"Microsoft Products","slug":"microsoft-products","categoryId":33642},{"name":"General Microsoft","slug":"general-microsoft","categoryId":33652}],"description":"\r\n\r\n\r\n\r\n\r\nWhen you have a large file, especially a large spreadsheet in Excel, it's extremely helpful to view two parts of the file at once. This video discusses how to open two windows for one file, arrange them side by side, and scroll them side by side.","item_vector":null},"titleHighlight":null,"descriptionHighlights":null,"headers":null,"categoryList":["technology","software","microsoft-products","general-microsoft"],"title":"Viewing a File Through More Than One Window","slug":"viewing-a-file-through-more-than-one-window","articleId":210392},{"objectType":"article","id":192089,"data":{"title":"Comparing Two Excel 2010 Worksheets Side by Side","slug":"comparing-two-excel-2010-worksheets-side-by-side","update_time":"2016-03-26T21:17:57+00:00","object_type":"article","image":null,"breadcrumbs":[{"name":"Technology","slug":"technology","categoryId":33512},{"name":"Software","slug":"software","categoryId":33618},{"name":"Microsoft Products","slug":"microsoft-products","categoryId":33642},{"name":"Excel","slug":"excel","categoryId":33644}],"description":"You can use the View Side by Side command button on the View tab in Excel 2010 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button after opening two workbook windows, Excel automatically tiles the windows.\nTo compare two worksheets side by side, follow these steps:\n\n Open the two workbooks you want to compare.\nDisplay the worksheet in each workbook that you want to compare side by side.\n \n Click the View Side by Side button in the Window group of the View tab.\nIf you have more than two windows open when you click the View Side by Side command button, Excel opens the Compare Side by Side dialog box, where you click the name of the window that you want to compare with the one that's currently active and click OK.\n \n Scroll down or across a worksheet.\nBoth worksheets scroll together because the Synchronous Scrolling setting is enabled by default when you click the View Side by Side button.\nComparing two worksheet windows side by side.\n \n (Optional) Click the Synchronous Scrolling button in the Window group if you want to turn off simultaneous scrolling.\nTurning off simultaneous scrolling allows you to scroll through one worksheet without the other one scrolling, too.\n \n (Optional) Click the Reset Window Position button if you want to reset the window positions of the two workbooks after resizing one or both windows.\nYou might have resized a window to get a better look at some data.\n \n When you're done comparing the worksheets, click the View Side by Side button in the Window group again\nExcel returns to Normal view. \n \n","item_vector":null},"titleHighlight":null,"descriptionHighlights":null,"headers":null,"categoryList":["technology","software","microsoft-products","excel"],"title":"Comparing Two Excel 2010 Worksheets Side by Side","slug":"comparing-two-excel-2010-worksheets-side-by-side","articleId":192089},{"objectType":"article","id":207312,"data":{"title":"Comparing Two Excel 2007 Worksheets Side by Side","slug":"comparing-two-excel-2007-worksheets-side-by-side","update_time":"2016-03-27T15:44:11+00:00","object_type":"article","image":null,"breadcrumbs":[{"name":"Technology","slug":"technology","categoryId":33512},{"name":"Software","slug":"software","categoryId":33618},{"name":"Microsoft Products","slug":"microsoft-products","categoryId":33642},{"name":"Excel","slug":"excel","categoryId":33644}],"description":"You can use the View Side by Side command button on the View tab in Excel 2007 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button after opening two workbook windows, Excel automatically tiles the windows.\nTo compare two worksheets side by side, follow these steps:","item_vector":null},"titleHighlight":null,"descriptionHighlights":null,"headers":null,"categoryList":["technology","software","microsoft-products","excel"],"title":"Comparing Two Excel 2007 Worksheets Side by Side","slug":"comparing-two-excel-2007-worksheets-side-by-side","articleId":207312},{"objectType":"article","id":202985,"data":{"title":"Arranging Windows in Excel 2007 Workbooks","slug":"arranging-windows-in-excel-2007-workbooks","update_time":"2016-03-26T23:11:09+00:00","object_type":"article","image":null,"breadcrumbs":[{"name":"Technology","slug":"technology","categoryId":33512},{"name":"Software","slug":"software","categoryId":33618},{"name":"Microsoft Products","slug":"microsoft-products","categoryId":33642},{"name":"Excel","slug":"excel","categoryId":33644}],"description":"You can open multiple workbook windows in Excel 2007 and arrange them into windows of varying displays so that you can view different parts of a worksheet from each workbook on the screen at one time.\nAfter you arrange windows, activate the one you want to use (if it’s not already selected) by clicking it. In the case of the cascade arrangement (described below), you need to click the worksheet window’s title bar, or you can click its button on the taskbar.\nFollow these steps to arrange workbook windows in Excel 2007:\n\n Open the workbooks that you want to arrange.\nYou’ll want to open at least two workbooks and select the worksheet in each workbook that you want to display.\n \n Click the Arrange All button in the Window group on the View tab.\nThe Arrange Windows dialog box appears.\nSelect the desired Arrange setting in the Arrange Windows dialog box.\n \n Make one of the following selections:\n \n Tiled: Select this option button to have Excel arrange and size the windows so that they all fit side by side on the screen in the order in which you opened them.\nArrange four worksheet windows with the Tiled option.\n \n Horizontal: Select this option button to have Excel size the windows equally and place them one above the other.\nFour worksheet windows arranged with the Horizontal option.\n \n Vertical: Select this option button to have Excel size the windows equally and place them next to each other.\nArrange four worksheet windows with the Vertical option.\n \n Cascade: Select this option button to have Excel arrange and size the windows so that they overlap one another with only their title bars showing.\nFour worksheet windows arranged with the Cascade option.\n \n \n \n Click OK.\nThe workbooks are arranged on-screen based on your selection in the previous step.\n \n\nIf you want to have Excel show only the windows that you have open in the current workbook, select the Windows of Active Workbook check box in the Arrange Windows dialog box.\nIf you close one of the windows you’ve arranged, Excel doesn’t automatically resize the other open windows to fill in the gap. To fix this, click the Arrange All command again on the View tab, select the desired arrangement, and click OK.","item_vector":null},"titleHighlight":null,"descriptionHighlights":null,"headers":null,"categoryList":["technology","software","microsoft-products","excel"],"title":"Arranging Windows in Excel 2007 Workbooks","slug":"arranging-windows-in-excel-2007-workbooks","articleId":202985},{"objectType":"article","id":170958,"data":{"title":"How to Compare Multiple Worksheets in Excel 2013","slug":"how-to-compare-multiple-worksheets-in-excel-2013","update_time":"2016-03-26T15:50:48+00:00","object_type":"article","image":null,"breadcrumbs":[{"name":"Technology","slug":"technology","categoryId":33512},{"name":"Software","slug":"software","categoryId":33618},{"name":"Microsoft Products","slug":"microsoft-products","categoryId":33642},{"name":"Excel","slug":"excel","categoryId":33644}],"description":"In Excel 2013, you can split a single workbook into worksheet windows and then arrange the windows so that you can view different parts of each worksheet on the screen.\nTo open the worksheets that you want to compare in different windows, you simply insert new workbook windows and then select the worksheet that you want to display in the new window. You can accomplish this with the following steps:\n\n Click the New Window command button on the View tab or press Alt+WN to create a second worksheet window.\nThen click the tab of the worksheet that you want to display in this second window (indicated by the :2 that Excel adds to the end of the filename in the title bar).\n \n Click the New Window command button or press Alt+WN again to create a third worksheet window.\nThen click the tab of the worksheet that you want to display in this third window (indicated by the :3 that Excel adds to the end of the filename in the title bar).\n \n Repeat step 2 for each worksheet you want to compare.\n \n Click the Arrange All command button on the View tab or press Alt+WA and select one of the Arrange options in the Arrange Windows dialog box.\nThen click OK or press Enter.\n \n\nWhen you open the Arrange Windows dialog box, you’re presented with the following options:\n\n Tiled: Select this button to have Excel arrange and size the windows so that they all fit side by side on the screen.\n\n \n Horizontal: Select this button to have Excel size the windows equally and place them one above the other.\n\n \n Vertical: Select this button to have Excel size the windows equally and place them next to each other.\n\n \n Cascade: Select this button to have Excel arrange and size the windows so that they overlap one another with only their title bars showing.\n\n \n Windows of Active Workbook: Select this check box to have Excel show only the windows that you have open in the current workbook. Otherwise, Excel also displays all the windows in any other workbooks you have open. Yes, it is possible to open more than one workbook provided that the device you’re running Excel on has sufficient screen space and memory.\n \n\nAfter you place windows in one arrangement or another, activate the one you want to use (if it isn’t selected already) by clicking it in the Excel program window. Alternatively, you position the mouse or touch pointer on the Excel 2013 program icon on the Windows 7 or 8 taskbar to display pop-up thumbnails for each of the worksheet windows you have open.\nTo display the contents of one of the Excel worksheet windows without the others visible, highlight its pop-up thumbnail on the Windows taskbar. To then activate a particular worksheet window from the taskbar, you simply click its thumbnail.\nWhen you click a worksheet window that has been tiled or placed in the horizontal or vertical arrangement, Excel indicates that the window is selected simply by displaying the cell pointer around the active cell and highlighting that cell’s column and row heading in the worksheet.\nWhen you click the title bar of a worksheet window you place in the cascade arrangement, the program displays the window on the top of the stack, as well as displaying the cell pointer in the sheet’s active cell.\nYou can temporarily zoom the window to full size by clicking the Maximize button on the window’s title bar. When you finish your work in the full-size worksheet window, return it to its previous arrangement by clicking the window’s Restore button.\nTo select the next tiled, horizontal, or vertical window on the screen or display the next window in a cascade arrangement with the keyboard, press Ctrl+F6. To select the previous tiled, horizontal, or vertical window or to display the previous window in a cascade arrangement, press Ctrl+Shift+F6. These keystrokes work to select the next and previous worksheet window even when the windows are maximized in the Excel program window.\nIf you close one of the windows by clicking Close (the X in the upper-right corner) or by pressing Ctrl+W, Excel doesn’t automatically resize the other open windows to fill in the gap. Likewise, if you create another window by clicking the New Window command button on the View tab, Excel doesn’t automatically arrange it in with the others.\nTo fill in the gap created by closing a window or to integrate a newly opened window into the current arrangement, click the Arrange command button to open the Arrange Windows dialog box and click OK or press Enter. (The button you selected last time is still selected; if you want to choose a new arrangement, select a new button before you click OK.)\nDon’t try to close a particular worksheet window by choosing File→Close or by pressing Alt+FC because you’ll only succeed in closing the entire workbook file, getting rid of all the worksheet windows you created!\nWhen you save your workbook, Excel saves the current window arrangement as part of the file. If you don’t want to save the current window arrangement, close all but one of the windows. Then click that last window’s Maximize button and select the tab of the worksheet that you want to display the next time you open the workbook before saving the file.","item_vector":null},"titleHighlight":null,"descriptionHighlights":null,"headers":null,"categoryList":["technology","software","microsoft-products","excel"],"title":"How to Compare Multiple Worksheets in Excel 2013","slug":"how-to-compare-multiple-worksheets-in-excel-2013","articleId":170958}]},"relatedArticlesStatus":"success"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/general-microsoft/viewing-a-file-through-more-than-one-window-210392/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"general-microsoft","article":"viewing-a-file-through-more-than-one-window-210392"},"fullPath":"/article/technology/software/microsoft-products/general-microsoft/viewing-a-file-through-more-than-one-window-210392/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"sfmcState":{"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}
When you have a large file, especially a large spreadsheet in Excel, it's extremely helpful to view two parts of the file at once. This video discusses how to open two windows for one file, arrange them side by side, and scroll them side by side.
Peter Weverka is a veteran For Dummies author. In addition to previous books on Microsoft Office, Peter has written guides to Windows, the Internet, and Quicken.