How to freeze top 2 rows in excel

Answer

Freezing rows in Excel keeps them visible while scrolling through the rest of the worksheet.

Steps to freeze the top 2 rows

1. Select the row immediately below the rows you want to freeze.

   • For freezing the top 2 rows, click on row 3.

2. Go to the View tab on the Excel ribbon.

3. Click on Freeze Panes in the Window group.

4. Choose Freeze Panes from the dropdown menu.

This action locks the first two rows. They remain visible while scrolling down through the worksheet.

Notes

• On Mac, the steps are the same: select row 3, go to Window → Freeze Panes → Freeze Panes.

• To unfreeze, go to View → Freeze Panes → Unfreeze Panes.

Example

If you have a table with headers in row 1 and a summary row in row 2, freezing these two rows allows you to scroll through data without losing sight of the headers and summary.

This ensures clarity in large datasets with hundreds of rows.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report