. Selection Tools

. Select by Cells

. Select, hide, delete and color selected cells, rows and columns

. Options for selection include -

• Equal to

• Not Equal to

• Between

• Not  Between

• Greater Than

• Lesser Than

• Contains (within text)

• Doesn't Contain (within text)

• Unique Values

• Duplicate Values

• Every Nth Row

• Every Nth Column

• Top Borders

• Bottom Borders

• Left Borders

• Right Borders

• Blank Cells

• Cells With Formulas

• Cells With Values

• Cells With Errors

• Conditional Formatting

• Data Validation

• Locked Cells

• Unlocked Cells

• Visible Cells

• Hidden Cells

. Select by Format

. Options for selection include -

• Cells With Bold Font

• Cells With Italic Font

• Cells With Underline Font

• Cells With Strikethrough

• Cell Color

• Font Color

• Number Format

• Font Name

• Font Size

Back to download page