Lock or unlock specific areas of a protected worksheet
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 …
Lock cells to protect them in Excel - Microsoft Support
On the Home tab, in the Alignment group, select the Alignment Settings arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then select OK to close the …
Lock cells to protect them in Excel - Microsoft Support
On the Home tab, in the Alignment group, select the Alignment Settings arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then select OK to close the …
Protect a worksheet - Microsoft Support
To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password.
Freeze panes to lock rows and columns - Microsoft Support
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 …
Lock cells to protect them in Excel for Mac - Microsoft Support
To prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can lock cells and protect them. Locking cells takes two steps: adding the Lock formatting to the cells, …
Display or hide formulas - Microsoft Support
If you don't want the formulas hidden when the sheet is protected in the future, right-click the cells, and select Format Cells. On the Protection tab, clear the Hidden check box.
Set or clear a print area on a worksheet - Microsoft Support
A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed.
You are unable to select unprotected cells in Excel
Excel allows you to grant permissions to specific users and user groups to modify selected ranges within a protected worksheet. To make it easier to move through editable ranges, you can also disable the …
Protect controls and linked cells on a worksheet
On the Protection tab, select the Locked check box. If the control has a linked cell, unlock the cell so that the control can write to it, and then hide the cell so that a user cannot cause unexpected problems by …