How to select multiple cells in Excel
I’m sure you know how to select a cell. All you have to do is click on the cell in your worksheet using your mouse.
But to selecting multiple cells involves more than just one click.
The most commonly used way to select multiple cells is to click and drag. You need to click on a cell and drag it over the spreadsheet.
Open your practice workbook and select all the cells with data in the worksheet👇
- Press on a cell.
- Drag it over the cells you want to select.
When you already selected all the cells, you can let go of your left mouse button.
The selected cells are now called a cell range. A cell range in Excel is a group of selected cells.
There are other ways to select multiple cells in Excel. That is by using the Shift key or Control key on your keyboard.
How to select multiple cells with the Shift key
This is a pretty awesome and easy hack for selecting multiple cells.
- First, click on a cell.
For our example, click cell A1 in our practice workbook.
- Hold down the Shift key on your keyboard.
- Click on another cell in your worksheet.
Let’s click cell D10 in our worksheet.
When you clicked the last cell, it selected all the cells in its range. This is an awesome alternative to the dragging method of selecting multiple cells👍
There’s one more way you can select multiple cells using the shift key. It’s by using it with the arrow buttons.
Select multiple cells using the Shift and Arrow keys
Let’s try it in our worksheet. Let’s select all the cells in a row in our table.
Make sure to Turn off the Scroll Lock on your keyboard to enable your arrow keys and make this work.
- Select cell A3.
- Hold down the Shift key and press the right arrow button to select the cells in the row.
Now, you have selected the cells within that row😀
You can do this too when selecting cells in columns.
This time, use the arrow down button with the Shift key.
Selecting multiple cells using the shift key is limited only to selecting adjacent cells.
Adjacent cells are cells that are placed close together. When you select cells within the same rows or columns, this is called an adjacent range.
Pretty awesome, right? 🤯 Wait until you see how you can select multiple cells in excel with the Control key too.
How to select multiple cells with the Control key
With the use of the Control key (Ctrl) on your keyboard, you can select or deselect multiple cells that are not connected to each other.
Of course, you can also select adjacent cells with the Control key. But this is most useful when you select non-adjacent cells in Excel😀
Here’s how to select non-adjacent cells in excel with the Control key.
Let’s select the cells that have male names in them in column A.
- Click on any cell. For our example, click cell A3.
- Hold down the Ctrl key when selecting other cells.
- Click on the other cells.
In our example, the male names are in the list.
In our example, we selected cells within the same column.
But the Control key is not limited to selecting adjacent cells.
You can select non-adjacent cells in your worksheet like this🙌
Amazing, right? If you would like to deselect a cell, simply click on it again.
Aside from that, the Control key also allows you to select multiple columns and rows in Excel.