Excel Spreadsheet question?

Without seeing the spreadsheet:

Use autofilter, select custom. then select "Equals" 0

If you need to unmerge all the cells, hit ctrl + A to select the entire sheet. Then go to Format --> Cells, select the alignment tab and uncheck the box that says "Merge Cells"

This should be an easy one.

- If you're not doing this on the entire sheet/tab, then select the data where you want to empty them out

- Edit - Replace

- Find what: put 0

- Replace with: leave blank

- Click Options to expand this dialog box

- Check the box for Match entire cell contents

- Replace All

This will only remove the 0s from those cells which only have a zero.

Good luck.

.

Are the cells with zeros in the result of a formula? if so you may need to add this to all problem zero cells:

=if(d1="", "" , sum(D1:d5)) this may solve the problem. the =if(d1="", "" part means if D1 is null/empty then the reulting cell is zero, otherwise you will have a zero or error.

you don't want zeros but you also don,t want to lose formula.

here is one think you can try,

put your formula in if fucation

i.e =IF(((A1+B1+C1)=0)," ",(A1+B1+C1))

this formula will display result if total of a1+b1+c1 is more then 0 and if it is 0 then it wont show 0 in your cell

is this all in one column? or thoughout all the columns?