Move or scroll quickly within an Excel worksheet area

There are different ways to scroll through an Excel worksheet. You can use the arrow keys, scroll bars, or mouse to move between cells and move quickly to different areas of the worksheet.

In Microsoft Office Excel 2007, you can easily scroll to the end of a range with increased scrolling speed and use ToolTips to understand where you are in the worksheet. You can also use the mouse to scroll through a dialog box that contains a drop-down list with a scroll bar.

Use the arrow keys to move through the worksheet

To move between cells in a worksheet, click any cell or use the arrow keys. When you move to a cell, the cell becomes the active cell (the active cell: The active cell is the selected cell, where you can enter data.) You can have only one active cell at a time. The border around the active cell is bold. )。

to scroll	please perform
	To scroll to the beginning and end of each range and select the range before stopping at the end of the worksheet, press the ctrl+shift+ arrow key.
	press SCR Oll Lock, and then use the UP or DOWN ARROW keys to scroll one line up or down.
	press Scroll L Ock, and then use the left or RIGHT arrow keys to scroll one column to the left or right.
	> Press Page Up or Page down.
	press Scro ll Lock, and then hold down CTRL while pressing the left or right arrow keys.
large distance	press Scroll Lock , and then hold down CTRL and an arrow key toMove quickly within a larger area of the worksheet.

Note "Scroll lock" appears on the status bar when Scroll lock is open. Press the arrow keys when Scroll Lock is open to move one row up or down, or to the left or right. To use the arrow keys to move between cells, you must turn off Scroll Lock.

Use scroll bars to move through a worksheet

to scroll	please perform
Move up or down one Row
	> Click Roll on the horizontal scroll bar Move arrow
	Moving the mouse in the opposite direction slows the scrolling speed.
	Click Horizontal Scrolling The scroll block on the bar
large distance	hold down SHIFT and drag Scroll block

　　Comments

• When scrolling through a worksheet using a scroll box, Excel displays tooltips to indicate line numbers and column labels (numbers if you specify to use the R1C1 reference style for the workbook) so that you know where you are in the worksheet.

• The size of the scroll block indicates that the area visible within the window is proportional to the entire data table. The position of the scroll box indicates the relative position of the visible area on the worksheet.

• You can quickly split a window to scroll in 2 or 4 panes at the same time. Point to a splitter box on a horizontal or vertical scroll bar. When the pointer changes to a double arrow, drag the splitter bar to the position on the worksheet where you want to split the window. Double-click the splitter bar to delete it.

Scrolling and zooming by using the mouse

Some mouse devices and other pointing devices, such as the Microsoft smart mouse pointer device, have built-in scrolling and zooming capabilities that you can use to work on a worksheet or chart sheet chart sheet: A worksheet in a workbook that contains only a chart. Chart sheets are useful when you want to view a chart or PivotChart report individually (independent of worksheet data or a PivotTable report). ) Move or scale. You can also use the mouse to scroll through a dialog box that contains a drop-down list with a scroll bar. For more information, see the instructions for your pointing device.

to	please perform the
	Moving the mouse in the opposite direction slows the scrolling speed.
	> Click the mouse wheel button , and then move the mouse to the direction you want to scroll. To speed up scrolling, move the pointer away from the original mark, and to slow down the scrolling, move the pointer toward the original mark. To stop automatic scrolling, click any mouse button.
	> hold down CTRL Rotate the Smart mouse wheel forward or backward at the same time. ScalingThe percentage of the worksheet is displayed on the status bar.
	point to outline Show the cell that contains the summary data, and then hold down SHIFT and rotate the mouse wheel forward.
	point contains Ming Any cell that has a thin data, and then hold down SHIFT and rotate the mouse wheel backwards.