User Interface Reference > Spreadsheet > Spreadsheet UI

Interface Elements for Desktop > Spreadsheet > 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.).

Ribbon Tab Name	Visual Appearance	Functionality
File		Create a Workbook Load a Workbook Save a Workbook Print a Workbook Undo and Redo Last Actions
Home		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		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		Adjust Page Settings
Formulas		Create a Simple Formula Cell References Defined Names Using Functions in Formulas Supported Functions Create an Array Formula Error Types in Formulas
Data		Sort Data Filter Data Validate Data in Cells Outline Data Subtotal Data
Review		Insert a Comment Protect a Workbook Protect a Worksheet Protect Worksheet Ranges
View		Zoom a Worksheet Hide Gridlines and Headings Freeze Columns and Rows
Mail Merge		Mail Merge Overview Data Source Wizard Query Builder Parameters Panel

Send Feedback on this topic to DevExpress.