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

L

Luapremrub

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.
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I print rows that go outside of the page without shrinking the text? 0
Need Help with a VBA subroutine 0
In Excel, how do I print the cell blocks as well as the data? 2
Printing multiple sheets... 1
After Macro runs, no cell activated - what am I missing? 2
Print Macro w/drop down list 1
Printing 1
When printing - ability to not print empty or $0 cells 1

Top