1. Home
  2. Bookmark Spreadsheet by Value

Bookmark Spreadsheet by Value

Select menu: Edit | Bookmark | By Value

This dialog lets you bookmark cells within a spreadsheet using a particular criterion or logical condition. Bookmarked cells are indicated by a coloured background which you can change by selecting Tools | Options | then clicking the Fonts and Colours tab.

  1. From the menu select Edit | Bookmark | By Value.

You can jump between bookmarked cells by selecting Edit | Bookmark | Next by using the shortcut keys Alt+B. Similarly, you can search for previous bookmarks by selecting Edit | Bookmark | Previous 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.

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 Ctrl 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 all Select all the columns in the Select columns to search list.
Clear Clear the column selection in the Select 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 you enter.
Equal to (==) Values equal to the number you enter.
Greater than (>) Values greater than the number you enter.
Less than/equal (≤) Values less than or equal to the number you enter.
Not equal to () Values not equal to the number you enter.
Greater than/equal (≥) Values greater than or equal to the number you enter.
Missing (*) Any cells that are missing (displayed as an asterisk).
Minimum The smallest value in each column.
Maximum The largest value in each column.
Selected rows The 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

OK Bookmark cells in the selected columns.
Cancel Close the dialog, making no more changes.
Remove Remove all the bookmarks in the selected columns.
Clear all bookmarks Clear all the bookmarks in the current spreadsheet.

See also

Updated on March 21, 2019

Was this article helpful?