There may be several reasons why you need to reveal or show the formulas in cells in Excel. You need to check if the formulas are correct not just in one cell but all cells. You need to see if a formula refers to a certain cell or range. There is doubt in your mind whether some cells hold a formula at all. You need to show your calculations to your boss or college for verification. For whatever reason you may have, this is how to do that.
Here is an example spreadsheet. 
How to show formulas
From the Formula ribbon locate the [Show formula tool]. 
This reveals all the formulas on the spreadsheet. 
This only reveals the formulas on the sheet you are working on, unless you use the group sheet function, which will then show formulas in all the grouped sheets in the file.
Two spreadsheets that need to come together? Consolidation might be the answer.
