Excel: To Display Formula in the cells Instead of Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make all the cells in my spreadsheet to display formulae instead of
values?

This is a basic feature in other spreadsheet program that EXCEL may not
have. It is a useful feature for the user. I am surprise that EXCEL does
not have this feature.
 
Try:

Tools | Options | View | Check 'Formulas'

Or use the key combination

Ctrl `

to toggle the formula view
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Excel Excel spreadsheets opening at top instead of bottom. 4
Excel How to get output of the formula instead of True or false 1
Paste Special Formula Multiply feature doesn't work anymore 2
return a formula instead of a value of a cell 4
Conditional Format - Copy a cell instead of "true" 3
Paste Special Values 2
Excel Formula Bar Time Display Format 2

Back
Top