Pivot report without the drop downs

T

Ty

I created my Excel 2007 Pivot table with the data I need. Now, I want
to remove the Report Filter Drop Down showing lot more information
than my peers or superiors need to see or even try to view.

The same is true for the Rows Labels and Column Labels with the drop
down.

I figured out how to remove the plus signs by using the "Show/Hide" on
the Options on the Ribbon.

I tried the copy and paste but for some reason I can only do .txt or
object. There is no paste special. Then the format is not the same.

Do anyone have an answer for this problem?

Thanks a million,
Ty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables drag & drop 2
hide the 'drop page fields here' from a pivotchart 1
Pivot table drop downs stop working 0
Displaying Report Filter Used on Pivot Chart 0
SUM & OFFSET & PIVOT TABLE?? 0
Pivot Table Drop Downs 1
Link Drop Down with Pivot Table 2
Position DataLables on a pivot pie chart realative to their Points 0

Top