Designer Tabs
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. |
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. |