In Excel 2003, on the PivotTable toolbar, click the PivotTable button
Click Select, then click Enable Selection, to toggle from On to Off
In Excel 2007, on the Ribbon, click the Options tab under PivotTable Tools
In the Actions group, click Select, then click Enable Selection
David wrote:
When you use a pivot table and put subtotals in a field, you can change the
formatting on all of the same level subtotals by clicking on the left part of
the cell containing one subtotal (mouse turns into an arrow). Any idea how
to turn that feature on or off?
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com