Microsoft Excel stores and analyses data worldwide. Excel is still the go-to data analytics tool despite newer tools. Its many features simplify data organization. Moreover, Excel shortcuts speed up data manipulation. Excel uses shortcuts, and Excel shortcut keys speed up our work and boost productivity. These shortcut keys work with most Windows versions of Excel.
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:
Excel Shortcut: Move Left Between Non-Adjacent Selections Read Post »
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:
Excel Shortcut: Toggle ‘Add to Selection’ Mode Read Post »
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:
Excel Shortcut: Exit ‘Add to Selection’ Mode Read Post »
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:
Excel Shortcut: Move Active Cell Down in Selection Read Post »
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:
Excel Shortcut: Move Active Cell up in Selection Read Post »
About This Shortcut Move Active Cell Right in a Selection – wrap to next row- It moves the active cell to the right in the range. Keybord Shortcut key Window: Tab Mac: Tab Example:
Excel Shortcut: Move Active Cell Right in a Selection Read Post »
About This Shortcut Move Active Cell Left in a Selection – wrap to previous row- Shift + tab moves the active cell left. Keybord Shortcut key Window: Shift + Tab Mac: Shift + Tab Example:
Excel Shortcut: Move Active Cell Left in a Selection Read Post »
About This Shortcut Select Active Cell (When Multiple Cells Already Selected) – The keyboard shortcut will select all cells in the row of the active cell that contain data, from the active cell to the last cell in the row. Keybord Shortcut key Window: Shift + Backspace Mac: Shift + Delete
Excel Shortcut: Select Active Cell Read Post »
About This Shortcut Show the Active Cell on Worksheet – The shortcut key displays the active cell in Excel. Keybord Shortcut key Window: Ctrl + Backspace Mac: Ctrl + Delete Example:
Excel Shortcut: Show the Active Cell on Worksheet Read Post »
About This Shortcut Move Active Cell Clockwise to Corners of Selection – It moves the active cell clockwise to the next corner of the range. This doesn’t move to corners in ranges that aren’t all the same length. Keybord Shortcut key Window: Ctrl + . Mac: Ctrl + . Example:
Excel Shortcut: Move Active Cell Clockwise to Corners of Selection Read Post »