Selecting Data

Close Window 

Selecting Nonadjacent Columns and Rows

You can select and perform operations on nonadjacent columns (Columns A and C, for example), nonadjacent rows (Rows 1 and 3), or columns and rows (such as Column A and Row 3). Here's how:

  1. Click the heading for the first column or row you want to select.

  2. Hold down the Ctrl key and select any other rows or columns you want.

(Posted 6/9/2000)