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 More than Two Places in a Worksheet.

Viewing More than Two Places in a Worksheet

by Allen Wyatt
(last updated August 7, 2018)

5

Jesse asked if there is a way to view more than two areas of a worksheet at the same time, other than by hiding rows.

The easiest solution is to just open additional windows for the worksheet. Display the View tab of the ribbon and click New Window in the Window group. Excel opens additional windows that contain the exact same worksheet. You can then click Arrange All in the Window group of the ribbon to arrange the windows any way desired. (See Figure 1.)

Figure 1. The Arrange Windows dialog box.

When you open additional windows in this manner, the windows are independent of each other, meaning that you can scroll them independently. If you make a change in one window, the same change is made in all the windows. (This makes sense, since they all display the same data.)

Once the windows are situated the way you want them, you could save the arrangement as a view. (Display the View tab of the ribbon and, within the Workbook Views group, click Custom Views.) That way you could quickly recall the appearance of your windows any time you desire.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9729) 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 More than Two Places in a Worksheet.

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

Jumping Around Folders

If you need to move between two different folders quite regularly in the Open dialog box, you'll find the technique ...

Discover More

Positioning the Cursor in a New Document

Creating special templates is a great way to establish "standards" for your documents. With a little ingenuity you can ...

Discover More

Moving the House Number to Its Own Cell

Excel is great at manipulating data, but sometimes it is difficult to figure out the best way to do the manipulation. ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (ribbon)

Displaying a Count of Zeros on the Status Bar

Excel allows you to display the results of several common worksheet functions on the status bar. The available functions ...

Discover More

Working with Record Numbers

Want to keep track of various rows in a data table through the use of record numbers? Here are some options and ...

Discover More

Inadvertantly Getting Rid of Frozen Panes

Excel provides quite a bit of flexibility in displaying your data. You can have multiple windows visible for the same ...

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

2018-08-08 10:38:54

CSD

I opened a new window for an excel worksheet and want to close the new window now. How do I do that? Hovering over "new window" has the tip that it will open what I expect is another new window, so I'm hesitant to do that. Please advise.


2018-08-08 05:18:26

QB

Thanks, Willy. I'll have to read Zack Barresse's book again!


2018-08-07 07:27:34

Willy Vanhaelen

@QB
You have probably a table in you workbook. In that case Custom View is grayed out (in Excel 2007 anyhow). Converting the table(s) to a Range will allow you to make a Custom View. If you wan't/can't do this then you cannot use the Custom Views.


2018-08-07 02:56:20

QB

I use Excel in Microsoft Office Professional Plus 2016. I cannot create a Custom View as the Custom View icon is greyed out. Any ideas of what I'm doing wrong?


2016-03-17 11:00:45

Sheila Cabler

How can I working with one workbook, open multiple windows to work on numerous tabs BUT on 2 monitors and not limited to just 1 monitor


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.