Spreadsheet
This section describes the capabilities provided by the Spreadsheet.
Spreadsheet UI
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
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
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
Protection
- Protect a Workbook
- Protect a Worksheet
- Protect Worksheet Ranges
- Encrypt a Workbook with the Password
Data Validation
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
Pictures and Hyperlinks
- Insert a Picture
- Move, Rotate and Resize a Picture
- Insert and Delete Hyperlinks
- Shortcuts to Work with Pictures
Keyboard Shortcuts