Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
Try or buy
Get Office 2007
Icon: Get help: (c) Microsoft
Help & support
Updates: (c) Microsoft
Office updates
 
 
 
Help by Product
How-to Resources
Support and Feedback
Technical Resources
Additional Resources
Get Office 2007
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Printer-Friendly VersionPrinter-Friendly Version
Move or scroll through a worksheet
 

There are different ways to scroll through a worksheet. You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.).

ShowUse the arrow keys to move through a worksheet

To move between cells on a worksheet, click any cell or use the arrow keys. When you move to a cell, it becomes the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.).
To scroll Do this
One row up or down Press SCROLL LOCK, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.
One column left or right Press SCROLL LOCK, and then use the LEFT ARROW key or RIGHT ARROW key to scroll one column left or right.
One window up or down Press PAGE UP or PAGE DOWN.
One window left or right Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key.
A large distance Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.

Note  When SCROLL LOCK is on, SCRL is displayed on the status bar. Pressing the arrow keys while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off.

ShowUse the scroll bars to move through a worksheet

To scroll Do this
One row up or down Click the scroll arrows Button image or Button image on the vertical scroll bar to move the sheet one row up or down.
One column left or right Click the scroll arrows Button image or Button image on the horizontal scroll bar to move the sheet one column to the left or right.
One window up or down Click above or below the scroll box Button image on the vertical scroll bar.
One window left or right Click to the left or right of the scroll box Button image on the horizontal scroll bar.
A large distance Hold down SHIFT while dragging the scroll box Button image.

Notes

  • The size of a scroll box indicates the proportional amount of the used area of the sheet that is visible in the window. The position of a scroll box indicates the relative location of the visible area within the worksheet.
  • You can quickly split the window so that you can scroll in two or four panes simultaneously. Point to the split box Split box on either the vertical or the horizontal scroll bar. When the pointer becomes a double-headed arrow Double-headed arrow, drag the split bar onto the worksheet where you want to split the window. Double-click the split bar to remove it.

ShowScroll and zoom by using the mouse

Some mouse devices and other pointing devices, such as the Microsoft IntelliMouse pointing device, have built-in scrolling and zooming capabilities that you can use to move around and zoom in or out on your worksheet or chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.). For more information, see the instructions for your pointing device.

To Do this
Scroll up or down a few rows at a time Rotate the wheel forward or back.
Pan through a worksheet Hold down the wheel button, and drag the pointer away from the origin mark origin mark in any direction that you want to scroll. To speed up scrolling, move the pointer away from the origin mark. To slow down scrolling, move the pointer closer to the origin mark.
Pan through a worksheet automatically Click the wheel button, and then move the mouse in the direction that you want to scroll. To speed up scrolling, move the pointer away from the origin mark. To slow down scrolling, move the pointer closer to the origin mark. To stop automatic scrolling, click any mouse button.
Zoom in or out Hold down CTRL while you rotate the IntelliMouse wheel forward or back.
Show detail in outlines (outline: Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.) Point to a cell that summarizes data in the outline, and then hold down SHIFT while you rotate the wheel forward.
Hide detail in outlines Point to any cell that contains detail data, and then hold down SHIFT while you rotate the wheel back.

Tip   If you use the IntelliMouse pointing device to zoom more often than you use it to scroll on a sheet, you can set the wheel button to zoom instead of scroll. On the Tools menu, click Options, click the General tab, and then select the Zoom on roll with IntelliMouse check box.

See Also
advertisement
Printer-Friendly VersionPrinter-Friendly Version