1. Home
  2. Selecting Coloured Cells

Selecting Coloured Cells

You can select all cells in a spreadsheet that have been coloured using a bookmark, a temporary missing value or manually coloured. You can select the individual cells or all rows/columns that contain a coloured cell.

Note: Cells that have been coloured using conditional formatting or factor levels cannot be selected using this menu.

  1. From the menu select Spread | Select | Coloured Cells.

  2. Click the appropriate button to select cells, rows or columns as required.
Updated on February 27, 2019

Was this article helpful?