In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

To freeze a specific row, first, select the row immediately below the one you want to freeze. For example, if your headers occupy rows 1 and 2, select row 3 to keep the top two rows visible.

Select the row that needs to be frozen, click the Freeze Pane drop-down once again, and choose Freeze First Column.

If you have ever used Excel to review a large database, you know how useful it is to be able to freeze cells, such as the top row or the first column.

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.