How do I lock the top row in Excel when scrolling?

How do I lock the top row in Excel when scrolling?

To freeze the top row or first column: From the View tab, Windows Group, click the Freeze Panes drop down arrow. Select either Freeze Top Row or Freeze First Column.

How do I freeze the top row in Excel 2020?

On the View tab, click Normal.

1. Freeze the top row. On the View tab, click Freeze Top Row.
2. Freeze the first column. If you’d rather freeze the leftmost column instead, on the View tab, click Freeze First Column.
3. Freeze as many rows or columns as you want. Want to freeze multiple rows and/or columns?

How do you keep the top row in Excel on each page?

Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].

How do I pin a row in Excel?

Freeze rows or columns

1. To lock one row only, choose the View tab, and then click Freeze Top Row.
2. To lock one column only, choose the View tab, and then click Freeze First Column.
3. 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 the first two rows in Excel?

To freeze rows:

1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
2. Click the View tab on the Ribbon.
3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
4. The rows will be frozen in place, as indicated by the gray line.

How do I freeze panes on every page in Excel?

About This Article

1. Open your project in Excel.
2. Click the Page Layout tab.
3. Click Print Tiles.
4. Enter the rows that you want to print on each page next to “Rows to repeat at top.”
5. Enter the columns that you want to print on each page next to “Columns to repeat at left.”
6. Click Ok.

How do I lock a single row?

Select the “View” tab Similarly, if you’d like to lock the top row and the first column of your spreadsheet, place your cursor below the row you want to lock and to the right of the column you want to lock, then select the “View” tab followed by the “Freeze Panes” option.

How do I freeze the top row and column at the same time in Excel?

Freeze columns and rows

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

How do I lock certain rows in Excel?

Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.

Can only freeze top row in Excel?

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.

Why can I only freeze top row in Excel?

You can freeze only rows at the top and columns on the left side of the worksheet. You cannot freeze rows and columns in the middle of the worksheet. The Freeze Panes command is not available when you’re in cell editing mode (that is, you’re entering a formula or data in a cell) or when a worksheet is protected.

How do you lock the top row in Excel?

– Open the Worksheet you want to work on. – Select the “View” tab and navigate to “Freeze Panes.” – Select “Freeze Top Row.”

How do you lock cells in Excel for scrolling?

– Open your Excel worksheet. – Click the View tab on the ribbon. – On the Freeze Panes button, click the small triangle in the lower right corner. You should get a new menu with your 3 options. – Click the option Freeze First Column. – Scroll across your sheet to make sure the left column stays fixed.

How to lock Excel row at top?

Click Page Layout > Print Titles. See screenshot:

How to make top row always stay visible in Excel?

The Freeze Top Row feature of Excel can freeze the top row in current active sheet and make this row always stay visible no matter how you scroll up and down the worksheet. 1. Stay in the worksheet you need to make top row always stay visible, then click View > Freeze Panes > Freeze Top Row. See screenshot: Then the top row of current worksheet is frozen and will always stay visible until you unfreeze it.