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 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:
Excel Shortcut: Create Table Read Post »
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:
Excel Shortcut: Activate Filter Read Post »
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:
Excel Shortcut: Toggle Auto filter Read Post »
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
Excel Shortcut: Insert a Chart in a New Sheet Read Post »
About This Shortcut Insert embedded chart – It makes an embedded chart from the data in the current range. Keybord shortcut key: Window: Alt + F1 Mac: Fn + Alt + F1 Note: The shortcut key will work with function key [Fn] if you are using laptop like Dell, or other companies laptop etc. Example:
Excel Shortcut: Insert Embedded Chart Read Post »
About This Shortcut Find the next match (after initial Find) – If you have the Find and Replace Window open and enter some criteria (values, formatting, etc.), Shift+F4 will utilize those criteria to locate the next cell that meets those requirements. Keybord shortcut key: Window: Shift+F4 Mac: cmd+G Example:
Excel Shortcut: Find Next Match Read Post »
About This Shortcut Find the previous match (after initial Find) – Ctrl+Shift+F4 reverses the Find to get the preceding cell. This way, you don’t have to repeatedly return to the Find Window to get to each matched cell. Keybord shortcut key: Window: Ctrl+Shift+F4 Mac: cmd+Shift+G Example:
Excel Shortcut: Find Previous Match Read Post »
About This Shortcut Display find and replace with Replace tab selected – Ctrl + H brings up the search and replace Window, where you can look for specific text and change it to something else. Keybord shortcut key: Window: Ctrl + H Mac: Ctrl+H Example:
Excel Shortcut: Find and Replace with Replace Selected Read Post »
About This Shortcut Display find and replace with Find tab selected – Ctrl + F is a keyboard shortcut that is useful to open a find box and look for a specific character, word, or phrase in a document or web page. Keybord shortcut key: Window: Ctrl + F Mac: cmd+F Example:
Excel Shortcut: Find and Replace Read Post »
About This Shortcut Display the Paste Special dialogue box – In Microsoft Office, pressing Ctrl + Alt + V activates the Paste Special dialogue box. A dialogue box appears from which you can select the method by which the clipboard’s contents will be pasted. Formats that are available for selection include plain text as well
Excel Shortcut: Paste Special Read Post »