How Do I Keep Multiple Header Rows Visable When I Use Filters?
I Have a Microsoft 365 Excel Table with 4 Header Rows. When I Add Filters, All of the Header Rows Disappear. How Do I Keep Them Visible? 2 Answers Select the...
I have a Microsoft 365 Excel table with 4 header rows. When I add filters, all of the header rows disappear. How do I keep them visible?
2 Answers
Select the data starting on the bottom-most header.
In my tests, the header rows doesn't disappear no matter how I use filtering.
If this does not apply to your situation, lock these 4 header rows.
Select these rows, right-click, select the cell format and select Lock in Protect.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
