Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |