Move and scroll through a datasheet
To move between cells on a datasheet, click any cell or use the arrow keys. When you move to a cell, it becomes the active cell. To see a different area of the sheet, use the scroll bars.
| To scroll | Do this |
|---|---|
| One row up or down | Click the arrows on the vertical scroll bar. |
| One column left or right | Click the arrows on the horizontal scroll bar. |
| One window up or down | Click above or below the scroll box on the vertical scroll bar. |
| One window left or right | Click to the left or right of the scroll box on the horizontal scroll bar. |
| A large distance | Drag the scroll box to the approximate relative position. On a very large datasheet, hold down SHIFT while dragging. |
Tip The size of a scroll box indicates the proportional amount of the used area of the sheet that is visible within the window. The position of a scroll box indicates the relative location of the visible area within the datasheet.