This tip was added after watching several colleagues struggle to keep tabs on what cells were being referenced in some of their formulas. F2, or double click (show formulas and references) It can be especially good if you’re analysing and comparing formulas next to each other.ģ. The one next to the number 1 look (If you’re a mac owner then you’re probably beyond all help, sorry).Īnyway this shortcut can be used to toggle showing the formulas on the page. That is, the tilde key was traditionally always there (~) but now probably has something like the following (¬) instead. If you’re not sure what the tilde key is, it’s the one at the top left of your keyboard next to the number 1. Ctrl + Tilde Key (shows formulas in cells) If you find yourself doing this kind of thing regularly then it’s definitely worth remembering.Ģ. Simply use this shortcut at the bottom of a big list of numbers and it’ll do an immediate sum of them for you. Well, apparently quite a lot, as I’ve used this shortcut all the time since, every day. “How much time can this possibly save me?” scoffed I. I first read this tip elsewhere about 3 months ago and scoffed at it openly. It’s packed with formulas and macros aimed at keyword marketers but useful for anyone who wants to sharpen up their skills and knowledge.Īs of January 2021, we’ve refreshed this list with an additional 10 shortcuts that will knock your socks off with their sheer usefulness! If you’re not already familiar with them, you may want to check out my previous posts: 5 Great Time-Saving Excel Tips and 5 Great Uses of the IF Formula.įor the slightly more advanced users, there’s also our latest Excel Cheat Sheet. Hello and welcome to another Excel blog post – third in this series, where I attempt to explain and demonstrate some great Excel shortcuts for you to use in your everyday working lives (or just for fun).

Excel shortcut keys filter