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 August 8, 2015)

10

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

Converting From Numbers to Text

If you have a range of numeric values in your worksheet, you may want to change them from numbers to text values. Here's how ...

Discover More

Making Common Information Accessible

Got a bunch of info that is common to a lot of your documents? Here's a way to get that information standardized among all ...

Discover More

Finding All Instances of a Value

Searching for information in an Excel worksheet generally goes very smoothly. There can be times, however, when the ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Naming Tabs for Weeks

Need to set up a workbook that includes a worksheet for each week of the year? Here's a couple of quick macros that can do ...

Discover More

Referencing a Worksheet Name

Excel provides ways to reference the column or row number of a cell, but it doesn't provide a built-in way to reference a ...

Discover More

Freezing Top Rows and Bottom Rows

Freezing the top rows in a worksheet so that they are always visible is easy to do. Freezing the bottom rows is not so easy. ...

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. 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 7 + 5?

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.