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.

Viewing Two Worksheets At Once

by Allen Wyatt
(last updated February 12, 2019)


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:

  1. Make sure you have only a single workbook open.
  2. Display the View tab of the ribbon.
  3. Click the New Window tool in the Window group. Excel opens a second instance of the same workbook.
  4. With the View tab of the ribbon still visible, click the Arrange All tool in the Window group. (See Figure 1.)
  5. Figure 1. The Arrange Windows dialog box.

  6. Choose the method Excel should use to arrange your windows.
  7. Click on OK. Excel arranges the windows as you directed.

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.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...


Deleting Unwanted Styles

Custom styles can be a great help in formatting a worksheet. You may, at some point, want to get rid of all the custom ...

Discover More

Template Changing On Its Own

When you attach a template to a document, you expect that template to stay attached. When you share the document with ...

Discover More

Determining the Current Page Number

While your macro is processing the text in your document, you may need a way to determine the current page number where ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More ExcelTips (ribbon)

Creating Worksheets from a List of Names

Need to create a large number of worksheets using specific names? If so, you'll love the ideas presented in this tip.

Discover More

Using Very Long Worksheet Tab Names

Excel places a limit on how many characters you can use in a worksheet name. This tip discusses that limit and provides ...

Discover More

Dynamic Worksheet Tab Names

Need a worksheet's name to change based on the contents of a cell? You'll need to rely on a macro to do the changing, but ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 3 + 6?

2019-10-21 11:41:49


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


Kelvin, see my comment from 08 Aug 2015 below.

2016-04-20 20:44:27


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


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


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
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


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.

This Site

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.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.