Freeze Panes

%3CLINGO-SUB%20id%3D%22lingo-sub-2422202%22%20slang%3D%22en-US%22%3EFreeze%20Panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2422202%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20top%20row%20froze%20and%20when%20I%20sort%20the%20top%20row%20disappears%20and%20the%20first%20line%20is%20frozen.%26nbsp%3B%20This%20just%20started%2C%20it%20was%20fine%20on%20Friday.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2422202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2422315%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20Panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2422315%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1072888%22%20target%3D%22_blank%22%3E%40Dawn_Harris%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EInstead%20of%20just%20clicking%20the%20%3CSTRONG%3ESort%20A%20to%20Z%3C%2FSTRONG%3E%20or%20%3CSTRONG%3ESort%20Z%20to%20A%3C%2FSTRONG%3E%20button%2C%20click%20%3CSTRONG%3ESort%20%26amp%3B%20Filter%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3ECustom%20Sort...%3C%2FSTRONG%3E%20on%20the%20%3CSTRONG%3EHome%3C%2FSTRONG%3E%20tab%20of%20the%20ribbon%2C%20or%20%3CSTRONG%3ESort%3C%2FSTRONG%3E%20on%20the%20%3CSTRONG%3EData%3C%2FSTRONG%3E%20tab%20of%20the%20ribbon.%20Make%20sure%20that%20you%20tick%20the%20check%20box%20%3CSTRONG%3EMy%20data%20has%20headers%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have top row froze and when I sort the top row disappears and the first line is frozen.  This just started, it was fine on Friday.

3 Replies

@Dawn_Harris 

Instead of just clicking the Sort A to Z or Sort Z to A button, click Sort & Filter > Custom Sort... on the Home tab of the ribbon, or Sort on the Data tab of the ribbon. Make sure that you tick the check box My data has headers.

That kept my frozen pane but did not sort my data.
That did work. Thank You