Moving from Cell to Cell

From Apache OpenOffice Wiki
< Documentation‎ | AOO4 User Guides/Getting Started‎ | Getting Started with Calc
Revision as of 14:24, 19 September 2023 by DiGro (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Moving from Cell to Cell

In the spreadsheet, one cell normally has a darker black border. This black border indicates where the focus is (see Figure 71). If a group of cells is selected, they have a highlight color, with the focus cell having a dark border.

Using the mouse

To move the focus using the mouse, simply move the mouse pointer to the cell where you want the focus to be and click the left mouse button. This changes the focus to the new cell. This method is most useful when the two cells are a large distance apart.

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 to the right or to the left, respectively.
AOO41GS05 015.png
Figure 71. (Left) One selected cell and (right) a group of selected cells

Using the arrow keys

Pressing the arrow 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.
  •  Page Down  moves the display down one complete screen and  Page Up  moves the display up one complete screen.
  • Combinations of  Ctrl  and  Alt  with  Home ,  End ,  Page Down ,  Page Up , and the cursor keys move the focus of the current cell in other ways. See the Help or Appendix A (Keyboard Shortcuts) in the Calc Guide for details.
Tip.png Use one of the four Alt+Arrow key combinations to resize a cell.

Customizing the Enter Key

You can customize the direction in which the  ↵ Enter  key moves the focus, by selecting Tools → Options → OpenOffice Calc → General.

The four choices for the direction of the  ↵ Enter  key are shown on the right-hand side of Figure 72. It can move the focus down, right, up, or left. Depending on the file being used or on the type of data being entered, setting a different direction can be useful.

The  ↵ Enter  key can also be used to switch into and out of editing mode. Use the first two options under Input settings in Figure 72 to change the  ↵ Enter  key settings.

AOO41GS05 016.png
Figure 72 : Customizing the effect of the Enter key
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools