Click anywhere in the pivot table.
Activate the Design tab of the ribbon, to the right of the PivotTable Analyze tab.
In the Layout group, select Show in Tabular Form in the Report Layout drop-down.
How to set pivot table borders in Excel 2024
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 18%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
George Sinkinson
20
Reputation points
I am trying to adjust a pivot table created in Excel 2024
to match a similar pivot table created in Excel 2021.
I've looked at a lot of clips but am still unable to figure
out how to do it.
I would like to show the borders around each of the column groupings.
This the 2021 version:
Can you tell me how to do it, or point me to a really good 'How-To' tutorial?
I've tried opening the 2021 version in 2024, but the expand/collapse buttons behave in a weird fashion and wind up hiding all the rows.
Microsoft 365 and Office | Excel | For home | Windows
2 answers
Sort by: Most helpful
-
HansV 460.7K Reputation points MVP Volunteer Moderator2025-08-11T19:08:01.6166667+00:00 -
George Sinkinson 20 Reputation points
2025-08-12T18:32:07.8433333+00:00 Using Show in Tabular Form in the Report Layout has no effect.
I can get vertical lines using Pivot Table Styles, but what I want is Horizontal lines whenever the Group changes, but without changing the Type column.
Sign in to comment -
-
George Sinkinson 20 Reputation points
2025-08-12T18:28:58.61+00:00 This is what I get using Pivot Table Styles
-
HansV 460.7K Reputation points MVP Volunteer Moderator
2025-08-12T18:55:42.51+00:00 Hmm... I don't have 2024 myself; I hope that someone who does will reply.
Sign in to comment -