PivotTable Tools -> Options/Design tabs

B

Bishop

How do I add these two tabs to a spreadsheet? I have 2 spreadsheets open.
One of them has the PivotTable Tools section which includes the Options tab
and the Design tab. The other spreadsheet doesn't have these. How do I get
them on there?
 
A

Ashish Mathur

Hi,

In the other workbook, you have to be clicked anywhere inside the pivot
table. Then you will be able to see Options > Design

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

One note creating multiple tabs when collaborating? 0
Consolidation Table from Different Excel Tabs with Different Format 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Disable Outlook AutoCorrect with GPO 0
How to set tabs in work document 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Document Merge Formatting Issue 0
Using Styles In An Outline 0

Top