Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save Excel info without saving the reference cells?
I have used two columns to creat a third column. I want to save the third
column and delete the first two columns used to create the third. When I try to do this, I receive the message, #REF!. Program help wasn't much help. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save Excel info without saving the reference cells?
You need to convert your formulas in the third column to values.
Select the cells, copy them, then go to the Edit menu, choose Paste Special, and choose Values. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dave" wrote in message ... I have used two columns to creat a third column. I want to save the third column and delete the first two columns used to create the third. When I try to do this, I receive the message, #REF!. Program help wasn't much help. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save Excel info without saving the reference cells?
Dave
Copy the third column and then EditPaste special...Values and number formats over the original data. This will kill the formulas allowing you to delete the referenced cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Dave" wrote in message ... I have used two columns to creat a third column. I want to save the third column and delete the first two columns used to create the third. When I try to do this, I receive the message, #REF!. Program help wasn't much help. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Why is Excel Save As feature not working? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel should be able to map which cells reference each other. | Excel Worksheet Functions |