Forum Discussion
No Cells Were Found
When trying to clear data out of cells in Excel that are using formulas, I select the cells and and use the ‘Go to special’, ‘constants’ option. I receive the following error/message: “No Cells Were Found”
- Of course, a cell which contains a constant is by definition one which does not contain a formula.
Regards - I guess the question then becomes, “how do I clear cells in a spreadsheet without clearing the formulas”… so I can reuse the spreadsheet? What I described was the solution I found when searching the internet.
Bit confused. You appear to be contradicting yourself. First you said that you are "trying to clear data out of cells in Excel that are using formulas". What exactly does that mean? Now you seem to be suggesting that you want to clear all cells which don't contain formulas, for which the Go To Constants option would indeed be ideal.
Regards
I’m trying to create a clean/empty spreadsheet (except for names, column labels, etc)… but maintain all the formulas that are in certain cells.
