DH Templates

when printing excel sheet, how can i print only the fields that are filled? details inside. please help.?

So, i am creating an invoice template. I have about ten rooms with rates and number of nights. but suppose someone uses only three rooms, and when i print out the invoice, the customer does not need to see ten rooms in the paper, only the three rooms he used. how can i tell excel to print only the fields that are filled and hide the un-used ones? thanks all.

Public Comments

1. If it's columns that you want to hide, highlight the column, right click and click on hide. You can do the same thing with rows.