It’s by using the ‘Split Option’ to freeze and separate your rows into different worksheets. Now, there’s another way on how to do this. Locate your Tool Bar and choose Layout Menu.ĭrag down the menu and click Unfreeze panes. To unlock the panes that were once grouped together, follow these steps: To do such, follow these simple steps:Īrranging your Excel spreadsheet to its default setting is easy.

Users also have the option to lock in view the first column or the first row of the spreadsheet. Notice that A1 to A6 are now locked and a grey line separates these rows from the rest of the rows in your Spreadsheet. A grey line separates locked rows from the unlocked ones.įor instance, one would like to lock A1 to A6 of their Spreadsheet. Now, all the rows above are locked and stay in place even when scrolling. Notice that columns A to C are now locked and a grey line separates these columns from the rest of the columns in your Spreadsheet.Ĭhoose the cell below the row that you want to freeze. A grey line separates locked columns from the unlocked ones.įor instance, one would like to lock A to C of their Spreadsheet.

Now, all the specific columns are locked and stay in place as you navigate your Spreadsheet. This lets you highlight the columns that you want to freeze.Ĭlick on the Freeze Panes icon and select Freeze Panes from the menu. The first row is locked in place during Spreadsheet navigation. The first column is locked in place during Spreadsheet navigation.

Freeze Panes gives users the option to freeze specific columns or specific rows only.

Shut off freeze frame in excel