Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. 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)

12

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, and 2013. 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. ...

MORE FROM ALLEN

Changing Headers and Footers

Editing what is in your page header or footer is fairly easy, and you can use the same editing techniques you already ...

Discover More

Protecting Worksheets from Deletion

If you share a workbook with others in your office, you will probably want to make sure that some of the worksheets don't ...

Discover More

Changing Lock Screen Apps

The Lock Screen can show you much more than just a pretty picture. Here's how to display just the information you want on ...

Discover More

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!

More ExcelTips (ribbon)

Condensing Multiple Worksheets Into One

Want a quick way to combine your worksheets? This tip features a simple macro to do the task for you.

Discover More

Referencing Worksheet Tabs

Ever want to use the name of a worksheet tab within a cell? Here's how you can access that information using the CELL ...

Discover More

Finding the Size of Individual Worksheets

Your workbooks can contain many, many worksheets. Which of those worksheets are the largest, however? Here's some ideas ...

Discover More
Subscribe

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

View most recent newsletter.

Comments

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 seven more than 6?

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

Kelvin

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

Arif

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
Subscribe

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.