Select any cell in the column you want to select.
Press Shift + PgDn to select one screenful of a column from the selected cell. To expand the selection of a column from the selected the cell up one screen, press Shift + PgUp.
This section describes how to select cells in the same column that do not match the cell in the active state.
Identify the column to validate items that do not match the contents of the specified cell. Select a single cell from that column.
Press Ctrl + Space to select all cells in the column containing the active cell.
Pressing Ctrl + Shift + | (vertical bar) will select only the cells that differ from the contents of the active cell.
Please send us your comments on this article.