Excel: Select cells, rows or columns

Excel select cells: YOUR OBJECTIVE

You are working in Excel and you repeatedly need to select individual cells, cell ranges and entire rows and columns.

In this learning module “ Excel select cells” you will learn how to select cells, rows or columns in Excel.

Excel: Seclect cells – HOW DOES IT WORK?

If you want to perform changes in your table, you first need to select the section where you want to apply these changes.

The active cell is always considered selected. When you click in a cell it receives a black border and is therefore active.

It is often necessary to select more than one cell, in other words a cell range, such as cells A2, A3, A4, A5, B2, B3, B4 and B5. Click in the first cell of the section to be selected. Then hold down the left mouse button and drag the cursor to the last cell to be selected.

Excel seclect cells: HINT(1)

Cell ranges are always given in the A1:B4 format. The first value refers to the cell at the top left of the range, and the second value to the bottom right cell. The A1:B4 cell range therefore comprises cells A1, A2, A3, A4, B1, B2, B3 and B4.

Excel seclect cells: CAUTION

As you can see in the graphic, one cell in a group of selected cells is always the active cell. The cell is recognized because it, in contrast to the other cells in the group, has a white background. However, the cell still belongs to the selected range. Active means that the content of this cell is displayed in the formula bar and its coordinates are shown in the name field.

If you want to deselect the range, simply click anywhere outside of the selected section.

Excel eclect cells: Excel also offers the option of simultaneously selecting several cells that are not connected to each other, or selecting several cell ranges. To do this, first select the first cell or the first cell range, then press and hold down the [Ctrl] key while you select the other cells or cell ranges. Cells A1, B3, A4 and B5 are then selected in the following graphic.

 Excel seclect cells: HINT (2)

You can also use the keyboard for selecting cells. Click in a cell at the corner of the section you want to select. Press and hold down [Shift] and use the arrow keys  ,, , to select any section.

You can select entire rows or columns with one single click. To do this, click on the relevant row or column header. You will find the Row header in the gray column on the left edge of the worksheet. The row header contains the row number (1, 2, 3, etc.).

Likewise, you will also find the Column header in the gray row at the top of the worksheet. The column header contains the column labels (A, B, C, etc.).

If you want to select several rows or columns, press and hold down the left mouse button and drag the cursor over the relevant row or column headers. Release the mouse button when you have selected the rows or columns of your choice. When you place the cursor in a row or column header, it will change to a thick black arrow.

Excel eclect cells: HINT (3)

You can also select several connected rows or columns by selecting one row or column and then pressing and holding [Shift] while clicking on the last row or column that you want to select.

Excel seclect cells: HINT (4)

You can also select several non-connected rows or columns. First select one row or column, then press and hold down the [Ctrl] key while selecting the other rows or columns.

Click on the square above the Row header or to the left of the Column header to select the entire sheet.

 

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen