How to show all the underlying formula in an Excel spreadsheet.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
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.