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 MoreBlog
Tips, tricks, and tutorials to help you master Excel and Google Sheets. Learn from our experts and take your spreadsheet skills to the next level.
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