Freeze Top Row Excel. Excel freeze panes option is used to lock row or column headings. If your headings take up more than a single row or you want to compare data in a couple of the top rows to elsewhere in the spreadsheet you can freeze multiple rows in a similar way.
What is the shortcut key to freeze multiple rows in excel. Register to reply 07 09 2015 1101 am 2. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
Check the left hand side of the excel spreadsheet.
Alt w f r. The freeze option only allows you to freeze column a or row 1 from the menu bar. After clicking on the freeze panes option you need to click on the freeze top row option. To freeze the top row.