Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am sure I used to be able to click on a row in a pivot table and it would select all the other rows (eg sub totals) so that I could format them. This no longer happens. Have I somehow changed a setting without realising? Any ideas please?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    On the Pivot table toolbar, click the PivotTable menu dropdown and choose Select. The last entry of that submenu is called "Enable Selection". I think that is the one you need.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    There are some options in the Pivot Table | Select submenu on the Pivot Table toolbar. If you turn on "Enable Selection", you can click just to the left of a row or button, or just above a column to select a part of the structure of the pivot table. You can also select the entire pivot table.

  4. #4
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='pieterse' post='768263' date='30-Mar-2009 14:44']On the Pivot table toolbar, click the PivotTable menu dropdown and choose Select. The last entry of that submenu is called "Enable Selection". I think that is the one you need.[/quote]

  5. #5
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Perfect! Thank you both SO MUCH.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •