Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Viewing Two Worksheets At Once.
Dan asked if it is possible to see two Excel worksheets on the screen at the same time. Yes, you can do this, using the same general technique that you use to view multiple worksheets from different workbooks. Follow these steps:
Figure 1. The Arrange Windows dialog box.
In each of the windows you can display different worksheets, even though they are part of the same workbook. When you are done, simply close one of the windows.
It is interesting to note that if you have a need to do so, you can view more than two worksheets from the same workbook. All you need to do is perform step 2 as many times as necessary to open the desired number of windows.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6223) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Viewing Two Worksheets At Once.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Microsoft added a new feature to Excel that causes a "lock icon" to appear at the left of a worksheet tab if the ...
Discover MoreNeed to know the name of the current worksheet? You can use the CELL function as the basis for finding this information ...
Discover MoreNeed to make a copy of one of your worksheets? Excel provides a few different ways you can accomplish the task.
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-10-21 11:41:49
ANDERSON BARBOSA
The problem with this is that the ribbon gets duplicated for every new window. Is there a way to use the Split button and then be able to select which two worksheets to see at the same time?
2019-04-14 06:49:28
Willy Vanhaelen
@sandeep kothari.
I use this macro for manny years:
Sub Arrange()
If Not ActiveWindow Is Nothing Then Windows.Arrange xlArrangeStyleTiled
End Sub
This works with 2 windows of the same workbook as well as with the windows of 2 open workbooks in the same instance of Excel.
Of course you can choose the ArrangeStyle of your liking (see Help).
You can assign this macro to a QAT button or a shortcut key or both.
2019-04-13 05:32:56
sandeep kothari
What is the macro solution to this?
I wanted to view a sub & the related worksheet in twin windows. Pl provide a VBA solution; ALTERNATIVE SOLUTION through view tab is cumbersome.
2016-06-21 13:26:31
Leon Vickerman
that question about viewing three windows at one time using Excel 2011 was using a Mac. Sorry I didn't tell You that. I could find no Tiled on Mac. Thanks for the Info.
Leon Vickerman
Is your letter for windows only
2016-06-21 13:16:47
Leon Vickerman
Can someone tell me if you can have rearrange three windows so you can see them at the same time on Excel 2011. On 2010 I could make them all with my mouse and view them all at once. Any help would be most helpful.
Thank You
2016-04-21 12:04:04
Jerry
Kelvin, see my comment from 08 Aug 2015 below.
2016-04-20 20:44:27
Hi,
Thanks for the tip. I was wondering if you could save this view so that excel show the two sheets each time you open
2015-08-19 20:23:22
Crazy Brit
One thing that's great about this is you can update each viewed sheets and all changes are saved. The extra instances of the same workbook are not read only.
2015-08-11 10:38:45
Jerry
The procedure Barb outlined is new in Excel 2013. 2007 and 2010 require the extra steps listed in Allen's tip.
2015-08-10 08:28:54
Barb Miller
You don't even have to worry about going to New Window or only having one workbook open. If you go to View and Arrange All, you can choose any workbook to tile or open in any option in that window. This eliminates unnecessary steps.
2015-08-08 11:10:41
Robert
In real life you might have multiple workbooks open and only one workbook is having a problem you need to investigate.
To view two or more worksheets (up to 50) of the same workbook, just select at the bottom of figure 1 the "Windows of active workbook" then press OK, and only the workbook you are working on will be displayed with the many windows you
Splitted.
When you close them, don't close those that ends with :1 otherwise you will loose any frozen screens that were set on your worksheets.
2015-08-08 10:48:41
Jerry
If you always want to view the multiple worksheets when you open the workbook, save the workbook after you arrange the worksheets and before closing any of the windows. Excel remembers the view that was displayed when you saved the workbook, and will open the worksheets in the same orientation when you open the workbook.
If you work with multiple workbooks/worksheets a lot, it's handy to add the "Close All" button to the Quick Access Toolbar (find it under "All Commands" in the customize QAT options window). With just one click you can close all the open workbooks/worksheets without having to close each one individually. Excel will prompt you to save any unsaved changes.
2015-08-08 06:25:02
I was looking for this issue since long. I asked some people but the problem was solved. I am thankful to the writer of this tip.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments