In the Format Cells dialog box, select the Protection tab and uncheck the Locked box and then select OK. This unlocks all the cells on the worksheet when you protect the worksheet.

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 …

Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password.

If Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.

Note: By default, all cells have the Locked formatting unless you previously turned it off. If any cells should be unlocked, select them. Press + 1. Then click to clear the Locked check box so …

Sometimes, you might see a green triangle in the upper-left corner of a cell that contains a formula. Find out what this means and how to prevent this in Excel 2016 for Windows.

You can use formatting and editing restrictions to prevent content reviewers from accidentally changing an Excel spreadsheet.

How to protect an Excel file using a password to prevent unwanted access to your data.

For example, you may choose to encrypt a shared Excel file, as well as enable workbook and worksheet protection, while only using worksheet protection on a personal workbook just so …

When you draw, resize, or move a shape or other object in Excel, you can set it so that it will align or "snap” to the nearest intersection in the grid (even if the grid is not visible) or snap to other …