Moving from cell to cell

From Apache OpenOffice Wiki
Jump to: navigation, search

In the spreadsheet, one cell, or a group of cells, normally has a darker black border. This black border indicates where the focus is (see Figure 5).

Figure 5. One selected cell
Group of selected cells

Using the Tab and Enter keys

  • Pressing Enter or Shift+Enter moves the focus down or up, respectively.
  • Pressing Tab or Shift+Tab moves the focus right or left, respectively.

Using the cursor keys

Pressing the cursor keys on the keyboard moves the focus in the direction of the arrows.

Using Home, End, Page Up and Page Down

  • Home moves the focus to the start of a row.
  • End moves the focus to the column furthest to the right that contains data.
  • CTRL-up_arrow moves the focus to top of a column.
  • CTRL-down_arrow moves the focus to bottom of a column.
  • Page Down moves the display down one complete screen and Page Up moves the display up one complete screen.
  • Combinations of Control and Alt with Home, End, Page Down, Page Up, and the cursor keys move the focus of the current cell in other ways.
  • Pressing Shift while moving the focus will select the entire rectangle of cells delineated by the initial and final focus.
Tip.png Holding down Alt+Cursor key resizes a cell.

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools