A popular feature in Excel is the ability to double click an Excel cell and it will take you to the first link in the formula i.e. where did the cell get its information from. This will show you how to switch this feature on (or back on if it has stopped working)
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Change the invert if negative colour in Excel charts Aug 23, 2020
How to change the 'invert if negative' colour in Excel to a colour of your choosing and not the white fill with black border default.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."