42 About Moving Around Calc

 <  Day Day Up  >  

Your mouse and arrow keys are the primary navigation keys for moving from cell to cell in sheets. Unlike Writer, which uses an insertion point, Calc uses its active cell, the highlighted cell , to indicate your current position in the sheet.

Before You Begin

41 Enter Simple Data into a Spreadsheet

See Also

43 About Calc Formulas

The active cell has a darkened border around it and accepts whatever data you enter next . As you press an arrow key, Calc moves the cell pointer in the direction of the arrow to a new cell, making the new cell the active one. Once you begin typing inside a cell, the insertion point appears. Unlike in Writer, though, the insertion point is not your primary means of traversing spreadsheets; rather, the active cell is.



If you select multiple cells , the selection is considered to be a single set of active cells.

If you're working with a rather large sheet, you might find the Navigator dialog box useful. Press F5 to display the Navigator dialog box, where you can select a range of cells that you might have previously named or enter a cell address, such as C141 , to jump to that cell. You may also click any object in the Navigator dialog box, such as a sheet name, or select a range name to jump to.

Use the Navigator dialog box to move around a spreadsheet efficiently .


Table 6.2 lists the most commonly used navigational keystrokes within Calc. Use your mouse to scroll with the scrollbars.

Table 6.2. Using the Keyboard to Navigate Calc

Press This Key

To Move

Arrow keys

The direction of the arrow, one cell at a time

Ctrl+up arrow, Ctrl+down arrow

The topmost or bottommost cell that contains data or, if at the end of the range already, the next cell that contains data

Ctrl+left arrow, Ctrl+right arrow

The leftmost or rightmost cell that contains data or, if at the end of the range already, the next cell that contains data

PageUp, PageDown

The previous or next screen of the worksheet


The upper-left corner of the worksheet (cell A1)

Ctrl+PageUp, Ctrl+PageDown

The next or previous sheet within the current spreadsheet

 <  Day Day Up  >  

Sams Teach Yourself OpenOffice.org All In One
Sams Teach Yourself OpenOffice.org All In One
ISBN: 0672326183
EAN: 2147483647
Year: 2003
Pages: 205
Authors: Greg Perry

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net