Show / Hide Table of Contents

Spreadsheet

This section describes the capabilities provided by the Spreadsheet.

Spreadsheet.png

Spreadsheet UI

  • Ribbon Interface
  • Spreadsheet Elements

File Operations

  • Create a Workbook
  • Load a Workbook
  • Create a Worksheet
  • Rename a Worksheet
  • Delete a Worksheet
  • Save a Workbook
  • Import and Export Text Files
  • Print a Workbook
  • Adjust Page Settings
  • Undo and Redo Last Actions

Viewing and Navigating

  • Hide and Display Worksheets
  • Zoom a Worksheet
  • Hide Gridlines and Headings
  • Freeze Columns and Rows

Editing Cells

  • Select Cells or Cell Content
  • Copy and Paste Cell Content
  • Fill Data Automatically
  • Find and Replace
  • Insert a Comment
  • Insert a Symbol

Cell Formatting

  • Format Cells
  • Format Cell Content
  • Wrap Text and Merge Cells
  • Number Formatting
  • Conditional Formatting
  • Clear Cell Formatting

Columns and Rows

  • Insert and Delete Columns and Rows
  • Show and Hide Columns and Rows
  • Specify Column Width and Row Height

Tables

  • Create a Table

Pivot Tables

  • Create a Pivot Table
  • Modify a Pivot Table
  • Refresh the PivotTable Data
  • Change the PivotTable Layout
  • Apply a Predefined Style to a Pivot Table
  • Change the PivotTable Layout
  • Subtotal and Total Fields in a Pivot Table
  • Group Items in a Pivot Table
  • Sort Items in a Pivot Table
  • Filter a Pivot Table
  • Insert a Calculated Field and Calculated Item

Data Analysis and Presentation

  • Outline Data
  • Subtotal Data
  • Sort Data
  • Filter Data

Protection

  • Protect a Workbook
  • Protect a Worksheet
  • Protect Worksheet Ranges
  • Encrypt a Workbook with the Password

Data Validation

  • Validate Data in Cells

Formulas

  • Create a Simple Formula
  • Cell References
  • Defined Names
  • Using Functions in Formulas
  • Supported Functions
  • Create an Array Formula
  • Error Types in Formulas

Charting

  • Charting Overview
  • Creating a Chart
  • Changing a Chart Type
  • Applying a Predefined Chart Layout and Style
  • Modifying a Chart Manually
  • Creating a Chart Sheet

Mail Merge

  • Mail Merge Overview
  • Data Source Wizard
  • Query Builder
  • Parameters Panel

Pictures and Hyperlinks

  • Insert a Picture
  • Move, Rotate and Resize a Picture
  • Insert and Delete Hyperlinks
  • Shortcuts to Work with Pictures

Keyboard Shortcuts

  • File Operations
  • Navigation inside Worksheets
  • Work with Selections
  • Copy, Paste and Edit the Cell Content
  • Cell Formatting
  • Work with Columns and Rows
  • Sort and Filter
  • Work with Formulas
  • Improve this Doc
In This Article
Back to top Copyright (c) 1998-2022 Developer Express Inc. All rights reserved.