Microsoft Excel 2007 tutorial: select columns


Select columns

XVI. Select columns

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:

XVI.1. Keyboard shortcut keys

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.

Excel 2007 select entire column through keyboard

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:

Excel 2007 the last used cell of a column

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.

Excel 2007 select adjacent columns

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.

Excel 2007 select nonadjacent columns

XVI.2. Mouse

It is very easy by using mouse to select an entire column; you just click the column heading.

Excel 2007 select a column by mouse-click

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.

  


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.