Bookmark Spreadsheet by Value

This dialog allows you to bookmark cells within a spreadsheet using a particular criteria or logical condition. Bookmarked cells are indicated by a coloured background which can customized via the Options - Fonts and Colours dialog.

You can jump between bookmarked cells by selecting Next from the Bookmark submenu on the Edit menu or by using the shortcut keys Alt+B. Similarly, you can search for previous bookmarks by selecting Previous from the Bookmark submenu on the Edit menu or by using the shortcut keys Alt+Shift+B.

When bookmarks are created using this menu, notes are attached automatically detailing the criterion used to create them.

Select Columns to Search

This lists numerical columns in the current spreadsheet. The columns that are selected will have cells bookmarked. A multiple selection of columns can be made by using the Control and Shift keys in combination with mouse clicks on columns. Alternatively, columns in the list can be selected or cleared using the following buttons:
Select AllSelect all the columns in the Columns to Search list.
ClearClear the column selection in the Columns to Search list.

Bookmark Values that are

Specify a search criterion to bookmark cells. The criteria available are:
Extremes (min,max)The smallest and largest value in each column.
Less than (<)Values less than the number provided in the edit box.
Equal to (==)Values equal to the number provided in the edit box.
Greater than (>)Values greater than the number provided in the edit box.
Less than/equal (≤)Values less than or equal to the number provided in the edit box.
Not equal to (<>)Values not equal to the number provided in the edit box.
Greater than/equal (≥)Values greater than or equal to the number provided in the edit box.
Missing (*)Any cells that are missing (displayed as an asterisk).
MinimumThe smallest value in each column
MaximumThe largest value in each column
Selected rowsThe selected rows in each column

Make these values temporarily missing

The bookmarked cells will be made temporarily missing, i.e. excluded from any calculations.

Action Buttons

OKBookmark cells in the selected columns.
CancelClose the dialog, making no more changes.
RemoveRemove all the bookmarks in the selected columns.
Clear All BookmarksClear all the bookmarks in the current spreadsheet.

See Also