Everyone will undoubtedly know how to select a cell in Excel, but I still want to show you a number of ways how you can do this efficiently.
When you select multiple cells we speak about a “cell range”. “Reach” in short.
To select a range whose cells are all next to, below or above each other, click and drag over the cells to be selected .
To select a range whose cells are not adjacent, hold down the Ctrl key on your keyboard while selecting the different cells.

More about cell ranges in the next lesson, first I will teach you how to select something in a quick way.
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 that you do not have to scroll all the way up to select a column.

To select all of the cells below that contain data, click the keyboard shortcut Shift + Ctrl + to the teaching arrow.
Same for the above, the right and left cells.
Only then click the respective arrow. You can achieve the same by holding down the Shift key on your keyboard, while double-clicking the bottom, top, left, or right edge of the selected cell.

To select all cells in a worksheet, click the button to the left of the column letters and above the row numbers (1). To select only the cells with content, place the cursor on one of the cells with content, and click the keyboard shortcut Ctrl + A on your keyboard .

If you would do the same thing in a table, using the shortcut combination Ctrl + A, I mean, then every cell with data would be selected, with the exception of the column titles.

Related Posts

Layout of text using the ribbon

What is a cell range?

How to lock rows and columns

Adjust width / height of columns and rows

How to create CREATING WORKBOOKS in Excel 2016

Comments

Reply comment

Your email address will not be published. Required fields are marked *