Excel: Can formula be removed by Excel

Can formula's in the cells be removed by Excel program/functions? In Worksheet5, C2:C48 contains numeric values generated thr' formula =D2:D48. Ex: C2=D2 At a particular time, to remove formulas from C2:C48; I select, copy, paste special, values, Ok, Enter. But can it be done by say putting a number 1 in C1 or by any other method. This worksheet contains only these 2 columns. Thanx in adv

This question generated 47 answers. To proceed to the answers, click here.

This thread is current as of June 26, 2014.

For more resources for Microsoft Excel