Grouping Dates in Pivottable Excel 2007

C

Christine K.

Hi,

I feel like an idiot but I have the instructions on how to do this... It
seems pretty self explanatory except that the first step says "On the Options
tab, in the Group group, click Group field".

I can't find this Options tab... and I don't see a Group group. I see an
Outline group under data that has the group and ungroup options... but
clearly I'm missing something! I am feeling a little nuts!

Can someone help steer me in the right direction?

Thanks...
 
T

Ted M H

The options tab is a contextual tab for pivot tables. Make sure your cursor
is inside the pivot table somewhere and both the options and design
contextual tabs will be there on the ribbon. Most likely you just have your
cursor positioned on cells that aren't part of the pivot table.
 

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

Grouping dates in pivot table 3
grouping multiple tables Excel 2007 3
Grouping Dates in Pivot Table 4
Grouping Rows in Excel 2007 2
HELP w/pivot table grouping (dates) 1
Excel option buttons 2
How do I freeze 2 top rows in Excel 2007 3
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) 1

Top