98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula
Formula
Resolved · Low Priority · Version 2007
Tue 13 May 2008, 16:54Delegate Penny said...
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?
Thu 15 May 2008, 12:44Trainer Rajeev said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |
