Use DataAUtofilter to show the blanks, then delete all visible rows.

--
HTH

Bob Phillips

"ScaffoldingDepot" wrote in
message ...
I use a spreadsheet for taking orders on the phone. The spreadsheet has
all
of the items we carry listed on it. At the end of the sale I have to
delete
the columns that have no value in them so I can print the worksheet at a
size
that can be read. Is there a way to automatically delete those cells
without
having to select and delete them individually?