Make the #N/A invisible

[rixanna]

I have specified some formula in my Excel worksheets. But, when the
cells are empty(with no data), it shows this sign #N/A in the cells.

How I could make it invisible so that when a user print the sheet, it
will only display the cells that contain data?

 

[bobocat]

In page setup->Sheet
Print-> Cell erros as <blank>

 

[Pete_UK]

Another way is to amend your formulae so they don't produce the errors:

=IF(ISNA(your_formula),"",your_formula)

Hope this helps.

Pete

 

[rixanna]

In page setup->Sheet
Print-> Cell erros as <blank>

Thanks a lot..it really works!!!

 

[bobocat]

You are welcome

Thanks a lot..it really works!!!

 

[aaron.kempf]

I know how to get rid of N/A...

don't use Excel.
don't use Excel.
don't use Excel.

how is that for a solution?

use MS Access or something similiar.. Access Data Projects _ROCK_

-Aaron