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...
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.
- Maybe you're not using the Go To command properly. You should make sure that you don't have more than a single cell selected in the worksheet prior to using it, otherwise it will operate over the selected range only. For example, if you have highlighted column A, then the Go To command will only look in column A, not the rest of the worksheet.
