Hi,

Click on the immediate cell to the right of the Grant Total (for columns)
cell, and press Auto Filter. This will get the auto filter drop down on the
Grand Total column. Now filter out the Blanks.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"DogEatDog World" wrote in
message ...
Problem is that you can't simply filter out some data field because in
some
row fields they have values and at some they don't. So what I essentialy
need
is for those rows to exist when they contain data and to be erased when
not
containing data.I hope that it+s possible in excel 2007