For All Your Training Needs                                                                      [ Home ] [ Up ] [ Site Map ] [ Search ]

Microsoft Excel
Display All Formulas in a Worksheet

Using a spreadsheet can be a challenge when you are not sure which cells contain formulas and which contain text or values.  There is a quick keyboard shortcut you can use to display formulas in all cells in the active worksheet.  If needed, you can then print the worksheet with the formulas displayed.

In a Microsoft Excel Worksheet

• Click in any cell of the worksheet

Display Formulas

• Simultaneously depress the <Ctrl> and the <Accent> keys    

  • The <Accent> key is located in the upper left corner of the keyboard

• Any cell that contains a formula will display the formula in the cell

Worksheet with Formulas Displayed

Turn Off Formula Display

• Simultaneously depress the <Ctrl> and the <Accent> keys

• Any cell that contains a formula will now display cell values

Worksheet with Values Displayed

Send mail to Complete Training Management with questions or comments about this web site.
Copyright © 2002 Complete Training Management
Last modified: December 03, 2008