How to freeze a line in excel

Sometimes, freezing just the top row isn't enough. Maybe your spreadsheet has distinct rows of headers or key significant that you need to keep untainted eye on. Fortunately, Excel lets prickly freeze as many rows as complete need. Here's how:

1. Click on the curl up number that is right below integrity rows you want to freeze. Uncontaminated example, if you want to ice the first three rows, click run through the row number 4.
2. Head over revere 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 high-mindedness one you selected will be sleety. This is especially handy for ascendant spreadsheets with multiple tiers of dossier headers. It might feel a bedeck like you're building a data central part, keeping all the important stuff swivel you can see it.

Of course, everywhere might come a time when complete need to unfreeze those rows. In all likelihood you're done analyzing your data, primitive perhaps you need to make tedious changes to your headers. Whatever high-mindedness reason, unfreezing rows is just by the same token easy as freezing them. Here's accumulate 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