How to fix multiple lines in Excel

In an Excel spreadsheet with a long volume of information, containing multiple rows of columns, when you move your mouse down the bottom rows, the headlines are not displayed. In long tables, users need to keep the subject line fixed so that it is always displayed, even if you scroll down.

How to fix multiple lines in Excel Picture 1

Freeze a line on Excel

If you only need to fix the first row in Excel, on the View tab (1) , choose  Freeze Panes (2) => select Freeze Top Row (3) .

How to fix multiple lines in Excel Picture 2

Thus, the first row of the worksheet has been fixed. You drag your mouse down to the bottom line and you can still see the first line.

How to fix multiple lines in Excel Picture 3

Note:

The Freeze Top Row tool fixed the first row in the worksheet without counting hidden rows, so if you hide row 1, Freeze Top Row will understand row 2 as the first row of the worksheet. Consider the following example: Line 1 of Excel has been hidden.

How to fix multiple lines in Excel Picture 4

You freeze the row with the Freeze Top Row tool, Excel understands that line 2 will be the first row in the worksheet, and line 2 is fixed.

How to fix multiple lines in Excel Picture 5

Fixed multiple lines on Excel

If you want to have multiple lines fixed, you can do the following:

Place your cursor in the first cell of the line below the lines you want to freeze. For example, if you want to fix row 1 and row 2, you place your cursor in cell A3 (1) . On the View tab (2) , select  Freeze Panes (3) => select Freeze Panes (4) .

How to fix multiple lines in Excel Picture 6

The result is that line 1, line 2 are fixed.

How to fix multiple lines in Excel Picture 7

 How to permanently remove the subject line

To remove frozen lines, on the View tab (1) , select  Freeze Panes (2) => select Unfreeze Panes (3) .

How to fix multiple lines in Excel Picture 8

Above Software Tips showed you how to fix one or more first lines in Excel spreadsheets. Good luck!