Automagic Subtotals in Pivot Table
Hi Duane,
Am Fri, 7 May 2021 14:42:07 -0500 schrieb dpb:
This isn't in the PivotTable but in the data range of the PT when I
tried turning it into a table per a suggestion seen on internet.
I turned it back into a regular range from the table and the banded rows
artifact remained. I guess I could try going back to the table again
and seeing if there's some control there.
I can just revert back to the previously saved version; it's not a
terribly large number of modifications I had made so it's not a
disaster, just inconvenience.
when you right click on as table formatted data = Convert to range you
will get a normal table. But the colors and the borders remain.
You must select the whole range = no fill and no border.
Regards
Claus B.
--
Windows10
Microsoft 365 for business
|