You could add a column to the table, and use it to count the number of
jobs that have an entry in that row.

For example, in cell M2, enter: =IF(COUNTA(B2:L2),"Yes","No")
Copy the formula down to the last row of data.
Then, filter column M for Yes or No.

gmr7 wrote:
I have a spreadsheet with numerous columns (different job #'s), and under
uner job is a list of supplies needed. Is there any way to automatically
filter out blank cells of all the columns at the same time?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html