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

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

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