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)


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


Locating the My Documents Folder

Need to do some macro processing of documents in the user's My Documents folder? First step is to figure out where the ...

Discover More

Using Large Toolbar Buttons

Having trouble seeing the icons used on the various Word toolbars? You can make the tools larger (and easier to see) by ...

Discover More

Establishing a FLOOR and CEILING

Excel includes a surprising number of functions you can use to round your data. Two such functions are FLOOR and CEILING, ...

Discover More

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!

More ExcelTips (ribbon)

Creating a Worksheet Copy by Default

Excel makes it relatively easy to copy worksheets to a different workbook. That doesn't mean it couldn't be made simpler ...

Discover More

Changing the Color of Worksheet Gridlines

Want the gridlines in your worksheet to be a different color? You aren't limited to stodgy black; Excel lets you make ...

Discover More

Lotus Grouped Worksheets

Not all spreadsheet programs are created equal; there are some things that can be done in others that can't be done in ...

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


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.