Home / Computers / Microsoft Excel

Menu Options

The Microsoft Excel menu bar contains all the commands required to create, work with, print, and save workbooks. To access these commands, click the name of the menu to open it, and then click the command you want to access.

Each menu groups together related commands, sometimes using submenus to further group commands:

• File - Create, open, save, print, and close workbooks.
• Edit - Perform editing functions on your workbook, including copying, cutting, and pasting data and objects, moving to various locations in a workbook, and undoing and redoing actions.
• View - Change the workbook's display size and style.
• Insert - Insert new worksheets, or additional space, such as new cells, columns, or rows; also insert charts, comments, functions, hyperlinks and other objects into your workbooks.
• Format - Apply formatting to worksheets and their contents.
• Tools - Use Excel's tools, such as the spell and grammar checker, macro recorder, and protection and collaboration features, and set your Microsoft Excel preferences.
• Data - Sort, filter, and otherwise arrange the data on your worksheets.
• Window - Switch between open workbook windows, or split the window of the current workbook.
• Help - Access Microsoft Excel's online help.

Note:

Additional menus may appear when you install a program that includes a Microsoft Excel plug-in.

To access a menu command, click the main menu to open it, and then select (click) the command. Excel hides those commands you don't use frequently, so if you don't see a command, click the double arrows at the bottom of the menu to expand it. Excel then displays all the available commands. Once you select a command, Excel includes it with the others you commonly use.