A @TheQuickerWay

If you regularly update the same status, category or value across multiple cells in Excel, stop copying and pasting it one by one. 👇 Select all the cells → type the value once → press Ctrl + Enter. Small shortcut. Big time saver. ⏱️ #Excel #ExcelTips

Get a sum total in seconds using ALT + = No more typing the sum formula into each total cell.

Stop dragging formulas down in Excel 👇 Select the formula + the cells underneath and press Ctrl + D. Excel fills the formula down instantly and adjusts the references automatically. #Excel #ExcelTips

Need to insert today’s date into your spreadsheet? Click on the cell you’d like to insert the date into, press CTRL + ;

Don’t delete duplicates one by one. Alt → A → M opens Remove Duplicates instantly. Choose which columns to check → hit OK → done.

I wasted so much time clicking these manually! CTRL + SHIFT + L instantly adds filters to your data in Excel. Press it again and they disappear. ✨

Create a table in seconds. Click anywhere in your data and press CTRL + T. Instantly get filters, automatic formatting and a table that expands as you add new data.

Still scrolling through thousands of rows in Excel? CTRL + ↓ takes you straight to the bottom of your data. CTRL + ↑ takes you straight back to the top.

Probably the best Excel shortcut I’ve found yet 🪄 CTRL + E = Flash Fill Give Excel one example of what you want, press CTRL + E, and it recognises the pattern and fills the rest. Perfect for extracting postcodes, names, addresses and more.