Displaying Formula Syntax

To display the syntax of all formulas in a sheet:

Press <Ctrl+‘> (the ‘ symbol is located to the left of the number 1 on the keyboard).

OR

From the Tools menu, select Options, the View tab, Formulas, and then click OK.

To return to the normal display, press <Ctrl+‘> again (this keyboard shortcut is a toggle).

Regular Display :

F1 - Get The Most Out Of Excel Formulas and Functions0026

Displaying Formulas :

F1 - Get The Most Out Of Excel Formulas and Functions0027

Technorati Tags:

No comments:

Post a Comment

Related Posts