Call us on 0844 800 7880
This weeks Bite Size IT Tip : MS Excel 2010 - Displaying and Printing Formulas

Introduce Me

Displaying and printing formulashead winking left

If you've got this far with Excel you must be a confident user of formulas and functions. When viewing a worksheet Excel displays the results of our formulas.


However, there is a simple way to display the formulas themselves. And, it can be useful for the purpose of checking your work or even taking a printout for documentation purposes.

Let's see how it's done.

Tell Me

To display formulas on screen:

  1. Select the File tab.
  2. Choose Options near the bottom of the menu.
  3. Click Advanced.
  4. Scroll down to Display options for this worksheet.

  5. Tick the item - Show formulas in cells instead of their calculated results.
  6. Click OK.

The formulas are displayed in their cells.


Tell Me More

To print a copy use normal print methods.


There is a quick key combination to turn the display on and off which will save you going to Excel options in the File tab.

It's simply the CTRL key plus `

I know it's difficult to see what I've typed but you use the CTRL key and the backward sloping apostrophe on the key next to number one on the typewriter keyboard.

This combination acts like a switch turning formulas on and off.


Let Me Try

Here is an exercise for you to try out displaying formulas for yourself.

MS Excel 2010 : Displaying and printing formulas

If the "OPEN" option does not show you all icons you'd expect in the application, use the "SAVE" option.


Help Me



Remember to put your new skills into practice as soon as possible. Learn a little each day to improve your knowledge and skills.



My Bite Size Login

On-line Courses
Facebook Twitter LinkedIn YouTube