FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula. When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.

Detailed explanation-2: -Double click cell to follow formula or edit cell The default setting when you double click a cell is it allows you to edit the cell without going to the formula bar. To change this so that you can double click and you will be taken to the first link in the formula, you just need to change a setting.

Detailed explanation-3: -When you double-click on a cell, you are effectively re-entering the cell contents, which are then interpreted as numeric. One way that happens is: the cells were formatted as Text when data was entered, then the cell format was changed to General or a numeric format.

Detailed explanation-4: -Double clicking a formula cell does not highlight reference cells anymore between different worksheets. They show on the individual worksheet, just not between worksheets. Double clicking a formula cell does not highlight reference cells anymore between different worksheets.

Detailed explanation-5: -On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.