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.
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.
Now that the range has been selected, all of the cells within it have been selected.
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.
- 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.
Read More: 14 Examples to Select Cells with Keyboard Shortcut in Excel
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.
- 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.
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.
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.
- Then we can now select multiple rows by holding Shift and Arrow Keys together.
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.
- If we do that in column B or C, both columns will be chosen, as we have merged cells B3 and C3.
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.
- Then we will be able to select numerous columns by holding Shift and Arrow Keys together.
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.
- Then we press Ctrl and A All cells in the excel are chosen.
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.
- Second, we click Enter to get the output.
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.
- 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.
- 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.
📄
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
- 3 Ways to Divide a Group of Cells by a Number in Excel
- 7 Ways to Check If Multiple Cells Are Equal in Excel
- 3 Ways to Clear Contents Without Deleting Formulas in Excel
- 7 Ways to Assign Value If a Cell Contains Word in Excel