How do I lock row 1 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 lock the top row in Excel so it doesn’t sort?

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 lock the first row in Excel 2010?

To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu.

How do I freeze first column and first row in Excel?

To freeze the top row or first column:

1. From the View tab, Windows Group, click the Freeze Panes drop down arrow.
2. Select either Freeze Top Row or Freeze First Column.
3. Excel inserts a thin line to show you where the frozen pane begins.

How do I protect a row in Excel?

Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet. Right click and choose Format cells. 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.

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

Note:

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

Why the freeze first column option is used in Excel?

The Excel Freeze Panes tool allows you to lock your column and/or row headings so that, when you scroll down or over to view the rest of your sheet, the first column and/or top row remain on the screen. The following steps show you how to use freeze panes in Excel 2016, 2013, 2010, or 2007.

How do I freeze multiple rows in Excel 2021?

Select “Freeze Top Row.” Scrolling down the page will keep the top row in place for the entirety of the spreadsheet….Freeze Multiple Rows in Excel

1. Click on the first cell in the column below the rows you want to freeze.
2. Select the “View” tab.
3. Click the “Freeze Panes” box, then choose “Freeze Panes” from the list.

How do I freeze both the top row and column?

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 freeze row and first column?

To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the VIEW tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu.

How do I lock specific cells?

Lock cells to protect them

1. Select the cells you want to lock.
2. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
3. On the Protection tab, select the Locked check box, and then click OK to close the popup.

How to keep first row always visible in Excel?

1) Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters. 2) In the menu, click “View.” 3) In the ribbon, click “Freeze Panes” and then click “Freeze Top Row.”

How do you freeze first row in Excel?

Locking a row below the first row follows similar steps. First, select the cell in column A below the last row to freeze. Click the “View” tab, click “Freeze Panes,” then click “Freeze Panes” from the drop-down menu. All rows above the selected cell will now freeze.

How do you lock rows together in Excel?

To lock/freeze the rows/columns, just follow these steps: Select the row right below the row or rows you want to freeze. Go to the View tab Select the Freeze Panes command and choose “Freeze Panes.”. The frozen rows will stay visible when you scroll down.

How do you find the last row in Excel?

Most of us may be consider of locating the last cell by pressing Ctrl +End keys to find the last row and column, but the shortcut key will not locate the accurate value cell if there are some cells that have formatting below the data range. So here, please use the following VBA code: