How to Select Multiple Cells in Excel (7 Quick Ways)

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, I will be going to show you 7 easy ways to select multiple cells with proper illustrations.


Download File


7 Quick Ways to Select Multiple Cells in Excel


1. Select Multiple Cells in Excel by Dragging the Mouse

This is the easiest way to do it. First left click on the first cell of the database you want to select. Here I have left-clicked on cell A3

Select a Cell in Excel

Then drag your mouse over all the cells you want to select. After dragging over all the cells, leave the mouse.

You will find all the cells have been highlighted in blue. This means they have been selected.

Here I have selected all the cells from A3 to D10.

Select a Range of cells in Excel

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

Read More: Selecting Non-Adjacent or Non-Contiguous Cells in Excel (5 Simple Methods)


2. Select Multiple Cells in Excel by Keyboard Shortcut


Method 1: Selecting Cells One by One

First left click on the first cell of the database you want to select. Then press Shift + Down Arrow to select the cells one by one column-wise. Here I have selected all the cells from A3 to A8 column-wise. 

Select Cells by Shift and Down Arrow in Excel to Select Multiple Cells in Excel

Then press Shift + End to select the cells one by one row-wise. Here I have selected all the cells from column A to C row-wise.


Method 2: Selecting Cells Together

First left click on the first cell of the database you want to select.

Then press Ctrl + Shift + Down Arrow.

It will select all the cells column-wise until there is a blank cell. Here all the cells from A3 to A10 have been selected.

Select Cells by Control, Shift and Down Arrow in Excel 

Then press Ctrl + Shift + End. It will select all the cells row-wise until there is a blank cell in any row. Here all the cells from columns A to D have been selected.

Select Cells by Control, Shift and End to Select Multiple Cells in Excel

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


3. Select Entire Rows to Select Multiple Cells in Excel

First, 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 number 7.

Selecting Entire Row in Excel

Then you can just drag your mouse and select adjacent rows. I have selected rows 5, 6, and 7 here.

Or you can select non-adjacent rows also. Just hold Ctrl on your keyboard.

Then click on the number of rows.

Here I have selected rows 5, 7, and 10. 

Select Non Adjacent Entire Rows to Select Multiple Cells in Excel


4. Select Entire Columns to Select Multiple Cells in Excel

This is just like selecting the entire row. Left-click on the number of columns you want to select.

Here I have selected the entire column A.

Select Entire Column to Select Multiple Cells in Excel

As like rows, you can just drag your mouse and select adjacent columns. Here, I have selected columns A, B, and C here.

And of course, you can select non-adjacent columns also. Just hold Ctrl on your keyboard and click on the number of columns. Here I have selected columns A, C, and D.

Select Non-Adjacent Entire Columns to Select Multiple Cells in Excel

Note: If you want, you can select entire columns and rows together. Hold Ctrl on your keyboard and click on the number of rows and columns. Here I have selected columns A, C, and D with rows 3 and 5.


5. Select Multiple Cells in Excel by Holding CTRL

You can select both adjacent and non-adjacent cells in this way.

First, hold Ctrl on your keyboard.

Then click on the cells you want to select. Look at the image below.

Select Multiple Cells by Pressing Ctrl in Excel


6. Select Multiple Cells in Excel by Using Name Box

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. See the figure below.

Select Multiple Cells by using Name Box in Excel

First, write the references of the cells you want to select in the Name Box. Differentiate them using commas(,). 

Then click Enter. The cells will be selected automatically. You can select both adjacent and non-adjacent cells in this way.

Here I have selected B2, A5, A7, D8, and D6.

Multiple Cells Selected by Using Name Box in Excel


7. Select the Whole Worksheet to Select Multiple Cells in Excel

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

Select the Whole Worksheet in Excel

And you will find the whole worksheet selected like this.

Also, you can select the whole worksheet by pressing Ctrl + A on your keyboard.


Conclusion

By following the above methods, you can easily select multiple cells in an Excel Worksheet. This is really fun, isn’t it? Do you know any other way? Let us know in the comment section.


Further Readings

Tags:

Rifat Hassan

Hello! Welcome to my profile. Here I will be posting articles related to Microsoft Excel. I am a passionate Electrical Engineer holding a Bachelor’s degree in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology. Besides academic studies, I always love to keep pace with the revolution in technology that the world is rushing towards day by day. I am diligent, career-oriented, and ready to cherish knowledge throughout my life.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo