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’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.
Maybe I’m not explaining myself clearly. I have a spreadsheet I created years ago which does exactly what I want it to do. I simply want to clear the entire spreadsheet except for its title and column names/labels… but leave all the hidden formulas I created in certain cells. How do I accomplish this simple task 😊?
- In that case your original plan of using the Go To command with Constants should work just fine, provided of course that prior to running that command you ensure that the selected range within the worksheet does not include any of the constants that you wish to keep (title, column names, etc.).
Regards- Yea… that’s what I thought. Example: I have several rows in a column that have a variation of the equation “=SUM(H6-B6)” that all currently have values in the cells. I highlighted just those cells and went to the ‘Go to special’, ‘constants’ option… and hoping to simply click on delete… but instead received the “No Cells Were Found” message. Very strange.