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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Edit>Go to...>Special...>Blanks. Now without touching anything go to
Format>Rows>Hide

The rows will get hidden and will not print. To reverse you can select the
rows and go to Format>Rows>unhide

Also you could consider Data>Autofilter and filter by 'Blanks' on the blank
column. This can also be saved as a 'Custom views...' under View>custom
Views...

Plenty of ways!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top