Is there an easy way to copy formulas as text to other cells (for use as a
reference)?

Audrey Wrote:
Is there an easy way to copy formulas as text to other cells (for use as
a
reference)?

Put an apostrophe before the formula and it will be converted to a
text.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=345999

You can also just not copy the = or edit it out after pasting the formula.

If this is just for occasional reference and not something to takeup space
all the time, it may be worth looking at ToolsOptionsView & put a check in
the box for Formulas, go back and remove the check when you're done.
Keystroke: Ctrl+` (Grave Accent, right above the Tab key) to toggle formulas
on/off.

Hope this is of use to you |:)

"BenjieLop" wrote:


Audrey Wrote:
Is there an easy way to copy formulas as text to other cells (for use as
a
reference)?

Put an apostrophe before the formula and it will be converted to a
text.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=345999