I cannot get the freeze first row function to work, even though I found it under “Tools - Customise”
I cannot get the freeze first row function to work, even though I found it under "Tools - Customise"
If you want to freeze just the first row, simply select View |Freeze Cells |Freeze First Row.
You can undo this by unchecking View |Freeze Rows and Columns.
If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. That will help other people with the same question.
In case you need clarification, edit your question (don’t use an answer) or comment the relevant answer.
Active cell must be in row 2.
Edit: My comment don’t applies for @robleyd answer (his answer is correct), but when choosing menu View - Freeze Rows and Columns.