Forum Discussion

Copper Contributor

Apr 14, 2023

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...

excel

BrookC84

Copper Contributor

Apr 14, 2023

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.

JosWoolley

Iron Contributor

Apr 14, 2023

BrookC84

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

BrookC84
Copper Contributor
Apr 14, 2023
JosWoolley
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.
- JosWoolley
  Iron Contributor
  Apr 14, 2023
  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.
  - BrookC84
    Copper Contributor
    Apr 14, 2023
    JosWoolley
    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 😊?