View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ranjit kurian Ranjit kurian is offline
external usenet poster
 
Posts: 83
Default Pivot table filter fields

copy the pivot filltered data to a new sheet, then delete the pivot sheet.

"vw" wrote:

I have a fairly simple pivot table with two filter fields. I would like the
filter fields to show the data selection boxes as they do now however, I
don't want the field labels to show up. Is there a way to eliminate the
labels and center the data fields over the rest of the pivot table data ?
thanks