Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I paste formulas in excel clipboard?
I am trying to paste various formulas in excel clipboard, but what it's
copying to the clipboard is only the content of the cells. How do I get to paste formulas only? |
#2
|
|||
|
|||
AndyBermuda Wrote: I am trying to paste various formulas in excel clipboard, but what it's copying to the clipboard is only the content of the cells. How do I get to paste formulas only? goto tools, options, click on "formulas" now you should have no problem -- markline ------------------------------------------------------------------------ markline's Profile: http://www.excelforum.com/member.php...o&userid=23681 View this thread: http://www.excelforum.com/showthread...hreadid=374532 |
#3
|
|||
|
|||
Hi Andy,
If you mean copy to the clipboard and paste to a cell you would copy from the formula bar not from the cell If you want to do the same with a macro: Chip Pearson has a web page on using the clipboard http://www.cpearson.com/excel/clipboar.htm If you want to use the context menu (rightclick menu) to copy then paste the same formula unchanged to another cell see http://www.mvps.org/dmcritchie/excel/rightclick.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "AndyBermuda" wrote in message ... I am trying to paste various formulas in excel clipboard, but what it's copying to the clipboard is only the content of the cells. How do I get to paste formulas only? |
#4
|
|||
|
|||
Select the entire formula in the formula bar.
Right click, and choose "Copy". Hit <Enter *OR* <Esc -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "AndyBermuda" wrote in message ... I am trying to paste various formulas in excel clipboard, but what it's copying to the clipboard is only the content of the cells. How do I get to paste formulas only? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Copy / Paste Function & the Office Clipboard | Excel Discussion (Misc queries) | |||
paste excel table to word | Excel Worksheet Functions | |||
Cut and Paste into spreadsheet with locked formulas | Excel Worksheet Functions | |||
How to cut and paste with locked formulas | Excel Discussion (Misc queries) |