How can I make a cell valuye absolute?
 

Say colum 1 is a value and column 2 is a calculation based on that
value
How can I delete column 1 but still retian the caluculated values in
column 2?


--
astoller
------------------------------------------------------------------------
astoller's Profile: http://www.excelforum.com/member.php...o&userid=21002
View this thread: http://www.excelforum.com/showthread...hreadid=503798

How can I make a cell valuye absolute?
 

You can select the second column then copy it and use

Edit Paste Special values OK

Enter


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503798