Using the Navigator

Apache OpenOffice 4.1 Calc Guide

Chapter 1: Introducing Calc

< Previous Section

Next Section >

• What is Calc?
• Spreadsheets, Sheets, and Cells
• Parts of the Main Calc Window
  • Menu Bar
  • Toolbars
    • Displaying or Hiding Toolbars
    • Palettes and Tear-off Toolbars
    • Moving Toolbars
    • Docking/Floating Windows and Toolbars
    • Customizing Toolbars
    • Formatting Toolbar
  • Formula Bar
  • Sidebar
  • Right-click (Context) Menus
  • Individual Cells
  • Sheet Tabs
  • Status Bar
• Starting New Spreadsheets
  • Starting a New Document from a Template
• Opening Existing Spreadsheets
• Opening CSV Files
• Saving Spreadsheets
  • Saving as a Microsoft Excel Document
  • Saving as a CSV File
  • Saving in Other Formats
• Password Protection
• Navigating within Spreadsheets
  • Going to a Particular Cell
  • Moving from Cell to Cell
    • Customizing the Effects of the Enter Key
  • Moving from Sheet to Sheet
• Selecting Items in a Sheet or Spreadsheet
  • Selecting Cells
  • Selecting Columns and Rows
  • Selecting Sheets
• Working with Columns and Rows
  • Inserting Columns and Rows
  • Deleting Columns and Rows
• Working with Sheets
  • Inserting New Sheets
  • Deleting Sheets
  • Renaming Sheets
• Viewing Calc
  • Using Zoom
  • Freezing Rows and Columns
  • Splitting the Screen
    • Splitting the Screen Horizontally
    • Splitting the Screen Vertically
    • Removing Split Views
• Using the Navigator
  • Moving Quickly through a Document
  • Choosing a Drag Mode
• Using Document Properties

< Previous Page

Next Page >

Using the Navigator

In addition to the cell reference boxes (labeled Column and Row), the Navigator provides several other ways to move quickly through a spreadsheet and to find specific items.

To open the Navigator, click its icon on the Sidebar or the Standard toolbar, press  F5 , choose View → Navigator on the Menu bar, or double-click on the Sheet Sequence Number in the Status Bar. You can dock the Navigator to either side of the main Calc window or leave it floating. To dock or float the Navigator, hold down the Control key and double-click in an empty area near the icons at the top.

The Navigator displays lists of all the objects in a spreadsheet document, grouped into categories. If an indicator (plus sign or arrow) appears next to a category, at least one object of this kind exists. To open a category and see the list of items, click on the indicator.

To hide the list of categories and show only the icons at the top, click the Contents icon . Click this icon again to show the list.

Table 2 summarizes the functions of the icons at the top of the Navigator.

Icon	Action
	Data Range. Specifies the current data range denoted by the position of the cell cursor.
	Start/End. Moves to the cell at the beginning or end of the current data range, which you can highlight using the Data Range button.
	Contents. Shows or hides the list of categories.
	Toggle. Switches between showing all categories and showing only the selected category.
	Scenarios. Displays all available scenarios. Double-click a name to apply that scenario. See Chapter 9 (Data Analysis) for more information.
	Drag Mode. Choose hyperlink, link, or copy. See “Choosing a Drag Mode” for details.