Excel Shortcut: Snap to Grid
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:…
Read MoreCategory: Excel Shortcuts
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.
Excel Shortcut: Duplicate Object
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.…
Read MoreExcel Shortcut: Open VBA Editor
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…
Read MoreExcel Shortcut: Open Macro Dialogue Box
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:…
Read MoreExcel Shortcut: Open Thesaurus
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 +…
Read MoreExcel Shortcut: Run Spellcheck
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.…
Read MoreExcel Shortcut: Clear Slicer Filter
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…
Read MoreExcel Shortcut: Select Table
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…
Read MoreExcel Shortcut: Select Table Column
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…
Read MoreExcel Shortcut: Select Table Row
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:
Read More