How can I get vacant lines in a sheet to not print
 

In Lotus 123 the following formula @IF((F25+H25)=0,"|--","") in the first
cell of each row in a print range would place the pipe symbol in that cell.
Any rows with the symbol would not print when the range was printed. This is
very helpful when you don't need to print rows that do not contain data.
Such as inventory items with no qunatities. How can I get Excel to do the
same thing. Some of my spread sheets may have hundreds of rows but I only
need to print those with data. Sorting first is not an option.

look at autofilter in Help.

"Luapremrub" wrote:

In Lotus 123 the following formula @IF((F25+H25)=0,"|--","") in the first
cell of each row in a print range would place the pipe symbol in that cell.
Any rows with the symbol would not print when the range was printed. This is
very helpful when you don't need to print rows that do not contain data.
Such as inventory items with no qunatities. How can I get Excel to do the
same thing. Some of my spread sheets may have hundreds of rows but I only
need to print those with data. Sorting first is not an option.

Not as in Lotus

How about selecting the column with the missing data, taking to menu options
EditGo to...Special...Blanks. Now without touching anything go to
FormatRowsHide

The rows will get hidden and will not print. To reverse you can select the
rows and go to FormatRowsunhide

Also you could consider DataAutofilter and filter by 'Blanks' on the blank
column. This can also be saved as a 'Custom views...' under Viewcustom
Views...

Plenty of ways!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Luapremrub" wrote in message
...
In Lotus 123 the following formula @IF((F25+H25)=0,"|--","") in the first
cell of each row in a print range would place the pipe symbol in that
cell.
Any rows with the symbol would not print when the range was printed. This
is
very helpful when you don't need to print rows that do not contain data.
Such as inventory items with no qunatities. How can I get Excel to do the
same thing. Some of my spread sheets may have hundreds of rows but I only
need to print those with data. Sorting first is not an option.