Wednesday, August 18, 2010

How can i get excel 2007 to show formulas for printing. i know how to with 2003?

i want to be able to print off worksheets with formula showing instead of figuresHow can i get excel 2007 to show formulas for printing. i know how to with 2003?
This should help you! Good Luck





http://www.dummies.com/how-to/content/ho鈥?/a>How can i get excel 2007 to show formulas for printing. i know how to with 2003?
It's exactly the same as in previous versions - quick way is to pres Ctrl key down, hold it down and tap the grave key, the one next to the No. 1 key, top left of keyboard. To return to data view, simply press the keys again, has toggle effect. Don't forget to set our page to landscape, possibly fit one page to one page, and widen the columns because if you have long formulae they might not be displayed in full.
just put a ' in front of the = sign at the beginning of your formula.





=sum(A1:B1) will show the sum of cell A1 %26amp; B1


'=sum(A1:B1) will read =sum(A1:B1)

No comments:

Post a Comment