To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
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 . To lock multiple rows (starting with row 1 ), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes.
How to lock more than one column in a sheet?
If you want to lock more than one column in a sheet, proceed in this way: 1 Select the column to the right of the last column you want to freeze. For example, if you want to freeze the first 3 2 And now, follow the already familiar path, i. E View tab > Freeze panes > and again Freeze panes.
What happens when you lock cells in Excel?
You can lock cells in Excel if you want to protect cells from being edited. In this example, we will lock cell A2. Before you start: by default, all cells are locked. However, locking cells has no effect until you protect the worksheet. So when you protect a worksheet, all your cells (=worksheet) will be locked.
So choose the formula cell and then tap on one of the cell reference showing in the formula bar and after that press the F4 key. Now you will see that the cell reference selected by you is now locked. Perform the procedure to lock other cell references of formula.
One answer is, If you want to lock cells or protect specific areas, click Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet. Need more help ?
How do I enable some cell editing while leaving other cells locked?
To enable some cell editing, while leaving other cells locked, it’s possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet. Lock only specific cells and ranges in a protected worksheet.
Is there a way to lock the heading rows in place?
If you want to scroll down the worksheet, and lock the heading rows in place, so they’re always visible, you can use the Freeze Panes command. Be careful though, or you might end up with hidden rows that you can’t get to.