Omitting blank rows from a print range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Linforth - 07 Aug 2003 11:38 GMT

Help

need to find out how when printing a range of numbers I
can ommit the rows with a zero in the actual print whilst
still including in the range.
This is possible in 123 by typing in |015 at the first
column of the range eg:-

A B C D E F G

|015 apples 100 100 100 100 100
|015 Pears 0 0 0 0 0
|015 Oranges 50 50 50 50 50

when printing the above all would be included in the range
but only apples & oranges would appear in the print.

hope u can help

Steve

Reply to this Message

Paul Cundle - 07 Aug 2003 12:21 GMT

There's no automatic way of doing it, but you could put a formula like
=SUM(C2:G2) in cell A2 and drag it down the whole set of data.
To hide the rows you don't want, turn on Autofilter and hide all rows where
column A = 0.

Obviously if C to G were e.g.
3 4 5 -3 -4 -5
then they would add up to 0 but you would want the row, so if there are
negative numbers then you will need to modify it slightly.

Paul C,

Signature

> Help
>
[quoted text clipped - 15 lines]
>
> Steve

Reply to this Message