Going to a particular 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 >

Using the mouse

Place the mouse pointer over the cell and left-click.

Using a cell reference

Click on the little inverted black triangle just to the right of the Name box (Figure 2). The existing cell reference will be highlighted. Type the cell reference of the cell you want to go to and press Enter. Or just click into the Name box, backspace over the existing cell reference and type in the cell reference you want.

Using the Navigator

Click on the Navigator button File:Nav-icon.jpg in the Standard toolbar (or press F5) to display the Navigator. Type the cell reference into the top two fields, labeled Column and Row, and press Enter. In Figure 4 the Navigator would select cell F5.

File:Calc-navigator.png

Figure 4: Calc Navigator.