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. […]