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 One Word Left – Ctrl + Left Arrow is useful for moving the cursor to the left one word at a time. Keybord Shortcut key Window: Ctrl + ← Mac: Ctrl + ← Example:
Excel Shortcut: Move One Word Left Read Post »
About This Shortcut Move One Word Right – Ctrl + Right Arrow is useful for moving the cursor one word to the right at a time. Keybord Shortcut key Window: Ctrl + → Mac: Ctrl + → Example:
Excel Shortcut: Move One Word Right Read Post »
About This Shortcut Select One Character Left – It chooses the character to the left of the cursor. Keybord Shortcut key Window: Shift + ← Mac: Shift + ← Example:
Excel Shortcut: Select One Character Left Read Post »
About This Shortcut Select One Character Right – It chooses the character to the right of the cursor. Keybord Shortcut key Window: Shift + → Mac: Shift + → Example:
Excel Shortcut: Select One Character Right Read Post »
About This Shortcut Cancel Editing – If you have started editing a cell and want to stop, you can click the Escape key. Keybord Shortcut key Window: Esc Example:
Excel Shortcut: Cancel Editing Read Post »
About This Shortcut Delete Comment – Shift + F10 or M can be used to delete comments from an Excel spreadsheet. Keybord Shortcut key Window: Shift + F10, M Example:
Excel Shortcut: Delete Comment Read Post »
About This Shortcut Insert or Edit Comment – It either puts a comment in a cell or adds one. Keybord Shortcut key Window: Shift + F2 Example:
Excel Shortcut: Insert or Edit Comment Read Post »
About This Shortcut Edit the Active Cell – F2 puts the cursor at the end of the cell’s contents and starts “Edit mode.” Keybord Shortcut key Window: F2 Mac: Ctrl + U Example:
Excel Shortcut: Edit the Active Cell Read Post »
About This Shortcut Select Visible Cells Only – ALT+; chooses the visible cells in the current selection. Keybord Shortcut key Window: Alt +( ; ) Mac: Cmd + Shift + Z Example:
Excel Shortcut: Select Visible Cells Only Read Post »
About This Shortcut Select All Dependents – CTRL+SHIFT+} lets you pick cells with formulas that either directly or indirectly refer to the active cell. Keybord Shortcut key Window: Ctrl + Shift + } Mac: Ctrl + Shift + } Example:
Excel Shortcut: Select all Dependents Read Post »