Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Keyboard shortcuts are great, but there are also hidden Excel double click features and shortcuts available for mouse users. Which means everyone, because we all use the mouse, even those hardcore keyboard shortcut fans. Watch the Video Download the Quick Reference Cheat Sheet [FREE] Enter your email address below to download the sample workbook. Get …
The AutoSum shortcut, ALT+= (ALT and = at the same time), allows you to automatically sum rows and/or columns. How it works depends on what you have selected, and I'm going to look at several different examples here. AutoSum a Column AutoSum Into Cell Below Column Click into an empty cell below the column (it …
If you want to duplicate something you can copy (CTRL+C) and paste (CTRL+V). But there's a quicker way that only requires one shortcut: CTRL+D. Now you can work twice as fast 🙂 CTRL+D to Duplicate You can use CTRL+D to duplicate formulae, text, shapes, charts, smart art, pictures or pretty much anything you can select. …
