How do I make the first row in Excel always visible?

Freeze columns and rows

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
Select View > Freeze Panes > Freeze Panes.

How do I keep labels on top of Excel?

Freeze Panes

Highlight the row below the rows you wish to keep visible.
In Excel 2010 and 2007, from the View tab on the Ribbon, select Freeze Panes from the “Window” group. In Excel 2011, select the Window menu, and then Freeze Panes.

How do I lock a row in Excel and keep it?

To lock one row only, choose the View tab, and then click Freeze Top Row. To lock one column only, choose the View tab, and then click Freeze First Column. To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes.

How do I freeze a label in Excel?

Click on View on the Ribbon and select Freeze Panes. Now click Freeze Top Row. If you want to Freeze other rows as well just highlight them before choosing Freeze Panes. That’s it!

How do you lock rows and columns in Excel?

To lock several rows and columns at a time, select a cell below the last row and to the right of the last column you want to freeze. For example, to freeze the top row and first column , select cell B2, go to the View tab and click Freeze Panes under Freeze Panes:

How to lock specific columns always visible in a sheet?

For example, if you want to lock the first two columns and keep them always visible, you just need to select the adjacent column (the third one), and then click View > Freeze Panes > Freeze Panes. Now the first two columns are always visible while scrolling to right. Freeze top row and Freeze first column

How to freeze the first row in Excel?

On the View tab, click Freeze Top Row. When you do this, the border under row 1 is a little darker than other borders, meaning that the row above it is frozen. If you’d rather freeze the leftmost column instead, on the View tab, click Freeze First Column.

Is there a way to keep rows visible in Excel?

When you click “Freeze panes”, it freezes all rows above the selected cell and all columns to the left of it. Just select the cell to the right of the column you want to keep visible, and right below the row before clicking the button. E.g. select cell B2 to always have row 1 and column A on the screen.