ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unhiding Pivot table rows (https://www.excelbanter.com/excel-discussion-misc-queries/186003-unhiding-pivot-table-rows.html)

Roger

Unhiding Pivot table rows
 
To Anyone:

Can you please tell me how to unhide Pivot tale rows.

Regards

Roger

Debra Dalgleish

Unhiding Pivot table rows
 
It depends on what's hidden, and how it was hidden.
Click on a dropdown list in the field button, and Show All
or
For all except the innermost Row or Column fields, right-click on the
field button, and click Group and Show Detail
Then, click Show Detail

Roger wrote:

Can you please tell me how to unhide Pivot tale rows.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:23 PM.

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