Displaying Formula Syntax in Excel

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).