formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula

Formula

resolvedResolved · Low Priority · Version 2007

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.11 secs.