Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 25th 06, 02:36 AM posted to microsoft.public.excel.newusers
mapen
 
Posts: n/a
Default 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


  #2   Report Post  
Old February 25th 06, 11:01 AM posted to microsoft.public.excel.newusers
paul
 
Posts: n/a
Default 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


  #3   Report Post  
Old February 25th 06, 12:05 PM posted to microsoft.public.excel.newusers
Lena
 
Posts: n/a
Default 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


  #4   Report Post  
Old February 26th 06, 10:57 AM posted to microsoft.public.excel.newusers
mapen
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
copy values generated by conditional formula in one sheet to the other work sheet as values ramana Excel Worksheet Functions 1 October 5th 05 01:04 PM
copy values generated by conditional formula in one sheet to the other work sheet as values bobby Excel Discussion (Misc queries) 1 October 5th 05 12:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 02:10 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017