
Lock or unlock specific areas of a protected worksheet
How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.
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 …
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 …
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
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 …
Restrict changes to files in Excel - Microsoft Support
You can use formatting and editing restrictions to prevent content reviewers from accidentally changing an Excel spreadsheet.
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 …
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 …
Turn off Scroll Lock - Microsoft Support
If Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.
Insert Picture in-cell in Excel - Microsoft Support
You can easily switch between the picture types and convert a picture that is floating over cells to a picture in a cell. When selecting a picture over cells and choosing Place in Cell, the picture …