How to Freeze The First And Last Row in Excel?

Date:2021-1-25 Author:Sandra

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.

How to Freeze The First And Last Row in Excel?
How to Freeze The First And Last Row in Excel?

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

How to Freeze The First And Last Row in Excel?
How to Freeze The First And Last Row in Excel?

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 First And Last Row in Excel?

How to Freeze the Last Row?

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

How to Freeze The First And Last Row in Excel?

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.

How to Freeze The First And Last Row in Excel?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *