When our Excel table is very long, we usually freeze the header row for browsing convenience. Freezing the header row is actually very simple, and people who often use Excel can do it. But what if you want to freeze the first and last rows at the same time?

How to Freeze the Top Row?

Go to View in the toolbar and click on the arrow behind Freeze Panes. Choose Freeze Top Rows in the list.

You can also try another way. Select any cell in this sheet and press Ctrl and T to create tables.

Although this method does not freeze the top row, you can still see the content of the top row while you browse the table.

How to Freeze the Last Row?

Select the last row and go to view click on Split.

This step allows you to divide the window into different panes that each scroll separately. So you can just scroll the top part and could see the last row in the second part.