Let go of the left mouse button when you have marked the range A1:E10: The grey area helps us to see the covered range. Move to the mouse pointer to mark the selection range. Press and hold A1 with the left mouse button. Note: You will learn about why the range is called A1:E10 after this example. To select row 1, click on its number in the row bar: This will select all the cells in the sheet related to that row. To select column A, click on the letter A in the column bar: This will select all cells in the sheet related to the column. Lets try an example: Select the cells A1, A7, C1, C7 and B4.Ĭolumns are selected by left clicking it. Once finished with selecting, you can let go of CTRL or Command. More than one cell can be selected by pressing and holding down CTRL or Command and left clicking the cells.

It is easiest to use the mouse to select cells. You will learn more about the Name Box later in this chapter.Ĭells are selected by clicking them with the left mouse button or by navigating to them with the keyboard arrows. It can also be used to select cells or ranges by typing their values. The Name Box shows you the reference of which cell or range you have selected. There are four different operations for selection īefore having a look at the different operations for selection, we will introduce the Name Box. Range is an important part of Excel because it allows you to work with selections of cells.

How to find a range in excel