How to lock cells in excel when scrolling

You can lock cells in Excel if you want to protect cells from being edited.

Lock All Cells

By default, all cells are locked.

However, locking cells has no effect until you protect the sheet.

1. Select all cells.

2. Right click, and then click Format Cells (or press CTRL + 1).

3. On the Protection tab, you can verify that all cells are locked by default.

4.

How to lock formulas in excel

Click OK or Cancel.

5. Protect the sheet.

All cells are locked now. To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. The password for the downloadable Excel file is "easy".

Lock Specific Cells

To lock specific cells in Excel, first unlock all cells.

Next, lock specific cells. Finally, protect the sheet.

1.

How to protect cells in excel without protecting sheet

Select all cells.

2. Right click, and then click Format Cells (or press CTRL + 1).

3. On the Protection tab, uncheck the Locked check box and click OK.

4. For example, select cell A1 and cell A2.

5.

Right click, and then click Format Cells (or press CTRL + 1).

6. On the Protection tab, check the Locked check box and click OK.

Again, lo

how to lock cells in excel shortcut

how to lock cells in excel without password