If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Paste special formulas?
I've used the paste special formulas option after copying a column. However it is still pasting the values aswell. Anybody have any ideas why this is happening? Using Excel 2000. Thanks -- mturner ------------------------------------------------------------------------ mturner's Profile: http://www.excelforum.com/member.php...o&userid=30147 View this thread: http://www.excelforum.com/showthread...hreadid=504458 |
#2
|
|||
|
|||
Paste special formulas?
Because formulas result in values. If you don't want them to, then remove
the values that reside in the cells on which your formulas are calculating. ************ Hope it helps! Anne Troy www.OfficeArticles.com "mturner" wrote in message ... I've used the paste special formulas option after copying a column. However it is still pasting the values aswell. Anybody have any ideas why this is happening? Using Excel 2000. Thanks -- mturner ------------------------------------------------------------------------ mturner's Profile: http://www.excelforum.com/member.php...o&userid=30147 View this thread: http://www.excelforum.com/showthread...hreadid=504458 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
When I special paste and transpose.... | sml | New Users | 4 | January 12th, 2006 12:49 AM |
how to make plain text the default setting in paste special | Kevin | General Discussion | 0 | November 4th, 2005 09:05 PM |
Paste Special | Doug | General Discussion | 2 | June 10th, 2005 06:59 PM |
Word 2000 paste special links from Excel 2000 | Pete W | General Discussion | 5 | June 18th, 2004 02:29 PM |
Paste Special | Dave Peterson | Setting up and Configuration | 0 | May 21st, 2004 02:42 AM |