print selected cells in Excel

[Dee]

How do I print selected cells only from my Excel Worksheet (Excel 2003)?

How do I print only active text lines and none of the add'l blank lines on
the Excel Worksheet? I don't want to just print selected pages, but ONLY
lines with text. (Excel 2003)

 

[Gord Dibben]

Use autofilter to hide blank rows.

Print the resulting view.


Gord Dibben MS Excel MVP

 

[Dee]

How do I access/use AutoFilter? And how do I print JUST selected cells?

 

[Gord Dibben]

Data>Filter>Autofilter...................this info can be found in Help

Filter for non-blank cells.

I am assuming that "lines" means rows.


Gord