Microsoft Office Tutorials and References
In Depth Information
Open a New Window for a Workbook
Open a New Window
for a Workbook
You can make a large spreadsheet easier to
manage by creating a second window for the
When you are building a spreadsheet, you
often have to refer to existing sheet data. For
example, when you construct a formula, you
may need to refer to specific cells. Similarly,
once your spreadsheet is working, you often
need to monitor a cell value. For example, if
you change the data in one part of the sheet,
you might want to see how that change affects
the result of a formula elsewhere in the sheet.
This is easy with a small spreadsheet where you
can see everything on the screen. However,
larger spreadsheets do not fit into a single
screen, so the data you need to reference or
monitor might not be visible, requiring that
you scroll through the sheet to see it.
A better solution is to create a second window
for the workbook and then arrange those
windows side-by-side (vertically or
horizontally). This enables you to display what
you are currently working on in one window,
and what you need to reference or monitor in
the second window.
Create a New
1 Open the workbook you
want to work with.
2 Click the View tab.
3 Click New Window.
Excel creates a second
window for the workbook
and appends ‘:2’ to the
name of the new
Note: Excel also appends ‘:1’ to the
name of the original window.
4 Click Arrange All.