Can you clear a column of numbers that contain a formula?

B

Bob

I compiled a column of numbers and then totaled them with a formula. Is it
possible to retain the column of numbers and eliminate the formula?
 
G

Gary''s Student

Sure. Let's say we have numbers in A1 thru A100 and =SUM(A1:A100) in cell
A101.

Just clear cell A101

If, however we wanted to do the reverse (keep the sum, but get rid of the
data), we would first copy cell A101 and then:

Edit > Paste Special > Value back onto cell A101
 
B

Bob

Lets say you have a formula that addes col a1 thru a3 into a4 and then you
copy the formula that is in a4 to the bottom of a col of these totals. Can
you remove that formula that has been copied down the a4 column?

"
 
Top