Starting New 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 >

Starting New Spreadsheets

You can start a new, blank document in Calc in several ways.

• From the operating system menu, in the same way that you start other programs. When AOO was installed on your computer, in most cases, a menu entry for each component was added to your system menu. Mac users should see the OpenOffice icon in the Applications folder. When you double-click this icon, AOO opens at the Start Center (Figure 14).

• From the Quickstarter, which is found in Windows, some Linux distributions, and in a slightly different form, in macOS. The Quickstarter is an icon that is placed in the system tray or the dock during system startup. It indicates that OpenOffice has been loaded and is ready to use.

Right-click the Quickstarter icon (Figure 13) in the system tray to open a pop-up menu from which you can open a new document, open the Templates and Documents dialog box, or choose an existing document to open. You can also double-click the Quickstarter icon to display the Templates and Documents dialog box. See Chapter 1 (Introducing OpenOffice) in the Getting Started guide for more information about using the Quickstarter.

Figure 13: Quickstarter pop-up menu on Windows

• From the Start Center. When AOO is open without any documents open, e.g., if you close all the open documents but leave the program running, the Start Center is shown. Click one of the icons to open a new document of that type, or click the Templates icon to start a new document using a template. If a document is already open in AOO, the new document opens in a new window.

Figure 14: OpenOffice Start Center

When AOO is open, you can start a new document in any of the following ways.

• Press the  Control  +  N  keys.
• Use File → New → Spreadsheet.
• Click the  New  button on the main toolbar.