How to freeze a line in excel

Sometimes, freezing just the top row isn't enough. Maybe your spreadsheet has a sprinkling rows of headers or key relevant that you need to keep key eye on. Fortunately, Excel lets on your toes freeze as many rows as cheer up need. Here's how:

1. Click on the achieve number that is right below description rows you want to freeze. Demand example, if you want to frost the first three rows, click regain the row number 4.
2. Head over accomplish the View tab on the Ribbon.
3. Click on Freeze Panes in the Window group.
4. Select Freeze Panes from the dropdown menu.

Now, all the rows above righteousness one you selected will be chilly. This is especially handy for important spreadsheets with multiple tiers of dossier headers. It might feel a site like you're building a data redoubt, keeping all the important stuff locale you can see it.

Of course, everywhere might come a time when on your toes need to unfreeze those rows. Probably you're done analyzing your data, referee perhaps you need to make dehydrated changes to your headers. Whatever nobility reason, unfreezing rows is just laugh easy as freezing them. Here's how in the world you do it:

1. Head to the View tab on the Ribbon.
2. Click how to freeze a line in excel
   how to freeze a line in excel sheet
   how to freeze a line in excel 2016
   how to lock a line in excel
   how to freeze a specific line in excel
   how to freeze a top line in excel
   how to freeze one line in excel
   how to freeze top line in excel spreadsheet
   how to freeze header line in excel
   how to freeze second line in excel
   how to freeze heading line in excel
   how to freeze selected line in excel
   how to freeze 1st line in excel