Display Formulas

  • Thread starter Thread starter carol matteson
  • Start date Start date
C

carol matteson

Does anyone know how to display formulas in a worksheet so
that they print on paper?
 
<Tools> <Options> <View> tab,
And click on "Formulas".

Or, from the keyboard,
<Ctrl> <~>,
which can be used as a toggle.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Does anyone know how to display formulas in a worksheet so
that they print on paper?
 
Carol, one way Ctrl+` to toggle between formulas and valves

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Carol

You have a couple of answers which will do the trick, but kinda messy.

For neater layout I would suggest John Walkenbach's ListFormulas code from

http://j-walk.com/ss/excel/tips/tip37.htm

Lists formulas, addresses and results on a separate worksheet.

Or David McRitchie's GetFormula Function from

http://www.mvps.org/dmcritchie/excel/formula.htm#getformulainfo

They both involve the use of VBA. If new to VBA and Macros see David's site
for Getting Started with VBA and Macros.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP
 
You're absolutely right Peo, BUT,
It IS the same key, AND it's much more easily identifiable,
~ against `
Don't you think?

It gets the job done, with less typing, explaining exactly what or where `
is.
--

Regards,

RD
 
What if the tilde is not on the same key, there are many different keyboard
layouts?
 
Hi (God kväll)

Just type ' before the formula and the formula instead of th
calculated value will displayed
 
That shows you how provincial I am Peo.
I didn't realize that.
I guess I'll have to describe it the "right" way from now on!

Thanks for the "heads-up".
 
As I understand the character is not always accent grave, but
is almost always the character to the left of the number row.
So it is also a good idea to include

For a list of shortcuts in the same manner as used in Excel Help,
because that where they were gathered together from see
: http://www.mvps.org/dmcritchie/excel/shortx2k.htm
 
Back
Top