Microsoft Excel XP/X

Navigating Through Your Large Workbook

Efficiently navigating through a workbook can be challenging when the workbook or worksheets are large. This document includes tips and shortcuts for navigating through a large worksheet and multiple open workbooks, including the following topics:

Finding Keyboard Shortcuts
Using the Go To Command
Moving Between Open Workbooks
Using Screen Options

Finding Keyboard Shortcuts

Learning keyboard shortcuts will save you time when working with your workbook. There are several keyboard shortcuts available to help you move around your worksheets and workbook more efficiently. The following table displays some common shortcuts and their keyboard combinations.

To...	Press...
	Windows	Macintosh
Move to the next sheet	[Ctrl]+[PgDn]	[Control]+[Page Down]
Move to the previous sheet	[Ctrl]+[PgUp]	[Control]+[Page Up]
Move to the next open workbook	[Ctrl]+[F6] OR [Ctrl]+[Tab]	[Control]+[F6] OR [Control]+[Tab]
Move to the previous open workbook	[Ctrl]+[Shift]+[F6] OR [Ctrl]+ [Shift]+ [Tab]	[Control]+[Shift]+[F6] OR [Control]+ [Shift]+ [Tab]

Accessing a List of Keyboard Shortcuts from the Help Menu

You can use the Microsoft Excel Help through the Help menu to obtain a complete list of keyboard shortcuts by searching for the keywords "keyboard shortcuts."

Using the Go To Command

To move to a specific cell of the worksheet, you can use the Go To command. The Go To command is also useful when moving between ranges, for a discussion of how to add a range, refer to Creating a Range Name from the Excel document Working with Range Names.

Using the Go To Command: Menu Option

From the Edit menu, select Go To...
OR
Windows: Press [F5] or [Ctrl]+[G]
Macintosh: Press [F5] or [Control]+[G]
The Go To dialog box appears.
From the Go to scroll box, select the range name
OR
In the Reference text box, type the cell location
Click OK

Using the Go To Command: Name Box Option

If you have created range names in your worksheet, you can move to a cell or range of cells with a particular range name.

From the Name Box pull-down list, select the appropriate range name
You will be moved to the range you specified.

Moving Between Open Workbooks

If you have more than one workbook open, you can move between files using the Window menu.
NOTE: Using the Recent Files option from the File menu is not recommended. Using this option may result in multiple versions of the same file being opened.

To move to a file in a different workbook:

From the Window menu, select the name of the workbook
You will be moved to the file you specified.

Using Screen Options

Working on large worksheets can be frustrating when you need to see different parts of the worksheet at once. Excel has two ways to work around this: Splitting the Screen and Freezing the Panes.

Freezing the Panes

The Freeze Panes option is often used when you have several columns or rows grouped together. In this situation, if you go beyond one screen of information, you generally lose the row or column headings so you may not know what the information that you are looking at refers to. With the Freeze Panes option, you can freeze either, or both, the rows or the columns. This means that, regardless of where you are in the worksheet, you can see the information in that row and/or column at all times.

Select the first cell that you want to freeze
This should be the cell immediately below the last row of the title and to the right of the last column of the title.
From the Window menu, select Freeze Panes

Unfreezing Panes

From the Window menu, select Unfreeze Panes

Splitting the Screen

The Split Screen option works well when you want to see separate sections of a worksheet at the same time. You can split the screen into two or four different sections at a time. Splitting the screen using the Menu option will split the screen into four sections. Splitting the screen using the Mouse option will allow you to split the screen into two or four sections. The following graphic is an example of what the screen looks like after being split into four using the Menu option:
Excel worksheet split in four sections

Splitting the Screen: Menu Option

Select the cell where you would like the worksheet split
From the Window menu, select Split
The screen will be split into four sections.

Splitting the Screen: Mouse Option

Point to the black line above the vertical scroll arrow or to the right of the horizontal scroll arrow
The pointer will turn into a double arrow.

Click and drag the Split Bar to the desired location
Release the mouse button
Your screen will be split in two sections.
OPTIONAL: To split the screen into four sections,
1. Point to the black line you did not use to create the first split
  The pointer will turn into a double arrow.
2. With the double arrow, click and drag the Split Bar to the desired location
3. Release the mouse button

Unsplitting the Screen: Menu Option

From the Window menu, select Remove Split
The screen will return to a normal view.

Unsplitting the Screen: Mouse Option

Drag each Split Bar back to its original position (above the vertical scroll bar or to the left of the horizontal scroll bar)
OR
Double click each Split Bar