New to Kendo UI for AngularStart a free 30-day trial

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.

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 Data Import and Export...
  • Home—Contains tools for formatting the Spreadsheet, such as changing the font, alignment, and borders of cells. Read more about the Home menu items...
  • Insert—Contains tools for inserting and deleting rows, columns and links. Read more about the Insert menu items...
  • Format—Contains tools for increasing and decreasing decimals. Read more about the Format menu items...
  • View—Contains tools for merging cells and toggling the sheet grid lines. Read more about the View menu items...

To rearrange the order of the menu items or set the active menu item, set the menuItems property to a SpreadsheetMainMenuItem object.

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

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...

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.

Change Theme
Theme
Loading ...