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 Extend Selection Down – With the shortcut key, the current selection moves down by one line. Keybord Shortcut key Window: Shift + ↓ Mac: Shift + ↓ Example:
Excel Shortcut: Extend Selection Down Read Post »
About This Shortcut Extend Selection up – It adds one more line to the current selection. Keybord Shortcut key Window: Shift + ↑ Mac: Shift + ↑ Example:
Excel Shortcut: Extend Selection up Read Post »
About This Shortcut Extend Selection Left – When you are editing the data or text in a cell, this shortcut lets you choose the character to the left of the one you are currently editing. Keybord Shortcut key Window: Shift + ← Mac: Shift + ← Example:
Excel Shortcut: Extend Selection Left Read Post »
About This Shortcut Extend Selection Right – This shortcut lets you select the next character to the right when you are editing the data or text in a cell. Keybord Shortcut key Window: Shift + → Mac: Shift + → Example:
Excel Shortcut: Extend Selection Right Read Post »
About This Shortcut Select current region if worksheet contains data. Press again to select current region and summary rows. Press again to select entire worksheet- In Excel, Ctrl + A selects all cells. Keybord Shortcut key Window: Ctrl + A Mac: Cmd + A Example:
Excel Shortcut: Press Again to Select Entire Worksheet Read Post »
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:
Excel Shortcut: Select Entire row Read Post »
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:
Excel Shortcut: Select Entire Column Read Post »
About This Shortcut Expand Selection – The shortcut key lets you extend the selection. Keybord Shortcut key Window: Shift + Click Mac: Shift + Click Example:
Excel Shortcut: Expand Selection Read Post »
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:
Excel Shortcut: Add Non-Adjacent Cells to Selection Read Post »
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:
Excel Shortcut: Move Right Between Non-Adjacent Selections Read Post »