Open a spreadsheet with frozen rows or columns.

In our example below, when we scroll down the page, row 1 remains visible, while rows 2 and 3 are hidden. To test, scroll down or to the right in the spreadsheet. Select Freeze Top Row or Freeze First Column from the drop-down menu.ĭepending on your choice, the top row or the first column is now locked in place. In the View section, to the right, click Freeze Panes. Open an existing Excel spreadsheet or create a new one.Īt the top of the screen, click the View tab. The following sections show you how to use freeze panes in Microsoft Excel. To learn how to freeze and unfreeze panes, select your spreadsheet program from the list below and follow the instructions. For example, if you have categories in a header covering multiple data points, you may want those titles to follow the numbers as you scroll down so you don’t forget what data you’re viewing. Freezing a column or row (referred to as freeze panes in Microsoft Excel) in a spreadsheet program helps to keep them from moving as you navigate a workbook.

Freeze first two rows in excel