The SpreadSheet Designer offers a streamlined ribbon interface, which contains menus, tabs, groups, and commands to customize spreadsheet data efficiently. Tabs within the designer organize similar commands into logical groups. For example, the Home tab consolidates frequently used commands such as font settings, alignment, styles, and formatting, serving as the primary workspace for users.

Additionally, each tab in the ribbon is divided into groups that contain commands related to specific tasks. For example, the Alignment group within the Home tab provides commands for adjusting vertical and horizontal text alignment, modifying indents, wrapping text, and merging cells.

The following sections provide detailed information about each tab present in the designer.

File Tab

The File tab includes the basic required options to load and save new or existing spreadsheets. It also provides options to view and access recently used files, print documents, and close the application.

The following image shows the File tab.

The tab options are explained in the table below.

Option	Description
New	Creates a new spreadsheet.
Open	Opens an existing file.
Save	Saves the current spreadsheet. If the file has been previously saved, it updates that file. However, if it is a new file, a dialog box will appear requesting the file name and type.
Save As	Saves the current file under a new name or in a different file type.
Recent	Displays a list of recently opened files for quick access.
Print	Prints the spreadsheet with customizable settings, including page margins, orientation, and scaling.
Exit	Closes the designer application.

Home Tab

The Home tab allows you to perform standard clipboard operations (cut, copy, paste), apply cell formatting, set conditional formatting, and define cell styles. It also allows you to sort and filter the data.

The following image shows the Home tab.

The following table lists the groups present under the Home tab:

Group	Description
Clipboard	Provides options to cut, copy, and paste the data between selected ranges within the spreadsheet.
Font	Provides options to set the font style, size, and color for all text.
Alignment	Provides options to set text alignment, wrapping, and creating cell spans for better layout control.
Number	Provides options to specify cell formatting.
CellType	Provides options to add various cell types to enhance spreadsheet functionality.
Styles	Provides options to set conditional formatting and cell styles.
Editing	Provides options to clear, sort, and filter the data.

Insert Tab and Design Tab

The Insert tab allows you to add tables and charts to the spreadsheet.

The following image shows the Insert tab.

The following table lists the groups of the Insert tab:

Group	Description
Tables	Allows to add a table to the spreadsheet.
Charts	Allows to add various charts to the spreadsheet.

When you add a table or chart to the spreadsheet, a Design tab appears, providing options to configure additional settings specific to the selected object.

Table Design Tab

The following image shows the Table tab that appears only after adding a table to the spreadsheet.

The following table lists the available groups in the Table tab:

Group	Description
Properties	Provides options to set the name and size of the table.
Tools	Provides the option to convert the table into a normal range.
Table Style Options	Provides options to customize the appearance of the table.
Table Styles	Provides options to set predefined or custom set of formatting options to the table.

Chart Design Tab

The following image shows the Chart Design tab that appears only after adding a chart to the spreadsheet.

 

The following table lists the groups present in the Chart Design tab:

Group	Description
Chart Layout	Provides options to set elements of the chart.
Chart S…	Provides options to set the color of the chart.
Data	Provides options to manage the data.
Type	Provides options to change the chart type.

Page Layout Tab

The Page Layout tab allows you to control and customize how the workbook or worksheet content will appear on the printed page.

The following image shows the Page Layout tab.

The following table lists the group options of the Page Layout tab:

Group	Description
Page Setup	Provides options to set margins, orientation, page size, print area, page breaks, and page titles.
Scale to Fit	Provides options to adjust page width, height, and scale.
Sheet Options	Provides options for gridlines and heading display view for the active worksheet and print.

Formulas Tab

The Formulas tab allows you to add formulas and custom names.

The following image shows the Formulas tab.

The following table lists the group options of the Formulas tab:

Group	Description
Defined Names	Provides options to create, edit, delete, and search all the custom names used in your workbook.
Calculation	Provides options to specify whether formulas are calculated manually or automatically.
Calculation Engine	Provides the option to use dynamic arrays in the spreadsheet.

Data Tab

The Data tab allows you to sort, group, and validate data. It also provides the option to protect the workbook with a password.

The following image shows the Data tab.

The following table lists the group options of the Data tab:

Group	Description
Protect	Provides the option to protect a workbook by entering a password.
Sort	Provides options to sort rows or columns based on selected criteria.
Data Tools	Provides options to prevent invalid data from being entered into a cell.
Outline	Provides options to group/ungroup rows or columns.

View Tab

The View tab allows you to show or hide sheet tabs, gridlines, headers, formula bar, etc. You can also freeze rows and columns and split panes.

The following image shows the View tab.

The following table lists the group options of the View tab:

Group	Description
Show	Provides options to show or hide sheet tabs, gridlines, formula bar, headers, etc.
Window	Provides options to freeze rows and columns, as well as to split windows for better viewing.