Jun 07 2021 07:39 AM
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.
Jun 07 2021 08:08 AM
SolutionInstead 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.
Jun 07 2021 08:08 AM
SolutionInstead 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.