|
 Enables
you to skip quickly to any address or named
range in the workbook. This is handy to expand a
column if you have set the width to zero, e.g.
column A you can just type in the go to box A1
and then reset the width using
Format>Column>Width... and typing in a number.
More importantly, this dialog has a
'special...' button that fires another dialog
(shown below), allowing you to select or go to
some special places in XL such
 as
comments, blanks, constants (Cells without
formulas), etc. This can be a great shortcut
when trying to delete all values and leave
formulas or selecting cells for un-protecting/protecting,
etc. The dialog is shown left.
Below is a quick explanations
of all the options...
Comments: Finds and
selects all cells with comments.
Constants: Finds and selects all the
cells with entered text or numbers, NOT formulae.
This will also enable the four options below
'Formulas' so you can select certain types of
constants.
Formulas: Finds and selects all cells
with formulae, you can sub-select to include all
or just certain types of formulae.
Blanks: Selects all cells which are empty
Current region: Selects the area around
the currently selected cell(s) that make a
contiguous area Current
array: Select all the other cells in the
array if the selected cell(s) is part of an
array. Objects: Selects
all controls, charts, etc on the worksheet.
Row differences/Column differences:
Selects the cells in rows or columns that are
different from the selected cell(s)
Precedents: Cells which are
referenced by formulae in the selected cell.
(See Dependants)
Dependants: Cells with formulae that
reference the selected cell. (See Precedents).
Both of these can be set to only show direct or
all levels (Indirect = referenced through other cells).
Last cell: The last cell that has either
data or a formula in it on the worksheet. Beware
Excels
UsedRange issue!
Visible cells only: Select only cells on the
active worksheet that are visible. This is handy
when filtering lists or hidden columns are
involved. Conditional
formats: Cells on the worksheet that contain
conditional formatting attributes. These can be
'any' or the same as the selected cell.
Data validation: Cells on the worksheet
that contain data validation attributes, you can
choose 'any' or only the same as the selected
cell. |
