Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice Calc User Guide
Home Next Page

Table of Contents

  • Copyright ii

  • Authors ii

  • Feedback ii

  • Publication date and software version

    Introducing Calc: Using Spreadsheets in OpenOffice.org

  • What is Calc?
  • Spreadsheets, sheets and cells
  • Parts of the main Calc window
  • Title bar and Menu bar
  • Toolbars
  • Formula bar
  • Individual cells
  • Sheet tabs
  • File management
  • Starting new spreadsheets
  • From the File menu
  • From the toolbar
  • From the keyboard
  • Opening existing spreadsheets
  • From the File menu
  • From the toolbar
  • From the keyboard
  • Opening from a template
  • Saving spreadsheets
  • From the File menu
  • From the toolbar
  • From the keyboard
  • Navigating within spreadsheets
  • Going to a particular cell
  • Using the mouse
  • Using a cell reference
  • Using the Navigator
  • Moving from cell to cell
  • Using the Tab and Enter keys
  • Using the cursor keys
  • Using Home, End, Page Up and Page Down
  • Moving from sheet to sheet
  • Using the keyboard
  • Using the mouse
  • Selecting items in a sheet or spreadsheet
  • Selecting cells
  • Single cell
  • Range of contiguous cells
  • Range of non-contiguous cells
  • Selecting columns and rows
  • Single column
  • Single row
  • Multiple columns or rows
  • Entire sheet
  • Selecting sheets
  • Single sheet
  • Multiple contiguous sheets
  • Multiple non contiguous sheets
  • All sheets
  • Working with columns and rows
  • Inserting columns and rows
  • Single column or row
  • Multiple columns or rows
  • Deleting columns and rows
  • Single column or row
  • Multiple columns or rows
  • Working with sheets
  • Inserting new sheets
  • Deleting sheets
  • Single sheet
  • Multiple sheets
  • Renaming sheets
  • Viewing Calc
  • Using the zoom function
  • Freezing rows and columns
  • Freezing single rows or columns
  • Freezing a row and a column
  • Unfreezing
  • Splitting the window
  • Splitting the screen horizontally
  • Splitting the screen vertically
  • Removing split views
  • Entering data into a sheet
  • Entering numbers
  • Entering text
  • Entering numbers as text
  • Entering dates and times
  • Entering, Editing and Formatting Data



    Creating Charts and Graphs



    Printing with Calc



    Using Graphics in Calc



    Using Styles in Calc

    Editing, Changing, and Reviewing

    Keyboard Shortcuts



    Description of Functions



    Calc Error Codes



    OpenOffice Calc User Guide
    Home Next Page

     
     
      Published under the terms of the Open Publication License Design by Interspire