The Quick & Easy Guide To Freezing Rows in Excel

Without freezing rows or columns in your Excel spreadsheet, every part strikes once you scroll by way of the web page, as proven within the gif under.

This will be irritating if you happen to can’t all the time see key information markers that specify what information is what, like column headers or row titles.

As with many issues on Excel, there are methods that show you how to make your spreadsheets simpler to learn, just like the freeze operate. In this submit, discover ways to freeze rows and columns in Excel to make sure that, once you scroll round, you’ll all the time have the ability to view the important thing information factors that matter most.

How to Freeze a Top Row in Excel

The picture under is the pattern information set I’ll use to run by way of the reasons on this piece.

1. To freeze the highest row in an Excel spreadsheet, navigate to the header toolbar and choose View, as proven within the picture under.

2. When the View menu choices seem, Click Freeze Top Row, outlined in purple within the picture under.  

Once chosen, every part within the high row of your Excel spreadsheet (row 1) will likely be frozen, and you'll scroll up and down in your spreadsheet, however the high rows received’t transfer, as proven within the gif under.

How to Freeze a Specific Row in Excel

While excel has native capabilities for freezing the highest row of an information set and the primary column of an information set, there are further steps to take to freeze different components of your information set that aren’t these two issues.

1. To freeze a selected row in Excel, choose the row quantity instantly beneath the one you need frozen. For this instance, I’m deciding on row quantity three to freeze row quantity two.

2. After deciding on your row, navigate to View within the header toolbar and choose Freeze Panes.

Once chosen, you’ll have the ability to scroll up and down by way of your spreadsheet and all the time see row two.

Note that utilizing the Freeze Panes operate to freeze rows additionally freezes each row above the row you initially chosen. For instance, within the gif under, I chosen row 5 which additionally freeze rows 4, three, two, and one.

How to Freeze the First Column in Excel

1. To freeze the primary column of your Excel spreadsheet (column A), navigate to the Excel header toolbar, choose View, and click on Freeze First Column.

Once chosen, you’ll have the ability to scroll aspect to aspect inside your sheet, and the primary column of your information set will all the time be seen, as proven within the picture under.

How to Freeze a Specific Column in Excel

1. If you need to freeze a selected column in excel, choose the column letter that's instantly subsequent to the column you need frozen and click on Freeze Panes within the View header menu.

Once chosen, you may scroll aspect to aspect by way of your complete information set and proceed to see these columns. In the gif under, I’ve frozen columns A and B.

Using the freeze operate in Excel makes your spreadsheets simpler to know, as you may make sure that essential rows and columns are all the time seen as you scroll by way of your information.