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 Snap to the grid (whilst dragging) – It will let you move data while holding the mouse key and switching between Excel Worksheets. Keybord shortcut key: Window: Alt Mac: Alt Example:
Excel Shortcut: Snap to Grid Read Post »
About This Shortcut Duplicate object, formula, text – When you press Ctrl + D, the contents of the cell one column up will be copied into the one you’re editing. It doesn’t work on rows. Keybord shortcut key: Window: Ctrl + D Mac: cmd + D Example:
Excel Shortcut: Duplicate Object Read Post »
About This Shortcut Open VBA Editor – If you press Alt+F11, you’ll be sent to the Visual Basic for Applications Editor, where you can write a macro using that language (VBA). Keybord shortcut key: Window: Alt + F11 Mac: Fn + Alt + F11 Note: The shortcut key will work with function key [Fn] if
Excel Shortcut: Open VBA Editor Read Post »
About This Shortcut Open Macro dialogue box – When you press Alt+F8, the Macro dialogue box appears, where you can create, run, amend, or remove a macro. Keybord shortcut key: Window: Alt + F8 Mac: Fn + Alt + F8 Note: The shortcut key will work with function key [Fn] if you are using laptop
Excel Shortcut: Open Macro Dialogue Box Read Post »
About This Shortcut Open Thesaurus – Shift + F7″ brings up the “Thesaurus” task pane in your worksheet. Keybord shortcut key: Window: Shift + F7 Mac: Fn + Shift + F7 Example:
Excel Shortcut: Open Thesaurus Read Post »
About This Shortcut Run Spellcheck – F7 brings up a dialogue window where you can check the spelling of the currently selected range of cells or the entire active worksheet. Keybord shortcut key: Window: F7 Mac: Fn + F7 Example:
Excel Shortcut: Run Spellcheck Read Post »
About This Shortcut Clear slicer filter – It’s a quick way to remove the slicer filter from the Worksheet in Excel. Keybord shortcut key: Window: Alt + A + C Mac: Alt + C Example:
Excel Shortcut: Clear Slicer Filter Read Post »
About This Shortcut Select table (when active cell is in table) – Ctrl + A in Excel selects all cells. Nothing will happen when you press Ctrl + A while modifying a cell’s contents. Keybord shortcut key: Window: Ctrl + A Mac: cmd + A Example:
Excel Shortcut: Select Table Read Post »
About This Shortcut Select table column – Ctrl + Space is a keyboard shortcut that helps Excel select a whole column. Keybord shortcut key: Window: Ctrl + Space Mac: Ctrl + Space Example:
Excel Shortcut: Select Table Column Read Post »
About This Shortcut Select table row – It is a keyboard shortcut to select a complete row. Keybord shortcut key: Window: Shift + Space Mac: Shift + Space Example:
Excel Shortcut: Select Table Row Read Post »