Clear Contants w/o effecting formulas

  • Thread starter Thread starter cparsons
  • Start date Start date
C

cparsons

Is there a way to clear contents an a worksheet without effecting any
formulas?

Thanks,
Craig
 
Edit/Goto, click the Special button, and in the dialog select Constants. Click
OK, then press the Del key.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you clear values and leave formula 1
Scrabble Value calculation for Welsh words 0
Clearing content from a cell (or a group) but retain its formula 2
Howdy! Need a little help with code... 3
If Formula? 1
How to remove the cell reference in a sheet at once 3
conditional formula 1
use cell value in a fomaula 2

Back
Top