10 Ways to Select Multiple Cells Without Mouse in Excel

If you are looking for how to select multiple cells without mouse in Excel, then you’ve come to the right place. There are several ways to select different cells in Excel without mouse, and in this article, we’ll try to talk about the 10 quickest ways to select multiple cells without a mouse in Excel.


📁 Download Excel File

Download this practice book.


Learn to Select Multiple Cells Without Mouse in Excel with These 10 Quick Methods

There are several ways to select multiple cells without mouse in Excel. Let’s check them out.

Dataset

Method 1

1. Holding Shift Key and F8 Together

When you wish to choose a range of cells that goes beyond the visible part of the screen, clicking and dragging isn’t always the most practical option. Using the Shift key and F8  together, we will be able to select a range of cells, similar to how you would select a group of files in a file or folder.

⬇️⬇️ STEPS ⬇️⬇️

  • We start by moving our arrow key to select first cell of the desired selection. Let it be Robert. Then we press Shift and F8 keys together. Because of this, you will notice in Excel that something called Add or Remove Selection is under the sheet names.

  • Then, we push Shift+F8 two times before we choose more cells. Like, I have chosen three more of these cells (Cell B6, B8, C10 & C12). In the end, we will end up with the following.

Final result of how to select multiple cells in excel without mouse

Now that the range has been selected, all of the cells within it have been selected.

Method 2

2. Using Keyboard Shortcut One by One

By using a keyboard shortcut, we may choose as many cells as we want, both column- and row-wise.

To select cells one after the other one, use a keyboard shortcut.

⬇️⬇️ STEPS ⬇️⬇️

  • First, choose a cell. We’ve chosen cell B8 in this case.
  • Second, use Shift + Down Arrow(↓) to select the cells one after the other one, column by column. We’ve chosen all of the cells from B8 to B10 in this column.

Using Keyboard Shortcut One by One

  • Finally, press SHIFT + END to select the cell’s row by row. We have selected all of the cells from Columns B to C, row by row.

how to select multiple cells in excel without mouse Using Keyboard Shortcut One by One

📕 Read More: 14 Examples to Select Cells with Keyboard Shortcut in Excel

Method 3

3. Using Keyboard Shortcut Together

You can also select multiple cells at once by using the keyboard shortcut.

⬇️⬇️ STEPS ⬇️⬇️

  • To begin, we select first cell in the database that we wisht to select. Cell B7 has been chosen in this case.
  • Second, we hold down CTRL+SHIFT+Down Arrow (). It will select all the cells in a column until there is a blank cell. We have chosen all of the cells from B5 to B11.

hold down CTRL + SHIFT + Down Arrow (↓)

  • Finally, we hit CTRL+SHIFT+END. It will select all the cells in each row until there are no blank cells in any row. We have chosen Columns B through D.

Final resullt

Method 4

4. Selecting Entire Row

You may need to select a whole row of cells at once, for example, to format a header row. This is easy to do.

⬇️⬇️ STEPS ⬇️⬇️

  • First, we select any one cell of the dataset we want to choose by holding Shift and Space. Here, I’ve chosen Row 11.

how to select multiple cells in excel without mouse Selecting Entire Row

Method 5

5. Designating Multiple Rows

Sometimes, you may hope to select more than one whole row of cells. Similar to selecting individual cells, you use the Shift key if the rows are connected and the Ctrl key if the rows are not connected.

  • First, we select the Row number we want to choose by holding Shift and Space This row’s cells will all be chosen. Here, I’ve chosen Row 11.

Selecting the first row

  • Then we can now select multiple rows by holding Shift and Arrow Keys together.

how to select multiple cells in excel without mouse Selecting Multiple Rows

Method 6

6. Selecting Entire Column

You might also have to select a whole column of cells sometimes. This is also easy to do. In fact, it works exactly the same as when you select rows.

⬇️⬇️ STEPS ⬇️⬇️

  • First, we select cell D9 we want to choose by holding Ctrl and Space together. We have chosen this column D.

Selecting first column

  • If we do that in column B or C, both columns will be chosen, as we have merged cells B3 and C3.

Selecting the merged cell

Method 7

7. Choosing Multiple Columns

Selecting multiple columns is also the same as selecting multiple rows. Similar to selecting individual cells, you use the Shift key if the columns are connected and the Ctrl key if the columns are not connected.

⬇️⬇️ STEPS ⬇️⬇️

  • First, we select the column number we want to choose by holding Ctrl and Space This column’s cells will all be chosen. Here, I’ve chosen Column D.

Selecting the first cell

  • Then we will be able to select numerous columns by holding Shift and Arrow Keys together.

how to select multiple cells in excel without mouse Choosing Multiple Columns

Method 8

8. Selecting All Cells

We will be able to select all the cells in Excel in this method.

⬇️⬇️ STEPS ⬇️⬇️

  • First, we select a cell in the dataset.

Selecting any cell

  • Then we press Ctrl and A All cells in the excel are chosen.

how to select multiple cells in excel without mouse by pressing Ctrl and A together

Method 9

9. Selecting Multiple Cells That Are Not Next to Each Other by Using Name Box

You can use the Name Box on the Excel Sheet to select multiple cells.

The Name Box is the box at the top left of the Excel Sheet, next to the Formula Bar, as shown in the image below.

⬇️⬇️ STEPS ⬇️⬇️

  • First, we write the cell references you can select in the Name Box. We use commas to set them apart (,). In the end, the cells will be selected on their own. We can choose cells that are next to each other or far away from each other this way. We have selected cells B8, B9, C8, and C6 in this case.

Using NameBox

  • Second, we click Enter to get the output.

how to select multiple cells in excel without mouse Using the Name box

Method 10

10. Implementing VBA

Now we will use VBA to compare duplicate rows. Before talking about the method, first, we have enabled Developer Tab on our Ribbons. You can follow the link to see the process of enabling the Developer Tab by clicking on it here.  Let’s follow the steps below.

⬇️⬇️ STEPS ⬇️⬇️

  • Let’s press ALT + F11 to bring up the VBA Window. You can also do this by going to the Developer tab and clicking on Visual Basic.

Opening Developer Tab

  • Then we choose Module from Insert from the menu. This will bring up the window for the VBA Module. Here is where we will put our code.

Choosing Module from Insert

  • Now we type the code below:
Sub multipleCellSelection()

Dim firstSelection As Long
Dim finalSelection As Long
Dim allSelectedCell As Range
Set Active = ActiveCell
If ActiveCell.CurrentRegion.Count = 1 Then Exit Sub
On Error Resume Next
finalSelection = ActiveCell.CurrentRegion.EntireColumn.Find( _
What:="*", _
After:=ActiveCell.CurrentRegion.EntireColumn.Cells(1, 1), _
LookAt:=xlPart, _
LookIn:=xlFormulas, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Row
On Error GoTo 0
firstSelection = ActiveCell.CurrentRegion.Row
If firstSelection = 0 Or finalSelection = 0 Then Exit Sub
If Intersect(ActiveCell.CurrentRegion, ActiveCell.EntireColumn).Cells(1, 1).Font.Bold = True Then
firstSelection = firstSelection + 1
End If
Range(Cells(firstSelection, ActiveCell.Column), Cells(finalSelection, ActiveCell.Column)).Select
If Not Intersect(allSelectedCell, Selection) Is Nothing Then
allSelectedCell.Activate
End If

End Sub
  • Now we save and run the code (press F5 to run).
  • Now we will see the result.

how to select multiple cells in excel without mouse Using VBA and the final result


📄  Important Notes

🖊️  In Excel, the ribbon is used to access various commands. You can change a lot of things in the options dialogue window, like the ribbon, formulas, proofing, saving, and so on. So the appearance of worksheets on your device could be different from ours.

🖊️  A practice workbook is given so that you can practice yourself.

🖊️  All these exercises and tutorials are done on Microsoft Office 365. Some functions may be unavailable in previous versions.

🖊️  At the side of each Excel worksheet file, there is space where they can practice.


📝  Takeaways from This Article

📌  Readers will be able to select multiple cells without the mouse in excel in various ways.

📌  They can do this by holding the Shift key and F8 together.

📌  They also can do this by using keyboard shortcuts.

📌  Viewers can select all the cells in a row without the mouse.

📌  Viewers can select cells in multiple rows without any mouse.

📌  The readers can select cells in a column in Excel without mouse.

📌  Readers can select all the cells in multiple rows without the help of a mouse.

📌  Also, the readers can also select cells by pressing Ctrl and A together.

📌  Besides, they can select multiple cells not next to each other by using Name Box.

📌  Finally readers can implement VBA for this purpose.


Conclusion

That concludes today’s session. These are the methods to Select Multiple Cells Without a Mouse in Excel. We are hopeful that this article will be extremely beneficial to you. Don’t forget to leave your thoughts and questions in the comments section and explore our website, ExcelDen.com, the best Excel solutions provider.


Related Articles

(Visited 66 times, 1 visits today)

Tags:

Tanzim

Tanzim

My name's Tanzim. My articles are meant to help you learn more about how Microsoft Excel works and how to use its different features. I enjoy gaming and hope that some of my knowledge will help me provide you with some interesting articles despite some tiresome technical terms.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo