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 …

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.

See Protect a worksheet or Protect a workbook. Tip: It's a best practice to unlock any cells that you may want to change before you protect a worksheet or a workbook, but you can also unlock them after …

If you scroll down your worksheet but always see the same top rows, they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows.

To unhide column A, right-click the column B header or label and pick Unhide Columns. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows.

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 …

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 …

When you want to reveal cells that may reside in hidden rows or columns, it can be difficult to locate them. The approach is to first select all visible cells in the worksheet, which also will reveal hidden …

Click the Filter button next to the column heading, and then click Clear Filter from <"Column Name">. For example, the figure below depicts an example of clearing the filter from the Country column.

Click OK. To unlock cells You may need to temporarily turn off protection so that you can unlock cells. On the Review tab, click Unprotect Sheet or Unprotect Workbook. Then type the password. Select …