Selecting Cells

Everyone certainly knows how to select a cell in “Excel”, but I want to show you some ways of doing this efficiently.

When you select multiple cells, it is called a “Cell Range”. “Range” for short. To select the cells around a cell, i.e on all four sides, click drag and select the cells (1).

To select a “Range” of cells which are not adjacent to each other (2), hold the Ctrl key on your keyboard while you select the different cells.

More on cell ranges in the next lesson. First I’m gonna teach you a quick way to select something.

To select an entire column, we can click the column letter, but we can also use the keyboard shortcut ‘Ctrl Spacebar’. This has the advantage of not having to scroll up to the top of the column in order to select it.

To select all cells in which data resides, press the Shift + Ctrl shortcut while using the arrow keys.

Same goes for the cells located on the right-and left. Only then click the arrow, respectively.

The same can be achieved by holding the Shift key on your keyboard, while the lower, upper, left or right edge of the selected cell is double-clicked.

To select all cells in a “Worksheet”, select and click the button to the left of the column letters and row numbers above (1).
To select only the cells with content, place the cursor on any cell with content, and click the Ctrl A shortcut on your keyboard (2).

If you want to do the same in a table, use the Ctrl + A shortcut on your keyboard.

 

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats