Exel online : format pivot table on tabular layout

Copper Contributor



I have a pivot table on Excel online and I would like to apply the tabular form, is it possible?

Thank you



2 Replies


Yes, although it's billed differently in Excel for the web.  Right-click your pivot and select 'show settings' to open the side panel menu:


Separate columns - tabular

Single column - compact



I might be dreaming but the tabular form does not look the same:



Infos are not on the same line..

this is insane..