how do i remove zeroes values from exel sheet

[Ana]

Hi I do not want zeroes on my sheet how do I can remove it? I have Exel 2007
Thank you,

 

[Michael M]

Ana
Tools / Options / Views and check zero values

HTH
Michael M

 

[Ana]

sorry but where is tools I do not find it

 

[Gord Dibben]

How are the zero values generated?

If by formula you could trap for them like...........

=IF(A1*B1=0,"",A1*B1)


Gord Dibben MS Excel MVP

 

[Teethless mama]

Office Button on top left corner > Excel Options > Advanced > uncheck Show a
Zero in cells that have zero value

 

[Roger Govier]

Hi Ana

Office round button>Excel Options>Advanced>Display Options for This
Worksheet>Show a Zero value

 

[Lauren]

I used one of the excel templates from the office online website. I changed a
all of the column and row headings to labels that were relevant to what I
needed to do.... I finished it and saved as a template in 'Save As'. Now,
when I copy and paste that information/template to another workbook all the
empty cells become zeros with the cell format of that column from the
template...for example...$0 or 0.00 I've tried clearing the contents..but
there's nothing there to clear on the template- only on the new workbook that
I create.
What do I do??

 

[Gordon]

I used one of the excel templates from the office online website. I changed
a
all of the column and row headings to labels that were relevant to what I
needed to do.... I finished it and saved as a template in 'Save As'. Now,
when I copy and paste that information/template to another workbook all
the
empty cells become zeros with the cell format of that column from the
template...for example...$0 or 0.00 I've tried clearing the
contents..but
there's nothing there to clear on the template- only on the new workbook
that
I create.
What do I do??
--

Try File - New- My templates - Create (at least that's the procedure in
2007). That's what you are supposed to do, not copy and paste.

 

[Lauren]

Thank you for getting back to me so quickly. I'm sorry, I forgot the most
important part of the question. My template is several worksheets. When I
open the template on a new excel sheet thats fine. The zeros appear when I
click special link after copying the last worksheet of the template to a new
workbook (that is the sum of all the seperate workbooks)..any advice?

 

[Gordon]

Thank you for getting back to me so quickly. I'm sorry, I forgot the most
important part of the question. My template is several worksheets. When I
open the template on a new excel sheet thats fine. The zeros appear when I
click special link after copying the last worksheet of the template to a
new
workbook (that is the sum of all the seperate workbooks)..any advice?

You shouldn't need to copy anything. If you have saved the amended template
properly as a template, then when you create a new document from that
template it should all be there.
In fact Ive just created a template from a multi-sheet workbook and whan I
go to New-Template and open a document based on that template, it's all
there.

 

[Gord Dibben]

Lauren

That's not how you use templates.

Don't bother to copy and paste to another workbook.

Just open the template and a new workbook will be created based upon the
template leaving the template unchanged and the new workbook will have the same
formatting as the template.


Gord Dibben MS Excel MVP