Home » Questions » Computers [ Ask a new question ]

Fixing the first row as sortable title in Excel 2007

Fixing the first row as sortable title in Excel 2007

I know this is super easy, I just couldn't find it.

Asked by: Guest | Views: 239
Total answers/comments: 2
Guest [Entry]

"To fix the first row select it and then select ""Freeze Panes"" from the ""View"" ribbon.

To get sorting and filtering select the first row and then ""Filter"" from the ""Data"" ribbon."
Guest [Entry]

"To fix the first row ;

First click Window → Split
Move splitter bar wherever you want to split
Click Window → Freeze panes (if you want to freeze it)"