Knowee
Questions
Features
Study Tools

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?

🧐 Not the exact question you are looking for?Go ask a question

Solution

To select all contiguous cells around the active cell in Excel, you should use the keystroke shortcut Ctrl+Shift+*. Here are the steps:

  1. Click on the active cell from which you want to select all contiguous cells.
  2. Hold down the Ctrl key on your keyboard.
  3. While still holding down the Ctrl key, press and hold the Shift key.
  4. 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.

This problem has been solved

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

1/3

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.