Have you tried using the AutoFilter feature in the Data menu?
Refer to in-built help if you're unfamiliar with it.
Rgds,
ScottO

"riponalong" wrote in message
...
| I'm trying to remove blank rows in an Microsoft Excel spreadsheet
printout.
| When using the spreadsheet and working horizontally with "IF"
statements, you
| can easily end up with lots of rows in a printout that are "False,"
thus the
| line isn't there to print. Is there a combination of functions or
arguments
| that I can use to eliminate the unwanted blank lines in the
printout?
|
| I appreciate any help anyone can be. Thanks in advance.
|
| Rick
|