Pivot Table Format

  • Thread starter Thread starter Mike Damken
  • Start date Start date
M

Mike Damken

My version of Excel 2002 SP3 does not allow me to format
the columns in my Pivot Table. When I drag my mouse over
the Column header in the Pivot Table it turns from
Pointer to Cross skipping the "Down Arrow" that I should
get. The Down Arrow allows me to select the entire
column for formatting. This is similar to placing your
maoue on the column header of the spreadsheet - the down
arrow selects the entire column and then you can format
it. Same thing is supposed to happen in the pivot table
when you go over the column headers.

Cannot find anything that would disable this feature.
Any help is appreciated.

BTW, I made a simple pivot table and tried it on two PCs
both with Excel 2002 SP3, works fine on one, but does not
work on mine....

Regards,

MikeD
 
Select a cell in the Pivot Table
From the PivotTable toolbar, choose PivotTable>Select>Enable Selection
 
Thanks. This did the trick.
-----Original Message-----
Select a cell in the Pivot Table
From the PivotTable toolbar, choose
Click to expand...
PivotTable>Select>Enable Selection
 
You must log in or register to reply here.

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

Excel 2003 - Can't format Pivot Table 1
Pivot table grand total location 1
Pivot Table Variance 2
Referencing a pivot tables Grand Totals Column 1
date filter in a pivot table 1
Excel 2007 pivot table source table 1
Select Pivot Table 1
Pivot Table Column Totals - XL2003 5

Back
Top