Display formulas

R

Ryan

Anybody know how to display formulas in a cell? Example,
if the formula is "=1+1", excel normally displays "2". I
want to see "=1+1" in the cell instead. I thought this
was an option but can't find anything in the help tool.
 
D

Danny

Go to Tools > Options > choose the View tab > check the
Formulas box under the Window Options.
 

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

Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
Markup status / dashboard 0
Link a text box based on drop down box with four options MS Word 365 0
Create own tool bar Mac 2015 0
Autonumber field in Excel that behaves the same as Access 0
Display weeks from a Milestone 0
Show value from one cell in another cell if today falls between a date range 5

Top