Forum Discussion
Expand Pivot Table Column labels vertically / downwards
As we know we can expand/collapse Row Headers or Column Headers in Pivot Tables to reveal details. When we expand column headers, it expands rightwards. My objective is to make it expand downwards (v...
sohailzamani I dare to say that this is just how collapsing/expanding works in pivot tables. Perhaps a silly suggestion, but why not use the column headers as row headers in stead? The attached workbook demonstrates what I mean, although I don't know if this is similar to your actual pivot table.
- Great thanks for your kind response.
You are right that I can also make the column headers become the row headers but that’s what I just don’t want to have in my final results.
