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

maacmaac wrote:

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

--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959
View this thread: http://www.excelforum.com/showthread...hreadid=491847

--

Dave Peterson