I'm building a pivot table in Excel Online. I'd like it to be in a tabular layout. Following the instructions I see online say to go to pivot table settings, but I can't see how to make the change to tabular settings. Below is an example of my current table and the "Pivot Table Settings" menu. Also a picture below that shows an example of what I'd like to achieve.
Asked
Active
Viewed 5,497 times
1 Answers
1
Not all settings for a pivot table are available in Excel Online. The Tabular Form report layout is currently only available in Excel for Desktop, so you need to open the file in the desktop version to use that setting. After that, Excel Online can display the pivot table, but you cannot set that option in Excel Online.
Keep in mind that new features are added to Excel online all the time and this answer may be out of date soon.
teylyn
- 23,615