How to Copy Values Only, Not Formula?
 

Hello,

I'm creating a spreadsheet to be used by others who will be doing alot
of copy and pasting.

How do I make it so that only the values in a column of cells gets
copied, but not the formula? I am aware of the "Paste Special" feature
of Excel, but I imagine there must be a better way. I cannot count on
the other users to use it since they will be doing many non-special
copy/paste in other parts, and they may not remember to do it for this
column of data (especially since the mistake won't be immediately
apparent).

Is there a way I can mark a column of data so that when anyone copies
from it, it will only capture the values and not the formulas?

Another idea I had was to hide that column and create a new one that
references the one with the data and formulas. Is that the only way to
do it? I think there must be a better way.


--
mapen
------------------------------------------------------------------------
mapen's Profile: http://www.excelforum.com/member.php...o&userid=31913
View this thread: http://www.excelforum.com/showthread...hreadid=516442

How to Copy Values Only, Not Formula?
 

hide the real formulas....
--
paul
remove nospam for email addy!



"mapen" wrote:


Hello,

I'm creating a spreadsheet to be used by others who will be doing alot
of copy and pasting.

How do I make it so that only the values in a column of cells gets
copied, but not the formula? I am aware of the "Paste Special" feature
of Excel, but I imagine there must be a better way. I cannot count on
the other users to use it since they will be doing many non-special
copy/paste in other parts, and they may not remember to do it for this
column of data (especially since the mistake won't be immediately
apparent).

Is there a way I can mark a column of data so that when anyone copies
from it, it will only capture the values and not the formulas?

Another idea I had was to hide that column and create a new one that
references the one with the data and formulas. Is that the only way to
do it? I think there must be a better way.


--
mapen
------------------------------------------------------------------------
mapen's Profile: http://www.excelforum.com/member.php...o&userid=31913
View this thread: http://www.excelforum.com/showthread...hreadid=516442

How to Copy Values Only, Not Formula?
 

What you can do is hide formulas in the cells (select Format Cells -
Protection - Hidden) and then protect the Sheet (Tools protection). You can
unprotect it when you are using the sheet, and protect for others (you can
use a password if you want)

"mapen" wrote:


Hello,

I'm creating a spreadsheet to be used by others who will be doing alot
of copy and pasting.

How do I make it so that only the values in a column of cells gets
copied, but not the formula? I am aware of the "Paste Special" feature
of Excel, but I imagine there must be a better way. I cannot count on
the other users to use it since they will be doing many non-special
copy/paste in other parts, and they may not remember to do it for this
column of data (especially since the mistake won't be immediately
apparent).

Is there a way I can mark a column of data so that when anyone copies
from it, it will only capture the values and not the formulas?

Another idea I had was to hide that column and create a new one that
references the one with the data and formulas. Is that the only way to
do it? I think there must be a better way.


--
mapen
------------------------------------------------------------------------
mapen's Profile: http://www.excelforum.com/member.php...o&userid=31913
View this thread: http://www.excelforum.com/showthread...hreadid=516442

How to Copy Values Only, Not Formula?
 

Thank you for the answers! I did not know that I could hide formulas.
This sounds like it will work. Thanks again.


--
mapen
------------------------------------------------------------------------
mapen's Profile: http://www.excelforum.com/member.php...o&userid=31913
View this thread: http://www.excelforum.com/showthread...hreadid=516442