Author name: Umesh Manral

About This Shortcut Select Entire row – Shift + spacebar selects the entire row containing the active cell. Keybord Shortcut key Window: Shift + Space Mac: Shift + Space Example:

About This Shortcut Select Entire Column – Ctrl + Space is a shortcut key that is useful to select a whole column in Excel. Keybord Shortcut key Window: Ctrl + Space Mac: Ctrl + Space Example:

About This Shortcut Expand Selection – The shortcut key lets you extend the selection. Keybord Shortcut key Window: Shift + Click Mac: Shift + Click Example:

About This Shortcut Add Non-Adjacent Cells to Selection – Ctrl + click selects non-adjacent cells and cell ranges. Keybord Shortcut key Window: Ctrl + Click Mac: Cmd + Click Example:

About This Shortcut Move Right Between Non-Adjacent Selections – The shortcut command navigates right between non-adjacent selections. Keybord Shortcut key Window: Ctrl + Alt + → Mac: Ctrl + Alt + → Example:

About This Shortcut Move Left Between Non-Adjacent Selections – The shortcut command navigates left between non-adjacent selections. Keybord Shortcut key Window: Ctrl + Alt + ← Mac: Ctrl + Alt + ← Example:

About This Shortcut Toggle ‘Add to Selection’ mode – Shift+F8 extends the selection to non-adjacent cells. Keybord Shortcut key Window: Shift + F8 Mac: Fn + Shift + F8 Example:

About This Shortcut Exit ‘Add to Selection’ Mode – The shortcut key cancels the entry in the cell. It cancels ‘Add to Selection’ mode. Keybord Shortcut key Window: Esc Mac: Esc Example:

About This Shortcut Move Active Cell Down in Selection – Wrap to Next Column – “Enter” moves the active cell one cell in a direction based on your settings. This is down by default. Keybord Shortcut key Window: Enter Mac: Return Example:

About This Shortcut Move Active Cell up in Selection – wrap to previous column – Use the enter key to move the active cell down, and to move it up, use shift + enter. Keybord Shortcut key Window: Shift + Enter Mac: Shift + Return Example: