replace values with zeros

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I have a large spreadsheet, some areas are for data entry on a monthly basis
the other areas are various text and formulas and blank spaces

I want to clear the data entry portion only but its not easy because areas
are not next to eachother
some formulas and text separate various data entry areas

Is there a way to select the whole spreadsheet and replace all the values
that were keyed with zeros without affecting the text, formulas or blank
areas

Thanks in Advance for any help
chris
 
Menu Edit>Goto>Special and check Constants, and then just hit the delete
key.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top