RE: Copying Formula Text

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I assume when you say you want the formula text, you want to be able to copy
the formula and not just the result.

If you just select the cell, copy, select the target cell and paste, What
is it you do not like about the result?
The formulas may need to be modified for absolute and relative referencing
to get what you want.

"jpx" wrote:

>
> Is it possible to copy and paste just the text of a formula from one
> cell to another without going into the formula text window and using
> Ctrl+c. Can this be done from multiple cells to multple cells.
> thanks.
>
>
> --
> jpx
> ------------------------------------------------------------------------
> jpx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1013
> View this thread: http://www.excelforum.com/showthread.php?threadid=377160
>
>
.



Relevant Pages

  • Re: Referencing a cell for a row
    ... I placed this formula in my cell ... tonydepo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15306 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Autopopulating a cell
    ... an entry into the a1 cell. ... Tralee6 ... Tralee6's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29273 ... Prev by Date: ...
    (microsoft.public.excel)
  • Array Reference
    ... value of a cell? ... accross. ... anar_baku's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18259 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Help
    ... Use the 'Goal seek' option on the 'Data' menu to find the value of cell ... Deadloss ... Deadloss's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29859 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Adding a column
    ... If there is only one number in cell it is counted, if 2, then the one ... in parentheses is the only one of the 2 counted. ... roger_home's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16434 ... Prev by Date: ...
    (microsoft.public.excel.misc)