is there a formula, or a macro that will clear certain ranges in a spreadsheet without eliminating the formulas already in place? if i protect the worksheet will it keep the formulas and allow the data to be cleared?
Do you want to eliminate the cells that don't contain formulas ? then, you can record a macro like this:
Select all cells (Or the range that you want)
Click on "Special"
Select "Constants" (You can restrict this to only numbers, text, errors or logical values)
Press "Del", or go to Edit | Clear Contents