How to show all the underlying formula in an Excel spreadsheet.
In this example we have a typical spreadsheet with a number of formula’s, so as you go across you’ll see there are formula’s in various cells. We want to show all formula in excel.
What we would like to do, is see all these cells opened up showing their formulae’s, there’ a nice quick and easy way to do this in excel.
By pushing the control key and this symbol, you get your spreadsheet to look like this, where all the cells are broken down into their underlying formula, so as you go across you’ll see we have all the underlying formula and you can switch this on and off by pushing the control key and this symbol.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd