printing only filled in cells of an inventory?
 

i've made an order form on excel. however i only want to print data entered.
any column w/o data i do not want to print. how do i actually save all
entered info to another page as a complete order form without all those empty
cells?

printing only filled in cells of an inventory?
 

You could use another part of the w/sheet or w/book in which to import the
data you enter and set the print area to your order form.

Instead of filling a form in you could set up a list of customers (one per
row) and have the data you enter transposed to your order on the next w/sheet.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"johnkennedy" wrote:

i've made an order form on excel. however i only want to print data entered.
any column w/o data i do not want to print. how do i actually save all
entered info to another page as a complete order form without all those empty
cells?