To select all contiguous cells around the active cell, what keystroke shortcut should you use?
Question
To select all contiguous cells around the active cell, what keystroke shortcut should you use?
Solution
To select all contiguous cells around the active cell in Excel, you should use the keystroke shortcut Ctrl+Shift+*. Here are the steps:
- Click on the active cell from which you want to select all contiguous cells.
- Hold down the Ctrl key on your keyboard.
- While still holding down the Ctrl key, press and hold the Shift key.
- With both the Ctrl and Shift keys held down, press the * key.
This will select all cells that are directly connected to the active cell you started with.
Similar Questions
What is the keyboard shortcut to select non-adjacent cells?
To quickly move the active cell down a column of contiguously occupied cells, you can press Ctrl with the down arrow, or take what mouse action?
Which key do you hold down when selecting cells that are in different areas of a worksheet?
If the active cell is in a Table, how do you quickly highlight the entire table?
To activate the previous cell in a pre-selected range, press The Alt key The Tab key The Enter key None of the above
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.