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.