Delete empty rows from print in Excel
 

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.

Delete empty rows from print in Excel
 

Select the empty rows and pull-down:

Format Row Hide
--
Gary's Student


"Ashfaq" wrote:

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.

Delete empty rows from print in Excel
 

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.



"Gary''s Student" wrote:

Select the empty rows and pull-down:

Format Row Hide
--
Gary's Student


"Ashfaq" wrote:

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.