print selected cells in Excel

D

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)
 
G

Gord Dibben

Use autofilter to hide blank rows.

Print the resulting view.


Gord Dibben MS Excel MVP
 
G

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
 
Top