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 (load, create and save workbooks, add or remove worksheets, format cells, insert rows and columns, etc.).

File Tab

• Create a Workbook
• Load a Workbook
• Save a Workbook
• Print a Workbook
• Undo and Redo Last Actions
• Encrypt a Workbook with the Password

Home Tab

• Copy and Paste Cell Content
• Format Cells
• Format Cell Content
• Wrap Text and Merge Cells
• Number Formatting
• Conditional 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

Insert Tab

• Create a Pivot Table
• Create a Table
• Insert a Picture
• Move, Rotate and Resize a Picture
• Insert and Delete Hyperlinks
• Charting Overview
• Creating a Chart
• Changing a Chart Type
• Applying a Predefined Chart Layout and Style
• Modifying a Chart Manually
• Insert a Symbol

Page Layout Tab

• Adjust Page Settings

Formulas Tab

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

Data Tab

• Sort Data
• Filter Data
• Validate Data in Cells
• Outline Data
• Subtotal Data

Review Tab

• Insert a Comment
• Protect a Workbook
• Protect a Worksheet
• Protect Worksheet Ranges

View Tab

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

Mail Merge Tab

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