How to lock cells in excel with password

If you are working on a shared workbook, you may want to protect all or some of the cells to prevent unwanted changes from other users. This is also valid if you’re going to send a report and you don’t want people modifying it or changing the file structure or the formulas.

That is why you must learn how to lock cells in Excel.

In this article, I’ll show you:

• How to lock all cells from an Excel worksheet
• How to lock specific cells only
• How to lock formula cells
• How to lock cells based on color
• How to lock cells using Kutools for Excel (a useful Excel add-in)

How to lock all cells in Excel

By default, all cells in an Excel spreadsheet are locked.

However, you can still edit them unless you protect the worksheet with a password. Once you set a password, the locked cells will no longer be editable unless you provide the password.

1.

How to lock cells in excel when scrolling

Select all the cells in the active Excel worksheet. You can do this either by using the CTRL + A shortcut or by pressing on the gray arrow from the upper left corner (above row 1 and to the left of column A).

2.

Right-click anywhere on the

how to lock certain cells in excel sheet

how to lock certain cells in excel without protecting sheet