Delete empty rows from print in Excel

A

Ashfaq

When I make my estimates and sales quotation there are some rows which are
still empty, and down to these rows is a row with totals of values. I don't
want to print these empty rows from different worksheets.
 
A

Ashfaq

I know this technique, but need some universal command. I have seen some
workwheen, where empty rows are hidden / deleted even in print preview. Can
we assign a row as 'empty row' on the basis of just one particular cell as
well?

Is there any such possibility?

Hiding or deleting rows with select command are very much common things and
I already know all these things.
 
P

Pete_UK

A simple technique is to use a column which is outside the print area
and have a formula such as:

=D2

copied down the column, where column D contains some value associated
with that row - it could be totals. You apply a filter to this column -
Custom, Does Not Equal, 0 (zero), then the blank rows will be hidden.

Hope this helps.
 
Top