Excel Shortcut: Create Table
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,…
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: Activate Filter
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…
Read MoreExcel Shortcut: Toggle Auto filter
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…
Read MoreExcel Shortcut: Insert a Chart in a New Sheet
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:…
Read MoreExcel Shortcut: Insert Embedded Chart
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…
Read MoreExcel Shortcut: Find Next Match
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…
Read MoreExcel Shortcut: Find Previous Match
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…
Read MoreExcel Shortcut: Find and Replace with Replace Selected
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…
Read MoreExcel Shortcut: Find and Replace
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…
Read MoreExcel Shortcut: Paste Special
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…
Read More