About This Shortcut Open Modify Cell Style dialogue box – The shortcut key brings up the Excel dialogue box where you can…
Insights
Excel Shortcut: Open Modify Cell Style Dialogue Box
Practical notes on Excel, analytics, and building systems your team can run.
Excel Shortcut: Hide or Show Objects
About This Shortcut Hide or show objects – It can hide objects, show objects, or show placeholders for things. Keybord shortcut key:…
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…
Excel Shortcut: Duplicate Object
About This Shortcut Duplicate object, formula, text – When you press Ctrl + D, the contents of the cell one column up…
Excel 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…
Excel 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,…
Excel Shortcut: Open Thesaurus
About This Shortcut Open Thesaurus – Shift + F7″ brings up the “Thesaurus” task pane in your worksheet. Keybord shortcut key: Window:…
Excel Shortcut: Run Spellcheck
About This Shortcut Run Spellcheck – F7 brings up a dialogue window where you can check the spelling of the currently selected…
Excel 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…
Excel Shortcut: Select Table
About This Shortcut Select table (when active cell is in table) – Ctrl + A in Excel selects all cells. Nothing will…