Is there a way to clear contents an a worksheet without effecting any formulas? Thanks, Craig
C cparsons Oct 12, 2004 #1 Is there a way to clear contents an a worksheet without effecting any formulas? Thanks, Craig
M Myrna Larson Oct 12, 2004 #2 Edit/Goto, click the Special button, and in the dialog select Constants. Click OK, then press the Del key.
Edit/Goto, click the Special button, and in the dialog select Constants. Click OK, then press the Del key.
J Jan Karel Pieterse Oct 12, 2004 #3 Hi Cparsons, Is there a way to clear contents an a worksheet without effecting any formulas? Click to expand... F5 (goto), click Special, select "Constants", check the appropriate boxes, click OK. Now hit the del key to clear them. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com
Hi Cparsons, Is there a way to clear contents an a worksheet without effecting any formulas? Click to expand... F5 (goto), click Special, select "Constants", check the appropriate boxes, click OK. Now hit the del key to clear them. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com
