Spreadsheet

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference >

Spreadsheet

Interface Elements for Desktop > Spreadsheet

This section describes the capabilities provided by the Spreadsheet.

img21270

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

Data Analysis and Presentation

•Outline Data

•Subtotal Data

•Sort Data

•Filter Data

Protection

•Protect a Workbook

•Protect a Worksheet

•Protect Worksheet Ranges

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

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

Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.

Send Feedback on this topic to DevExpress.