Difficult to give Subject title

[wendell]

Thanks mostly to the help that you guys have given me, I'm almost finished with a customer form project that I'm working on. I need help with tweaking my final product:

I have a spreadsheet that I have allowed room for 20 lines of data linked from another sheet. The data includes an item number, quantity and various possible sizes on each line. On the destination sheet, I have a simple formula to total the columns, and then I print the order. The lines of data that are not used are listed and of course showing a "0" in each field. Is there any way to clean this up show that only the lines of data used show up, without having "0" in each cell for each unused line. I can live with what I have, but it would look a lot cleaner when I print the final form.

I hope that I explained this so that you can understand what I'm talking about.

Thanks,

Wendell

[Carim]

Hi,

Do you mean not to display 0 ...
Tools Options View Zero Values

[oldchippy]

Previous post here

http://www.excelforum.com/showthread...hlight=display

[wendell]

You guys make this look easy. Thanks. Problem solved.


Wendell

[Carim]

Glad your problem is fixed

Thanks for the feedback