# How to Select Multiple Cells in Excel (7 Useful Methods)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to select multiple cells in Excel, then you are in the right place. One of the most basic actions that we perform in Excel is to select multiple cells in an Excel file to do some operations. Here in this article, weâ€™ll try to discuss how to select multiple cells in Excel.

## 7 Ways to Select Multiple Cells in Excel

Excel offers different ways to select multiple cells. These are very handy to use. You just need to follow some simple steps. To show this, we have made a dataset named Salary Sheet of Employees. Weâ€™ll show how you can select multiple cells from here.

### 1. Dragging Mouse to Select Multiple Cells

This is the easiest way to select multiple cells. You just need to follow some simple steps.

• Firstly, click on the first cell of the database you want to select. Here I have left-clicked on cell B4.
• Secondly, drag your mouse over all the cells you want to select. After dragging over all the cells, leaving the mouse.

### 2. Using Keyboard Shortcut

Keyboard shortcut is a method by which we can select as many cells as we want both in Column wise and Row wise.

#### 2.1. Selecting Cells One by One

You can use a keyboard shortcut to select cells one by one.

• Firstly, select a cell. Here, we have selected cell B4.
• Secondly, press Shift + Down Arrow(â†“) to select the cells one by one column-wise. Here I have selected all the cells from B4 to B8 column-wise.

• Thirdly, then press SHIFT + ENDÂ to select the cells one by one row-wise. Here we have selected all the cells from Column B to E row-wise.

#### 2.2. Selecting Cells Together

By using the keyboard shortcut you can select cells altogether too.

• Firstly, click on the first cell of the database you want to select. Here, we have selected B4.
• Secondly, press CTRL + SHIFT + Down Arrow(â†“). It will select all the cells column-wise until there is a blank cell. Here all the cells from B4 to B11 have been selected.

• Thirdly, press CTRL + SHIFT + END. It will select all the cells row-wise until there is a blank cell in any row. Here we have selected Columns B to F.

Note: You can not also select non-adjacent cells in this way, only the adjacent cells.

### 3. Selecting Entire Rows

You can select an entire Row by following a single step.

• Just left-click on the number of the Row you want to select. All the cells in that Row will be selected. Here I have selected Row 7.

• Eventually, you can just drag your mouse and select adjacent Rows. I have selected Rows 5, 6, and 7

Additionally, you can select non-adjacent rows also.

• Just hold the CTRL key on your keyboard.
• Then click on the number of Rows. Here we have selected Rows 5, 7, and 10.

### 4. Selecting Entire Columns

You can select an entire Column like we have seen before to select the entire Row.

• This is just like selecting the entire Row. Firstly, Left-click on the number of Columns you want to select. Here I have selected the entire Column B.

• As like Rows, secondly, you can just drag your mouse and select adjacent Columns. Here, I have selected Columns B, C and D.

Additionally, you can select non-adjacent Columns also.

• Just hold the CTRL key on your keyboard and click on the number of Columns. Here I have selected Columns B, D, and E.

Eventually, if you want, you can select specific Columns and Rows together.

• Hold the CTRL key on your keyboard and click on the number of Rows and Columns. Here I have selected Columns B and D with Rows 5 and 7.

### 5. Using CTRL Key to Select Multiple Cells

By using the CTRL key you can select both adjacent and non-adjacent cells.

• Firstly, hold the CTRL key on your keyboard.
Secondly, click on the cells you want to select. Look at the image below. Here we have selected B5, C8, D6, E9

### 6. Select Multiple Cells Not Next to Each Other Utilizing Name Box

Eventually, you can select multiple cells by using the Name Box of the Excel Sheet.
Name Box is the box located on the topmost left side of the Excel Sheet, right in front of the Formula Bar like the picture below.

• Firstly, write the references of the cells you want to select in the Name Box. Differentiate them using commas(,). Eventually, the cells will be selected automatically. You can select both adjacent and non-adjacent cells in this way. Here, we have selected B7, C5, A7, D4, and E9.

• Secondly, click ENTERÂ to get the output.

### 7. Selecting Whole Worksheet

Finally, you can select the entire worksheet. Left-click on the small triangle in the topmost left corner of the worksheet.

And you will find the whole worksheet selected like this.

## Conclusion

Thatâ€™s all about todayâ€™s session. And these are the ways to select multiple cellsÂ in Excel. We strongly believe this article would be highly beneficial for you. Donâ€™t forget to share your thoughts and queries in the comments section and explore our website ExcelDemy, a one-stop Excel solution provider.

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rifat Hassan

Rifat Hassan, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, has worked with the ExcelDemy project for almost 2 years. Within these 2 years, he has written over 250 articles. He has also conducted a few Boot Camp sessions on effective coding, especially Visual Basic for Applications (VBA). Currently, he is working as a Software Developer to develop and deploy additional add-ins to enhance the customers with a more sophisticated experience with Microsoft Office Suits,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF