Search results
Results from the WOW.Com Content Network
The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula: =IF(CELL("type",A1)="v",A1*2,0)
Ctrl+Shift+Arrow key extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range. Select the range of cells, or make sure the active cell is in a table.
Follow these steps to display formula relationships among cells: Click File > Options > Advanced. In the Display options for this workbook section, select the workbook and then check that All is chosen in For objects, show. To specify reference cells in another workbook, that workbook must be open.
Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as the last cell on the worksheet that contains data or formatting.
A reference identifies a cell or a range of cells on a worksheet, and tells Excel where to look for the values or data you want to use in a formula. You can use references to use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas.
Direction Makes an adjacent cell the next active cell after you press ENTER in the current active cell. In the Direction box, indicate which adjacent cell becomes active. Automatically insert a decimal point Select this check box to display a number with decimal points by default.
Activate. To make a chart sheet or worksheet the active, or selected, sheet. The sheet that you activate determines which tabs are displayed. To activate a sheet, click the tab for the sheet in the workbook. Active cell. The selected cell in which data is entered when you begin typing. Only one cell is active at a time.
To include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to enter a formula that automatically uses structured references to calculate the amount of a sales commission.
To select all cells on a worksheet, use one of the following methods: Click the Select All button. Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.