About This Shortcut Select table column – Ctrl + Space is a keyboard shortcut that helps Excel select a whole column. Keybord…
Insights
Excel Shortcut: Select Table Column
Practical notes on Excel, analytics, and building systems your team can run.
Excel 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…
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…
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…
Excel 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…
Excel 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…
Excel 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:…
Excel 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…
Excel 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,…
Excel 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,…