How to copy a formula as text to another cell?

  • Thread starter Thread starter Guest
  • Start date Start date
Audrey said:
Is there an easy way to copy formulas as text to other cells (for use as
a
reference)?
Click to expand...

Put an apostrophe before the formula and it will be converted to a
text.
 
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 Tools>Options>View & 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 |:>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Text within an Array 2
Formula text in woorksheet cell 2
Copy formulas to another workbook 4
Formula to correct copied option tickers starting with "+" 4
Copy a calculated date in EXCEL as text 4
Need to add text to all cells in excel or merge the text in two ce 1
How to copy range without changing formulas? 3
automatically copy text 4

Back
Top