Transcripts for the above video clip:

ALL FORMULA SHOW

In this segment you’ll learn how to show the underlying formula of all cells quickly and easily.

In this example we have a typical spreadsheet with a number of formulae’s, so as you go across you’ll see there are formulae’s in various cells.
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.