remove the blank row shown in pivot table

**markDuffy** · 02-13-2013, 03:15 PM

Hi Guys

I have looked on the net to find out how to remove the blank row shown in pivot table. Lots of solutions but I can’t make them work. Would like one reliable for Excel 2010. I have popped up a sample.

Mark

**Ace_XL** · 02-13-2013, 03:20 PM

On the Row label filter..simply uncheck (blank)

**markDuffy** · 02-13-2013, 03:45 PM

Thanks for this much appreciated. But tell me what i can not find is how to get eh filter on the Row labels. Sorry to be so basic. Ah got it playing about. Its options and field headers. I have been searching for that for the past hour + and have even done a Heath Robinson with a = to grid. Thanks again.