#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 217
Default PIVOT TABLES

Can anyone help me with highlighting the subtotals on a pivot table. I know
I am able to click sometimes and all subtotals are selected but I am not sure
what or how I do it. help.

Louise
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default PIVOT TABLES

Highlight the subtotals by scrolling to the left and clicking the subtotal
line on the left hand border of the table
--
Brevity is the soul of wit.


"Louise" wrote:

Can anyone help me with highlighting the subtotals on a pivot table. I know
I am able to click sometimes and all subtotals are selected but I am not sure
what or how I do it. help.

Louise

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 217
Default PIVOT TABLES

thank you. so simple.

"Dave F" wrote:

Highlight the subtotals by scrolling to the left and clicking the subtotal
line on the left hand border of the table
--
Brevity is the soul of wit.


"Louise" wrote:

Can anyone help me with highlighting the subtotals on a pivot table. I know
I am able to click sometimes and all subtotals are selected but I am not sure
what or how I do it. help.

Louise

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to create multiple Pivot tables at once havocdragon Excel Discussion (Misc queries) 3 July 27th 06 11:16 PM
#REF in Sheets that refer to Pivot Tables Will C. Excel Discussion (Misc queries) 1 June 2nd 06 08:54 PM
Refreshing Pivot Tables linked to Oracle Datasource [email protected] Excel Discussion (Misc queries) 0 April 25th 06 12:15 AM
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 03:50 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM


All times are GMT +1. The time now is 06:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"