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.
Select the empty rows and pull-down:
Format gt; Row gt; Hide
--
Gary's Studentquot;Ashfaqquot; wrote:
gt; When I make my estimates and sales quotation there are some rows which are
gt; still empty, and down to these rows is a row with totals of values. I don't
gt; want to print these empty rows from different worksheets.
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.
quot;Gary''s Studentquot; wrote:
gt; Select the empty rows and pull-down:
gt;
gt; Format gt; Row gt; Hide
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Ashfaqquot; wrote:
gt;
gt; gt; When I make my estimates and sales quotation there are some rows which are
gt; gt; still empty, and down to these rows is a row with totals of values. I don't
gt; gt; want to print these empty rows from different worksheets.
- Aug 28 Tue 2007 20:39
Delete empty rows from print in Excel
close
全站熱搜
留言列表
發表留言