Excel Hack

How to select cells in Excel shortcut

Learn how to use shortcut keys to select cells in Excel. In Excel, you can also use shortcut keys to select a wide range or select only visible cells. We will also show you how the shortcut keys in Excel can be used to select all cells from the current cell to A1, or only the active cell when multiple cells are selected. We will also show you how to select cells in which Notes are entered all at once.

Shortcut keys for selecting cells

Select all cells from the current cell to A1

Windows
Ctrl + Shift + Home

Mac
With numeric keypad: control + shift + home
Without numeric keypad: control + shift + fn + (Left Arrow key)

Select only the active cell when multiple cells are selected

Windows
Shift + Backspace

Mac
shift + backspace

Select all cells with Notes

Windows
Ctrl + Shift + O

Mac
control + shift + O

Select all cells from the current cell to A1

Select all cells from the current cell to A1 using shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell

Select any cell. Select from this cell to cell A1 with the shortcut key.

Selected up to cell A1

Selected up to cell A1

Press Ctrl + Shift + Home selects everything from the current cell to cell A1.

Select only the active cell when multiple cells are selected

Multiple cells are selected

Multiple cells are selected.

Press Shift + Backspace

Press Shift + Backspace selects only the active cell in a multiple selection.

Select all cells with Notes

Currently in Microsoft 365 (formerly Office 365), the ability to add text to a cell is called a note, and the ability to enter text in a threaded format is called a comment. In this case, we will select a cell in which Notes, a function that allows text to be added, is entered.

Cell in which the comment is entered

Column A contains several cells in which Notes are entered.

Select them all at once using the shortcut keys.

Press Ctrl + Shift + O

Press Ctrl + Shift + O selects only the cells with Notes.

Articles related to Cell & Select & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments