Print showing formulas

S

Shannon

I am wondering how you can print the spreadsheet showing
all of the formulas. So instead of the answers to all of
the formulas you just see the actual formula. I know this
is possible, but I am having a hard time remembering how.
Any help would be greatly appreciated.
Thanks.
 
A

Anders S

Shannon,

There is a checkbox Formulas(?) in Tools>Options>View(?) that will display the formulas instead of values.

(?) means I'm not sure what it's called.

HTH
Anders Silven
 
T

Trevor Shuttleworth

Shannon

Tools | Options | View | Windows Options | Check Formulas

Regards

Trevor
 
A

Amr Tabbarah

Shannon,

A short cut for what Trevor has suggested would be as follow:


Ctrl + ~ (Control key in addition to Tilde key)


Using it another time will bring you back to the formulae results.


Regards,


Amr
 

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

Printing a worksheet with and without formulas showing 1
How do I print the spreadsheet and show formulas instead of values 2
Cell formulas 2
?can I wrap displayed formulas? 3
Formulas not copying to other cells 10
Printing without formulas showing 1
copying groups with formulas 5
automatically show cell references of formulas 2

Top