

Quickly formats a range of cells and converts it to a Table by choosing a pre-defined Table Style.ĭisplays the value of the cell as a percentage.Ĭhoose how the values in a cell are displayed: as a percentage, as currency, as a date or time, etc. Makes all content visible within a cell by displaying it on multiple lines. Removes the arrows drawn by Trace Precedents or Trace Dependents. This is only necessary if automatic calculation has been turned off. This is only necessary if automatic calculation has been turned off.Īlternates between displaying cell values and displaying formulas in the worksheet.Įdits the formula in the current cell by choosing functions and editing the arguments.ĭisplays the Create Name from Selection dialog box.Ĭalculate the entire workbook now.

Names cells so that you can refer to them in formulas by that name.Ĭhecks for common errors that occur in formulas.Ĭalculates the current sheet now. Shows arrows that indicate what cells are affected by the value of the currently selected cell. Available only if there are existing names in the workbook.Ĭhoose a name used in this workbook and insert it into the current formula.ĭisplays a list of recently used functions.
