Pivot Table Format

[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

 

[Debra Dalgleish]

Select a cell in the Pivot Table
From the PivotTable toolbar, choose PivotTable>Select>Enable Selection

 

[Mike Damken]

Thanks. This did the trick.

-----Original Message-----
Select a cell in the Pivot Table
From the PivotTable toolbar, choose

PivotTable>Select>Enable Selection