Spreadsheets, Sheets, and Cells

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 >

Spreadsheets, Sheets, and Cells

Calc works with entities called spreadsheets. Spreadsheets are not necessarily stand-alone and can be composed of multiple individual sheets, each sheet containing cells organized in rows and columns. A specific cell is identified by its row number and column letter – for instance, D7 for row 7, column D, as in the illustration below.

Cells hold data, including text, numbers, formulas, and so on, that make up what will be displayed and manipulated. A spreadsheet can have many sheets, each with many individual cells. Each sheet can have a maximum of 1,048,576 rows and a maximum of 1024 columns.