If we have a worksheet with a lot of formulas, it would sometimes be nice to see them. This can be done without clicking all the individual cells.
Below we have some random numbers and some formulas in column D.
To view all the underlying formulas, go to the “FORMULAS” tab. There click the “Show Formulas” button.
The final result will look like below:
Excel tutorials 
Leave a comment