Im 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 isnt 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

Hide the rows (or columns) before printing.

Format Row Hide


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=498169

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
|