Ribbon Interface

The comprehensive functionality of the Spreadsheet is provided by a set of Ribbon pages. Ribbon pages are divided into logical groups that include commands with common features. Use the Ribbon interface to perform basic operations in the Spreadsheet (to create a workbook, create or delete worksheets, select data in a worksheet, navigate through a worksheet, etc.).

File

Create a Workbook

Load a Workbook

Save a Workbook

Print a Workbook

Home

Undo and Redo Last Actions

Copy and Paste Cell Content

Format Cells

Format Cell Content

Wrap Text and Merge Cells

Number Formatting

Clear Cell Formatting

Insert and Delete Columns and Rows

Show and Hide Columns and Rows

Specify Column Width and Row Height

Fill Data Automatically

Find and Replace

Format As Table

Insert

Insert a Picture

Move and Resize a Picture

Charting Overview

Creating a Chart

Changing a Chart Type

Applying a Predefined Chart Layout and Style

Modifying a Chart Manually

Insert and Delete Hyperlinks

Page Layout

Adjust Page Settings

Formulas

Create a Simple Formula

Cell References

Using Functions in Formulas

Supported Functions

Error Types in Formulas

Data

Sort Data

Filtering

Data Validation

Review

Comments

View

Document Views

Hide and Display Gridlines

Hide and Display Headings

Full Screen Mode

Freeze Panes