How to Select Multiple Cells in Excel – Fast and Easy

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

There are times when you need to select multiple cells in the spreadsheet.

But what should you do to make this process faster? Should you use the ‘Shift’ key? ‘Ctrl’ key? 🤔

In this article, let’s discuss the different ways on how you could select multiple cells in Excel.

Kasper Langmann, Co-founder of Spreadsheeto

Let’s get started!

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

How to select multiple cells by dragging

The first method to select multiple cells is probably the most used of them all.

It’s by dragging the mouse over the spreadsheet.

All you have to do is click on a cell and drag it over the spreadsheet.

How to select multiple cells by dragging

This will select all the cells in its path.

What happens after dragging the mouse over the spreadsheet

How to select multiple cells with the ‘Shift’ key

The other way is to use the ‘Shift’ key on your keyboard.

The first thing to do is to click on a cell.

How to select multiple cells with the ‘Shift’ key

Then, press and hold the ‘Shift’ key on your keyboard.

Now, while holding the ‘Shift’ key, click on another cell in the spreadsheet.

What happens after holding the shift key and clicking on another cell

All the cells included in its range will be selected.

How to select cells with the ‘Ctrl’ key

With the use of the ‘Ctrl’ key on your keyboard, you can select or deselect multiple cells not connected to each other.

To do this, simply click on a cell.

How to select cells with the ‘Ctrl’ key

Then, press and hold the ‘Ctrl’ key on your keyboard.

While holding the ‘Ctrl’ key, click on another cell or cells that you want to select.

What happens when you hold the control key and click on another cell

If you would like to deselect a cell, simply click on it again.

How to select rows and columns by their headers

You could also select all the cells within the column or row by clicking on its column header or row header.

How to select rows and columns by their headers

You can also use the methods earlier like dragging and holding the ‘Shift’ or ‘Ctrl’ key to select multiple rows and columns.

For example, using the ‘Ctrl’ key, you could select different rows and columns within the spreadsheet.

How to select multiple rows and columns by holding the control key

Fast and easy! 😉

Wrapping things up…

As you can see, there are different ways to select multiple cells in Excel quickly and easily. The most intuitive and common method is by dragging the mouse over the spreadsheet or using the ‘Shift’ key.

You could also select or deselect multiple cells, rows, and columns by using the ‘Ctrl’ key on your keyboard. This method could be combined with dragging the mouse and using the ‘Shift’ key.

Kasper Langmann, Co-founder of Spreadsheeto