Moving from cell to cell

Getting Started with OpenOffice.org 2.x

Chapter 7: Getting Started with Calc

< Previous Section

Next Section >

• Parts of the main Calc window
• File management
• Navigating within spreadsheets

• Going to a particular cell
• Moving from cell to cell
• Moving from sheet to sheet

• Selecting cells
• Selecting columns and rows
• Inserting columns and rows
• Deleting columns and rows
• Working with sheets

• Inserting new sheets
• Deleting sheets
• Renaming sheets

• Viewing Calc

• Freezing rows and columns
• Splitting the window

• Entering data into a sheet
• Printing

• Print options
• Selecting sheets to print
• Printing rows or columns on every page
• Defining a print range

< Previous Page

Next Page >

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).

File:One-cell.png Figure 5. One selected cell

File:GroupCells.png 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.

Holding down Alt+Cursor key resizes a cell.