Introdcution

Apache OpenOffice 4.1 Calc Guide

Chapter 2: Entering, Editing, and Formatting Data

< Previous Section

Next Section >

• Introduction
• Entering Data Using the Keyboard
  • Entering Numbers
  • Entering Text
  • Entering Numbers as Text
  • Entering Dates and Times
  • Entering Special Characters
    • Inserting Dashes
  • Deactivating Automatic Changes
• Speeding up Data Entry
  • Using the Fill Tool on Cells
    • Using a Fill Series
    • Defining a Fill Series
  • Using Selection Lists
• Sharing Content between Sheets
• Validating Cell Contents
• Editing Data
  • Removing Data from a Cell
  • Replacing All the Data in a Cell
  • Changing Part of the Data in a Cell
• Formatting Data
  • Formatting Multiple Lines of Text
    • Using Automatic Wrapping
    • Using Manual Line Breaks
  • Shrinking Text to Fit the Cell
  • Formatting Numbers
  • Formatting the Font
  • Choosing Font Effects
  • Setting Cell Alignment and Orientation
    • Formatting the Cell Borders
  • Formatting the Cell Background
• Autoformatting Cells and Sheets
  • Defining a New AutoFormat
• Formatting Spreadsheets Using Themes
• Using Conditional Formatting
• Hiding and Showing Data
  • Outline Group Controls
    • Filtering Which Cells are Visible
  • Sorting Records
• Finding and Replacing in Calc
  • Using the Find Toolbar
  • Using the Find & Replace Dialog
  • Finding and Replacing Formulas or Values
  • Finding and Replacing Text
  • Finding and Replacing Cell Styles
  • Using Wildcards (Regular Expressions)

< Previous Page

Next Page >

Introduction

You can enter data into Calc in several ways:

• with the keyboard
• with dragging and dropping with the mouse
• with the Fill tool
• with selection lists.

Calc also allows users to enter information simultaneously into multiple sheets of the same document. Data can also be read from a database or text-based files like CSV (comma-separated values).