Current array

Action: If the active cell is inside an array, it selects the entire array.

Comment: I've never utilized this option, but I'd love to know if anyone has.

Objects

Action: Chooses every thing, including charts, pictures, and forms.

Advantage: Easy to choose every item. If you wanted to swiftly remove every item in the worksheet, this might be helpful.

Row differences

Take action:

Single row: Chooses the cells in the chosen row that differ from the active cell.

Multiple rows: Each row is compared separately. Each row's comparison cell is the cell in the same column as the active cell.

Benefit: This is an excellent auditing tool for identifying a series of inconsistent formulas.

Column differences

Take action:

Single column: Chooses the cells in the chosen column that differ from the active cell.

Multiple columns: Each column is compared separately. The cell in the same row as the active cell serves as the comparison cell for each column.

Benefit: This auditing tool is excellent for pointing out incorrect formulas in a column. Additionally, it provides a rapid and simple method of identifying discrepancies between several columns.

Precedents

Action: Chooses the cells that supply the chosen cell or cells.

Choices:

Direct only: Only precedent at the first level

Every level: Every level of cell precedents

Benefit: Offers a substitute for Trace Precedents in the formula auditing bar. Since this tool lets you choose the precedents for multiple cells rather than just one, I personally like using it to choose and then color-fill the precedent cells. Additionally, I think Trace Precedents' arrows can get a little disorganized.

Dependents

Action: Chooses which cells the chosen cell or cells feed into

Choices:

Direct only: Dependents at the first level only

Every level: Every level of cell dependencies

Benefit: As mentioned above, this offers the formula auditing bar an option to Trace Dependents.

Last cell

Action: Chooses the final cell in your worksheet that contains formatting or data.

Benefit: An easy way to find your last cell. This is a highly efficient method of determining the worksheet's cell range.


Excel may mistakenly believe that you are utilizing a lot more cells than you actually are if your straightforward spreadsheet suddenly grows significantly in MB terms. The right-hand scroll bar slider getting extremely small is a good sign of this. You may quickly get the last cell Excel believes you are using by utilizing Go To Special Last cell.

Visible cells only

Action: Chooses cells that are visible since they are not hidden.

Benefit: Helpful if you wish to modify only the non-hidden cells while leaving the hidden cells unaltered

Conditional formats

Action: Chooses every cell that has conditional formatting applied.

Choices:

All: Chooses every cell that has conditional formatting applied.

Same: Chooses every cell that has the same conditional formatting as the cell that is now active.

Benefit: A simple method for rapidly identifying every cell that has conditional formatting applied to it. A helpful tool for comprehending how a spreadsheet is formatted.

You should be aware that depending on the conditional formatting specified, you might not be able to use fill color to highlight the cells since the conditional formatting may take precedence.

Comment: You can also find cells that have conditional formatting applied by using the manage rules option in the conditional formatting menu.

Data validation

Action: Chooses every cell that has data validation applied.

Choices:

All: Chooses every cell that has data validation applied.

Same: Chooses every cell with the same data validation as the active cell.

Benefit: A simple method for rapidly identifying every cell that has data validation applied to it. When it comes to auditing or clearing the validations in these cells, this is quite helpful.