How to lock cells in Excel (a cell, cells with formula, sheet, unlock)
In the process of editing a table with Excel, if you want to some cells cann't be modified, you can lock them. Excel locks cells flexibly, one at a time, multiple (both contiguous and discontiguous), headers, rows, columns, and all cells that have formulas only. However, you cann't lock cells only using Lock Cell, and the Protect sheet feature must be enabled, and when enabled, you can set a password and allow items to be modified.
Chapters:
0:00 How to lock cells in Excel?
0:52 How to lock certain cells in Excel?
1:43 How to lock formula cells in Excel?
2:25 How to lock sheet in Excel?
2:40 How to unlock cells in Excel?
Description:
How to lock cells in Excel (a cell, cells with formula, sheet, unlock)
One. How to lock cells in Excel?
(1) How to lock a cell in Excel? (How do you lock a cell in Excel?)
1. Press "Ctrl + A" to select the whole table (or click the Arrow in the upper left corner of the table to select), right-click, select "Format Cells" in the pop-up menu, select the "Protection" tab in the opening window, click "Locked" to remove the check in front of it, click "OK"; Select the cell you want to lock (B2), open the "Format Cells" window again and select the "Protection" tab, check "Locked", click "OK"; Then, click "Format" in the "Styles" group in the "Home" tab, select "Protect Sheet" in the pop-up options, click "OK", then cell B2 is locked, at this time, double-clicking B2 will pop up a prompt window prompting B2 has been protected and cannot be modified, and then double-click other cells, you can also modify.
2. Note: Check "Locked" for all cells by default in Excel, so before locking a cell, you need to uncheck "Locked" for all cells, then lock the cell you want to lock, and finally turn on "Protect Sheet", then successfully lock a cell. When you open the Protect Sheet window, you can set a password, which can be set based on your security needs.
(2) Lock multiple cells (How to lock certain cells in Excel?)
1. Like "lock one cell", first unlock all cells, the operation steps are: Press "Ctrl + A" to Select All cells → Right click → Format cells → "Protection" tab → Do not check "Locked". Then select the cells you want to lock, for example, select a contiguous cell, then hold down Alt and click the discontiguous cells you want to select.
2. Right-click on the selected cells, select "Format Cells", select the "Protection" tab in the window that opens, and check "Locked".
3. After clicking "OK", click "Format", select "Protect Sheet" in the pop-up options, and enter the password in the opening window; In addition, there is a list that allows modification after locking the cell, which can be rounded up as needed.
4. Click "OK", enter the password again, then all the selected cells are locked, double-click them to modify, the same will pop up a prompt window that is not allowed to change.
(3) Excel lock rows and columns (How to lock a row in Excel?)
The method is the same as locking multiple cells, when locking rows, you only need to select the row you want to lock (it can be a table header, any row or more rows); Similarly, when locking columns, select the columns you want to lock.
Two. How to lock formula cells in Excel? (How to lock a formula cell in Excel?)
1. Like locking cells, first uncheck the "locked" for all cells; Then select all cells with formulas, the method is: press "Ctrl + G" on your keyboard, open the "Go to" window, click "Special", open the window, check "Formulas", click "OK", then select all cells with formulas; Then check "Locked" for the selected cells; Finally, enable "Protect Sheet" by: click "Format", select "Protect Sheet" in the pop-up options, click "OK" in the opened window, then all cells with formulas are locked, and when you click them, the protected prompt window will also pop up.
2. The key here is to use "Special" to select all cells with formulas, and other operations are the same as locking cells.
Three. How to lock sheet in Excel?
Just enable "Protect Sheet", then all cells of the whole table are locked, this is only the last step in the above operation, if it is not clear, see the above operation demonstration.
Four. How to unlock cells in Excel?
Click "Format" in the "Styles" group in the "Home" tab, select "Unprotect Sheet" in the pop-up options, ok.
Watch video How to lock cells in Excel (a cell, cells with formula, sheet, unlock) online without registration, duration hours minute second in high quality. This video was added by user Loinsure 09 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 779 once and liked it 2 people.