We’ll show you how to quickly choose a group of cells in Excel if you don’t know-how. A lot of people use a mouse to find cells in Excel. That’s not always the best thing to do. Many times, typing on the keyboard can be faster than typing on the screen.
Use the Shift key
When using the arrow keys to select cells, hold down the Shift key. Choose a column or row by pressing the arrow that goes in the direction you want to go. Excel shortcuts that you can use with the Shift key are shown below:
- Shift + ↑ : Selects a cell upward
- Shift + ↓ : Selects a cell downwards
- Shift + ← : Selects a cell to the left
- Shift + → : Selects a cell to the right
- Shift + Ctrl + ↑ : Selects all cells upward
- Shift + Ctrl + ↓ : Selects all cells downwards
- Shift + Page Up: Selects a block of rows upwards
- Shift + Page Up: Selects a block of rows downwards
- Shift + Ctrl + ← : Selects all the cells to the left
- Shift + Ctrl + → : Selects all the cells to the right
There are times when keyboard shortcuts are better than clicking on a column or row.
Ctrl + Spacebar: Selects the whole column.
Shift + Spacebar: Selects the whole row.
If you need to choose a lot of cells with one key combination, you can do that. To select a cell in a range, click on it and then press Ctrl + E on your keyboard.
You may have to choose cells that are not next to each other at times. The easiest way to do this is to hold down the Ctrl key while you move your mouse pointer and make a selection.
As you can see, shortcuts make this work easier to do.