Forum Discussion

jerrvizu's avatar
jerrvizu
Copper Contributor
May 02, 2023

Pivot Tables

How can I make Pivot Tables with their own columns & rows within the same sheet? I can figure this out effortlessly on Apple Numbers but not on Excel, I just want to be able to have different size rows & columns without having to use Line Wrap or Auto Fit Widths.

 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    jerrvizu You can't. In Numbers each table sits in what you could call its own sheet with its own column and row labels. Excel just doesn't work that way.

Resources