Forum Discussion
Excel 2021 (Mac) - pivot tables - "Show items labels in tabular form"
Just purchased Office 2021 (Mac) - on the PC version for pivot tables - in the "Field Settings", under the "Layout & Print" tab, there is a "Show items labels in tabular form" - is this function available in the Mac version - I cannot find it?
If not is there anyway to accomplish the same via a different method on the Mac version
9 Replies
Boz-1 When inside a pivot table, the Design tab in MS365 contains the option you seek under the Report Layout icon. I guess it's the same in 2021.
- tks - but this changes the entire table, where as the option in the "Field Settings", under the tab "Layout & Print" changes a specific field, when selecting the "Show items labels in tabular form"
Boz-1 Don't know what you mean. Sorry. Can you show? Upload a screenshot of what you see on a PC.
