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...
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.
Not strange at all. As I said in my very first reply, a cell which contains a formula cannot be considered a constant. A constant is an entry which is not the result of a formula, for example one which has been manually entered into a cell.
Regards