About spreadsheet tools, commands, and options

The toolbar at the top of the spreadsheet provides a set of commands for working with spreadsheet data. To see the command name of each button, rest the pointer on the button. If you do not see a toolbar, or cannot display the toolbar, the designer of the Web page may have disabled it. If you are viewing the spreadsheet in a Spreadsheet Web Part and the designer has not disabled the toolbar, you can click the Toolbar command on the toolstrip to display and hide the toolbar.

The Commands and Options dialog box includes commands to find data in the spreadsheet, such as Find Next, and properties you can set, such as the background color of cells and the widths of columns. The dialog box also includes some commands that aren't present on the toolbar or shortcut menus. To display the dialog box, click Commands and Options on the toolbar.

The commands and properties in the Commands and Options dialog box are distributed among several tabs such as Formula, where you can see the formula in a selected cell or define names that can be used in formulas, and Format, where you can set number formats, change the color of text, select border styles, and more.

If you cannot display the Commands and Options dialog box, the designer of the Web page may have disabled it.