Block deleting all zeros at once.

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

In Excel2003 Is there a way of block deleting all zero
values from 3 columns of data. If not could anyone
suggest a function to do this.
Thank you
 
Use Find and Replace, replacing "0" with nothing. Be sure to select the
"Match entire cell contents" option.
 
Oh, be sure to select the range before you do this or the entire sheet will
be searched.
 
You must log in or register to reply here.

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

Similar Threads

Variable Range, selecting/copying 1
Macro required 4
this is killing me. INDEX/MATCH "closest to X" in a smart way? 5
Zero Upload Speed 6
Formula that checks balances 3
Copying and Deleting Range using buttons on worksheet 1
A data validation question 1
Deleting a row that has a zero in column A 8

Back
Top