Excel 2021 (Mac) - pivot tables - "Show items labels in tabular form"

Copper Contributor

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.

Screenshot 2022-01-29 at 18.17.00.png

 

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.

 

ok - how do I upload the screen shot?

@Riny_van_Eekelen 

On Windows that's here

image.png

Have no idea about Mac.

tks -that is the function I am looking for on the Mac version....

@Boz-1 See attached for the closest I can get on a Mac just now.

Screenshot 2022-01-29 at 20.03.27.png

tks - that is the same settings I am currently using - looks like without the PC function this may be the closest one can get to on the Mac Version...