Author name: Umesh Manral

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:

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:

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:

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:

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:

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:

About This Shortcut Create table – Excel’s Create Table dialogue box can be accessed by pressing Ctrl + T. But if you’re working in a cell, it toggles between absolute, relative, and mixed formula reference types. Keybord shortcut key: Window: Ctrl + T or Ctrl + L Mac: cmd + T Example:

About This Shortcut Activate filter – You can access the “Filter” option by pressing your keyboard’s ALT + down arrow. Keybord shortcut key: Window: Alt + Down Arrow Mac: Alt + Down Arrow Example:

About This Shortcut Toggle Auto filter – CTRL+SHIFT+L is an Excel keyboard shortcut for inserting a filter. You will need to use it after clicking on a column header Keybord shortcut key: Window: Ctrl + Shift + L  or Alt + A + T Mac: cmd + Alt + F Example:

About This Shortcut Insert a chart in a new sheet- It makes a chart on a new sheet based on the data in the dynamic range. Keybord shortcut key: Window: F11 Mac: Fn + F11 Note: The shortcut key will work with function key [Fn] if you are using laptop like Dell, or other companies