Select View tab, Windows Group, click Freeze Panes from the menu bar.
Select the cell in the upper-left corner of the range you want to remain scrollable.
To freeze horizontal and vertical headings simultaneously: How do I freeze vertical and horizontal panes in Excel 2016? To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes. To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes. How do I freeze multiple cells in Excel 2016?
How do I get out of page layout in Excel?Ĭlick the tab > From the “Workbook Views” group, click, if not already selected.
What to do when Excel is not responding?.
How do I freeze multiple rows in Excel 2010?.
When you have frozen rows and columns what happens when you press the Ctrl Home combination?.
How do I freeze rows and columns at the same time in Excel 365?.
How do I get rid of freeze panes in Excel?.
What is the shortcut to remove freeze in Excel?.
How do I freeze the top and bottom panes in Excel?.
What do you mean by freeze panes in Excel?.
What is the best practice for entering dates and times in Excel?.
What Allow quickly apply the content for one cell to another cell?.
What is the shortcut key to freeze rows and columns in Excel?.
How do I freeze rows and columns at the same time in Excel 2016?.
How do I freeze the first 3 columns in Excel?.
Where is the freeze pane button located?.
How do I freeze vertical and horizontal panes in Excel 2016?.