Navigating within Spreadsheets

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 >

Navigating within Spreadsheets

Calc provides many ways to navigate within a spreadsheet, from cell to cell and sheet to sheet. Use the method you prefer!