SOLVED

Freeze Panes

Copper 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
best response confirmed by allyreckerman (Microsoft)
Solution

@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
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@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.

View solution in original post