Berkeley CSUA MOTD:2008:January:05 Saturday <Friday, Sunday>
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2008/1/5-7 [Uncategorized] UID:48894 Activity:nil
1/4     http://hongkong.edushi.com
        Kind of slow but pretty neat to look at (e-city)
2008/1/5-7 [Computer/SW/Apps] UID:48895 Activity:moderate
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.
Berkeley CSUA MOTD:2008:January:05 Saturday <Friday, Sunday>