Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying Formula Text
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...fo&userid=1013 View this thread: http://www.excelforum.com/showthread...hreadid=377160 |
#2
|
|||
|
|||
edit/copy
select new location edit/paste special, select Values. OR... Right-click the BORDER of the selection and drag to the new location. When you let go, you'll see a dialog in which you can select "Copy here as values only." Enjoy. FYI: I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks on June 15, 4-5PM. If interested, go to http://www.iil.com, click on the yellow/orange "Try a free webinar" link on the left side, click the Microsoft Excel Tips & Tricks link, follow instructions to register. "jpx" wrote in message ... 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...fo&userid=1013 View this thread: http://www.excelforum.com/showthread...hreadid=377160 |
#3
|
|||
|
|||
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...fo&userid=1013 View this thread: http://www.excelforum.com/showthread...hreadid=377160 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
text to formula | Excel Worksheet Functions | |||
Text formula | Excel Worksheet Functions | |||
reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |