Forum Discussion
Possible bug when freezing first row on a filtered table
A have created a table with the headers on the first row. With data in the table I set a filter on one of the columns. This hided row 2 and 3 of the sheet. Next I selected Freeze Top Row, After s...
Hi, I have tried to follow your steps and I can actually freeze only the labels row. Let's make sure we are doing the right procedure:
From the original full table, I uncheck the Transportation and Restaurant categories in the filter option. In that way, rows 2 and 3 are hided.
Then, I select for instance A1, to have "row 1" selected. Then I go to the View tab on the ribbon and I go to Freeze Panes and select "Freeze Top Row" option.
I get only row 1 as freezed.
Attaching your file again.
Martin
I set up my filter to keep only Education and Groceries.
I have Excel for MS 365 (Version 2404 Build 16.0.17531.20152) 64 bit.
I have Excel for MS 365 (Version 2404 Build 16.0.17531.20152) 64 bit.