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

formulas

ResolvedVersion 2007

Laura has attended:
Excel Introduction course

Formulas

how do I see all formulas?

RE: formulas

Hi Laura,

Thank you for your question.

If you want to see all the formulas at once, hold the Ctrl key down and press the Pipe key(button under the Escape key).

To view the values again, repeat the same procedure.

I hope this answers your question.

Regards

Simon

Thu 12 Mar 2009: Automatically marked as resolved.

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.07 secs.