Printing selected rows

M

maacmaac

I have an Excel Spreadsheet with ~40,000 rows. I only want to prin
rows in which there is a value in Column A. Is there a way to do thi
without having to do sort first? I do not want to change the format o
the document. Thanks for any help
 
D

Dave Peterson

Select column A.
data|filter|Autofilter
filter to show non-blanks
Print your stuff
data|filter|show all (to see everything)
 
Top