Available from the Ribbon:



Entire Row(s)

Selects the entire row(s) of the selected cells.


Entire Column(s)

Selects the entire columns(s) of the selected cells.


Blank Cells

Selects the blank cells from the selected range (as shown below). Blank cells may have a calculation as long as the result is nothing (no value is shown in the cell).



Non-Blank Cells

Selects the non-blank cells from the selected range (as shown below). Non-Blank cells show a value either a value or a calculation that returns a visible result (not nothing).



Empty Cells

Selects the empty cells from the selected range (as shown below). Empty cells don't have a value or a calculation.



Non-Empty Cells

Selects the non-empty cells from the selected range (as shown below). Non-Empty cells either contain a value or contain a calculation (regardless if the calculated value is a value or nothing).



Visible cells only

Selects only the visible (not filtered) cells with the current selection.


Duplicates

Finds duplicate cell values within the active range. If duplicates exist, they become the active selection (they can then be copied, coloured, etc.). If no duplicates exist, the user is informed by message box.

Created with the Personal Edition of HelpNDoc: Create help files for the Qt Help Framework