Print Value and Formula View worksheets

[Wanda]

I have a class which asks for Value and formula view worksheets. The text
book is an older version of excel. I know what to do in the older version of
Excel but my 2007 Excel does not have this option and I do not know what
happens when the formula box is unchecked in the older version to do the same
thing in 2007 version

 

[Roger Govier]

Hi Wanda

press the round office button>Excel Options>Advanced>Display options for
This Worksheet>click Show Formulas in cells ....

Alternatively the same keyboard shortcut works in 2007 the same as previous
versions
Press Control + ` (control + the Grave accent - it's the key to the left of
keyboard)
This acts as a toggle switching back and forth between formula view and
results view.