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.

 
img1
 

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.

 
img2
 

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

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

 
img4
 

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

 
 
img5
 

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.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube