How do you freeze panes on Microsoft Excel?

Answer 1

You will find it in the Window Menu. Wherever the cursor is when you Freeze Panes, everything above and left of the cursor will be frozen. So if you want Row 1 and Column A to be permanently shown when you scroll down or across, click on cell B2. Row 1 is above it and Column A is to the left of it. Now go to the Window menu and choose Freeze Panes. Row 1 and Column A will now be frozen. To unfreeze the panes, go to the Window menu and Unfreeze Panes will be there now, because the sheet has frozen panes.
Click in the cell below and to the right of the panes you want to freeze, then click on the window menu and select 'Freeze Panes'.
As you scroll down or across a spreadsheet, rows or columns disappear off the edge of the screen. Sometimes you will want to be able to see the first rows or columns, because they usually contain important headings or data in them, that will help identify the rest of the data you are looking at. If you have lots of columns of numbers, when you scroll down and their headings disappear off the screen, you may not be sure which column is which and what are the values they contain. So what you can do is use the Freeze Panes option to show some columns and rows permanently on the screen. Wherever the active cell is, all the rows above it and the columns to the left of it will remain on the screen, even when you start scrolling. So if you wanted column A and row 1 to remain on the screen, you would put make B3 the active cell and then use the Freeze Panes. You can unfreeze them at any time, as the menu option will have changed to Unfreeze Panes when next you open it