ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   PIVOT TABLES (https://www.excelbanter.com/excel-worksheet-functions/105876-pivot-tables.html)

Louise

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

Dave F

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


Louise

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



All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com