You can specify which columns should be checked for duplicate information. Specify how cells connected to a data source will update, what contents from the source will be displayed, and how changes in the number of rows or columns in the data source will be handled in the workbook.ĭisplays all data connections for the workbook.Ĭonsolidate - Combines values from multiple ranges into one new range.ĭelete duplicate rows from a sheet. Refresh all - Updates all the information that is coming from a data source.Īdvanced - Specifies complex criteria to limit which records are included in the result set of a query. Refresh - Gets the latest data from the source connected to the active cell. Sorts the selection so that the lowest values are at the top of the column. Sorts the selection so that the highest values are at the top of the column. Sort - Shows the Sort dialog box to sort data based on several criteria at once. Ungroups a range of cells that were previously grouped. Prevent invalid data from being entered into a cell. Increases the margin between the border and the text in the cell.ĭecreases the margin between the border and the text in the cell.Ĭustomizes language, display, and other program settings. Removes the outline border from the selected cells.Ĭhanges currency format for the selected cell.Īligns text so that it is centered between the top and bottom of the cell. Shows the Alignment tab of the Format Cells dialog box.Īpplies the outline border to the selected cells. Shows the Number tab of the Format Cells dialog box. Shows the Font tab of the Format Cells dialog box. This will change the format of the cell to Accounting without a currency symbol.Ĭopies formatting from one place and apply it to another. Highlights interesting cells, emphasize unusual values, and visualize data using Data Bars, Color Scales, and Icon Sets based on criteria.ĭisplays the value of the cell with a thousands separator. 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.