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

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

The freeze panes feature is particularly useful for comparing data across distant rows or columns. For instance, to compare row 12 with row 87, select row 13 and activate 'Freeze Panes'.

Microsoft Office (From $129.99 at Best Buy) How to freeze columns in Excel 1. In an open spreadsheet, select "View" from the top menu bar and then hit "Freeze First Column." This will freeze column A.

Select the cell below the row you wish to freeze and next to the column you want to freeze. For example, to freeze row 1 and column A, you need to select cell B2.

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. It’s so handy because these two places are ...

If you want to keep your header row visible while you scroll up and down, freeze the top row in your spreadsheet with these easy steps: Go to “View” at the top menu Look for “Freeze Top Row,” a blue ...

Select the row that needs to be frozen, click the Freeze Pane drop-down once again, and choose Freeze First Column. If you want to freeze multiple rows, click a cell underneath the last row you ...

Steps to freeze a single row in Excel Click on the View tab on the top Menu bar. Select the Freeze Panes option. Select Freeze Top Row. You will notice that the frozen row will be highlighted with ...