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.

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

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 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 ...

Thin lines will separate the frozen columns and rows from the unfrozen columns and rows. Steps to unfreeze cells Click on the View tab Select Freeze Panes Select Unfreeze Panes from the dropdown menu.

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 ...

Steps to freeze multiple rows in Excel Click on the cell in column A of the row immediately below the rows you want to lock. For example, if you wish to lock rows 1 and 2, you should click on Cell A3.

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 ...

It's often useful to freeze header rows or columns in Excel while navigating through a spreadsheet. Otherwise, you may need to repeatedly scroll to the top or left of the sheet to remember what's ...