Spreadsheet

This section describes the capabilities provided by the Spreadsheet.

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

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