# Angular Spreadsheet Menu & Toolbar Tools

The Spreadsheet component provides a variety of built-in tools that help you create, edit, and style the sheet data. To access the built-in tools, use the menu that is located at the top of the Spreadsheet.

## Main Menu

The Kendo UI for Angular Spreadsheet component has five menu items. Each menu item contains a set of tools that help users manage their data in the sheets:

* **File**—Contains tools for importing and exporting from and to `.xlsx` files. Read more about the [Excel Import & Export...](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/import-export/excel)
* **Home**—Contains tools for formatting the Spreadsheet, such as changing the font, alignment, and borders of cells. Read more about the [**Home** menu items...](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/tools#home-menu-item-tools)
* **Insert**—Contains tools for inserting and deleting rows, columns and links. Read more about the [**Insert** menu items...](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/tools#insert-menu-item-tools)
* **Format**—Contains tools for increasing and decreasing decimals. Read more about the [**Format** menu items...](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/tools#format-menu-item-tools)
* **View**—Contains tools for merging cells and toggling the sheet grid lines. Read more about the [**View** menu items...](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/tools#view-menu-item-tools)
* **Data**—Contains tools for [sorting and filtering data](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/filtering-sorting), as well as applying [data validation to cells](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/validations).

To rearrange the order of the menu items or set the active menu item, set the [`menuItems`](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/api/spreadsheetcomponent#menuitems) property to a [`SpreadsheetMainMenuItem`](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/api/spreadsheetmainmenuitem) object.

The following example demonstrates how to rearrange the default order and set the **File** menu item as active.

[Demo Source](https://demos.telerik.com/kendo-angular-ui/demos/spreadsheet/tools/menu/source.txt)

## Home Menu Item Tools

The **Home** menu item of the Spreadsheet contains a variety of built-in tools that help you to format and style the text in a variety of ways and make it more readable and visually appealing. You can use these tools to create a professional-looking Spreadsheet that is easy to read and understand. For example, you can make the header row stand out, highlight important data, or format cells by using predefined formats.

The following example demonstrates the built-in tools of the **Home** menu item in the Spreadsheet.

[Demo Source](https://demos.telerik.com/kendo-angular-ui/demos/spreadsheet/tools/home/source.txt)

## Insert Menu Item Tools

The **Insert** menu item is a useful tool for managing the rows and columns in a Spreadsheet component. You can easily insert or delete rows and columns in various directions.

The following example demonstrates the built-in tools of the **Insert** menu item of the Spreadsheet.

[Demo Source](https://demos.telerik.com/kendo-angular-ui/demos/spreadsheet/tools/insert/source.txt)

## Format Menu Item Tools

The **Format** menu item contains tools for managing decimals.

The following example demonstrates the built-in tools of the **Format** menu item of the Spreadsheet.

[Demo Source](https://demos.telerik.com/kendo-angular-ui/demos/spreadsheet/tools/format/source.txt)

## View Menu Item Tools

The **View** menu items allow you to merge and unmerge cells and toggle the sheet grid lines.

The following example demonstrates the built-in tools of the **View** menu item of the Spreadsheet.

[Demo Source](https://demos.telerik.com/kendo-angular-ui/demos/spreadsheet/tools/view/source.txt)

## Data Menu Item Tools

The **Data** menu item contains tools for [sorting and filtering data](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/filtering-sorting), as well as applying [data validation to cells](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/validations).

## Suggested Links

* [Spreadsheet Data Validation](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/validations)
* [API Reference of the Spreadsheet](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/api)
* [API Reference of the `SpreadsheetComponent`](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/api/spreadsheetcomponent)
* [Excel Import & Export](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/import-export/excel)
* [PDF Export](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/import-export/pdf-export)
* [JSON Import & Export](https://www.telerik.com/kendo-angular-ui-develop/components/spreadsheet/import-export/json)