1/5 I'm an Excel novice who needs help. Let us say I have a column of
data A. I then take the absolute value of A1 and enter it in B1:
(B1=ABS(A1)). All is good. My problem is when I want to delete
Column A, Column B is still referencing A. How do I tell Excel to
stop referencing the source data and instead let me have the
result standalone? I don't want to keep A around anymore, but I
still want B.
\_ You keep A around and hide it.
Or, copy column B and Paste Special...Values and get rid of both
A and B. -tom
\_ Hiding it was my solution, but that sucks. I will try "Paste
Special".
\_ Depending on what you're doing you may want to see A again. You
can hide it as tom said or move it to another sheet and just
reference it from your 'scrap data' sheet. I've yet to find a
reason to actually destroy source data. YMMV.
\_ I don't need it again and I want to get rid of it. |