How do I save Excel info without saving the reference cells?

D

Dave

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
 
C

Chip Pearson

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
 
N

Nick Hodge

Dave

Copy the third column and then Edit>Paste 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
[email protected]
 
Top