Penny has attended:
Excel Introduction course
Excel Intermediate course
Formula
How do i go between seeing a formula in a cell and seeing the value of that formula?
RE: formula and Function View!!
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
