Selecting columns in Excel 2007

By default, every column looks alike. To identify the columns, Excel displays column header with letter(s). Column header appears at the top most part of the worksheet area.

Selecting a single column:
Perform any of the following to select a single column.

• To select an entire column, click on the column header.
• Click a cell that corresponds to the column. Press CTRL + SPACEBAR.
• Click the first cell in the column and press CTRL + SHIFT + DOWN arrow keys. If data is present then the selection is made till the end of the cells that contain the data. Pressing CTRL + SHIFT + DOWN arrow keys again will select the entire column provided that no data is present in between.

Selecting multiple columns:

• Select adjacent columns by clicking the column header and pressing the SHIFT key and finally clicking the column letter in the column header.
• Select nonadjacent columns by selecting the first column (click the column letter) and pressing the CTRL key and clicking other column letter(s) in the column header.