Showing Formulas in Excel

Showing Formulas in Excel

Did you know that you can show all formulas in excel at one time?

To quickly show all formulas in your Excel spreadsheet hold down the CONTROL key on the keyboard and press the grave accent key ( ` ).

<![if !supportLists]>·         <![endif]>This key is located next to the #1 key on the top left corner of the keyboard and looks like a backwards apostrophe.

<![if !supportLists]>·         <![endif]>Showing formulas does not change the spreadsheet, only the way it is displayed.

Showing formulas has several uses:

<![if !supportLists]>·         <![endif]>Makes it easy to find cells containing formulas

<![if !supportLists]>·         <![endif]>It allows you to quickly read through all formulas to check for errors

<![if !supportLists]>·         <![endif]>When you click on a formula, Excel outlines in color the cells referenced in the formula. This helps you to trace the data being used in a formula.

<![if !supportLists]>·         <![endif]>Print spreadsheets with show formulas turned on. Doing so, will allow you to search a spreadsheet for hard to find errors.