On a worksheet, you can select an entire column, adjacent columns, and nonadjacent columns by using keyboard shortcuts or by using mouse. For using keyboard shortcut keys and using mouse to select what we mentioned will describe as the following:
To select an entire column, you just place cell pointer to the cell next to the column heading, hold down Shift key with Ctrl key and then press Down Arrow (Shift +Ctrl + Down Arrow) or you can use Shift + Ctrl +Up Arrow when you want to select the entire column from the last cell the of the column you intend to select.
Note: If the column contains data, pressing Ctrl +Shift +Down Arrow selects the column to the last used cell. Pressing Ctrl +Shift +Down Arrow again selects the entire column. The figure of the last used cell of a column is shown below:
To select adjacent columns, you need to select the first column by following the selection of an entire column above, hold down Shift key, and then press Left Arrow or Right Arrow key to add to the selection. For example, you selected the second column in a worksheet and want to extend the selection to the fifth column. To do this task, you need to use Right Arrow key. After you selected the the second column, hold down Shift key, and then press Right Arrow till the fifth column.
For another example, you selected the third column and want to extend the selection to the first column. To do this task, you need to use Left Arrow key. After you selected the third column, hold down Shift key, and then press Left Arrow back to the first column or after selecting the third column, keep holding down Shift +Ctrl, and then press Left Arrow.
To select nonadjacent columns, select the first column by following the selection of an entire column, then press Shift + F8 to add to selection, and then press Left Arrow or Right Arrow to move cell pointer to other columns you want to extend the selection. For example, you want to select only the first, third, and fifth columns in a worksheet. To do this task, follow the procedure below:
1. Select the first column by placing cell pointer to the first cell of the first column, then hold down Shift with Ctrl, and then press Down Arrow (Shift + Ctrl + Down Arrow).
2. Press Shift + F8, Excel displays Add to Selection on the status bar.
3. Press Right Arrow to move cell pointer to the first cell of the third column.
4. Select the third column by following step one.
5. Press Shift + F8
6. Press Right Arrow to move cell pointer to the first cell of the fifth column.
7. Select the fifth column.
It is very easy by using mouse to select an entire column; you just click the column heading.
To select adjacent columns, drag across the column headings or select the first column heading, and then hold down Shift while you click the last column heading.
You sometimes want to select nonadjacent columns. To do this, click the first column heading of your selection, and then hold down Ctrl while you click other column headings to add to the selection.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: