1. Overview

AutoScroll ranges allow you to define regions in which the current (selected) cell moves differently than in the rest of the worksheet when you press Enter or use the Left/Right or Up/Down arrow keys.

2. Horizontal Scrolling

Within an AutoScroll range, horizontal movement can be configured as follows:

• Pressing the Left/Right arrow keys moves the current cell to the next or previous cell in the row — either the next empty cell or the next non‑empty cell — within the boundaries of the region.
  After reaching the left or right boundary, the selection moves to the end or start of the previous or next row.

• Pressing Enter can:

  • Move the current cell to the next or previous cell in the row (empty or non‑empty), within the region boundaries.

  • Jump to the opposite left or right edge of the region. If the current cell is already at the right edge, the selection jumps to the opposite edge in the next row. After reaching the last row, it returns to the first top‑left cell of the region.

    

3. Vertical Scrolling

Vertical scrolling works similarly:

• Pressing the Up/Down arrow keys moves the current cell to the next or previous cell in the column — either the next empty cell or the next non‑empty cell — within the region boundaries.
  After reaching the top or bottom boundary, the selection moves to the end or start of the previous or next column.

• Pressing Enter can:

  • Move the current cell to the next or previous cell in the column (empty or non‑empty), within the region boundaries.

  • Jump to the opposite top or bottom edge of the region. If the current cell is already at the bottom edge, the selection jumps to the top edge in the next column. After reaching the last column, it returns to the first top‑left cell of the region.

4. Additional Options

Press Alt+Enter to quickly switch the active scrolling mode.

You can define multiple AutoScroll ranges and switch between them. To create and activate a range, select a cell range and choose Edit → Activate Autoscroll Range, or click the AutoScroll label on the worksheet toolbar. To deactivate the range, use the corresponding command.

You can also configure AutoScroll behavior globally for the entire worksheet in Settings → Options.