ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste special formulas? (https://www.excelbanter.com/excel-discussion-misc-queries/67046-paste-special-formulas.html)

mturner

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


Anne Troy

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





All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com