How do i go between seeing a formula in a cell and seeing the value of that formula?

Dear Penny

Thank you for attending Excel courses. I hope you enjoyed the course and have started to put the new learnt features into practice.

It is a tedious task having to click on every single cell that contains a formula, Function or a Link and then look at the formula bar to see what it is.

The easiest way to hide or display the formulae, Functions or the link on the cells rather than the results is to use the shortcut key command CTRL + ` ( this key is situated just below the ESC key and above the Tab key)
If you cannot remember the shortcut key then in Excel 2007 you can:
Step 1: Click on the Office button.
Step 2: Choose Excel Options.
Step 3: Click on the Advanced section on the left hand side.
Step 4: Scroll down until you get to a section called Display options for this worksheet.
Step 5: Tick the option that says “show formulas on the cells instead of their calculated results”
Step 6: Press Ok
If you want to hide the formulae then you can repeat the above mentioned steps. It is better to try to remember the shortcut key if you can.
I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003