Displaying Formula Syntax in Excel 2007

To display and print the formula in a file, we can use the Ctrl+`, (`) the sign is located to the left ofthe number 1 on your keyboard.

Let’s take an example to understand that how we can display the formula syntax.

We have data below in which some cells contain formula.

To display the syntax of all formulas in a sheet, follow the below given steps:-

• Go to the Formulas tab.
• Click on Show Formulas in the Formula Auditing group.

• Excel will display the content of each cell in the worksheet as they would normally appear only in the Formula bar or when we edit them in the cell.
• When we will select the cells which contain formulas, the formulae in the cells will be visible.

 

 
Note: If you want to use a shortcut method instead, press the key Ctrl+` on your keyboard to display all the formulas.

To print the syntax of all formulas in a sheet, follow the below given steps:-

• Go to the Page Layout tab.
• In the Sheet Options group, under Headings, click on Print.

• To see the print preview, click on the small icon in the corner in the Sheet options group.

To revert to the normal view, click on Show formulas in the Formula Auditing Group in the Formulas tab or press Ctrl+` on your keyboard.

This is how we can display and print the formula syntax in Microsoft Excel 2010 and 2013.