Print an excel spreadsheet and show formulas

[DBAchick]

This is probably an Excel 101 question, but I just cannot make it work.

I have a complicated worksheet with a zillion formulas that reference a zillion other spreadsheets, workbooks and cells. I would like a print out of the spreadsheet that shows all of those 'formulas' in the cells rather than the data.

Is this possible?

 

[ETID]

Go to "TOOLS" menu, then options, then in the view tab click the formulas check box on.

 

[JVFriederick]

Ctrl+`(that thing to the left of the 1 key) also expands or contracts cell formulas.

 

[DBAchick]

Thank you both!