The Institute of Chartered Accountants in England and Wales (ICAEW) has just held a competition within its Excel community to come up with the best Excel tip ever.

The winning entry suggested using GoTo (F5) and ‘Special’ to select blanks in order to paste in missing formulae. Now we are not saying this trick isn’t useful, but it may indeed promote placing inconsistent formulae in columns and / or rows – something we would not encourage at all. Furthermore, best tip ever!? We humbly suggest not.

Have you got a better Excel tip? There must be great time-savers out there just waiting to be discovered. Drop us your thoughts at contact@sumproduct.com and we will publish the best tips in May’s newsletter. Secure your bragging rights here!!