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.
Unfreeze locked panes - Microsoft Support
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.
Unhide the first column or row in a worksheet - Microsoft Support
If you don’t see the first column (column A) or row (row 1) in your worksheet, it might be hidden. Here’s how to unhide it. In this picture column A and row 1 are hidden. 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.
Protect a worksheet - Microsoft Support
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. Step 1: Unlock any cells that needs to be editable. In your Excel file, select the worksheet tab that you want to protect.
Lock cells to protect them - Microsoft Support
Before you enabled password protection, you can unlock some cells in the workbook. Once you are done with your changes, you can lock these cells. Follow these steps to lock cells in a worksheet:
Hide or show rows or columns - Microsoft Support
How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.
Split panes to lock rows or columns in separate worksheet areas
You can also split on both a row and a column. by selecting the cell below and to the right of where you want the split—then click Split. In the figure below—because D5 was chosen—columns to its left (A-C) and rows above it (1-4) are frozen by the split.
Protect controls and linked cells on a worksheet - Microsoft Support
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 modifying the current value. To unlock the cell: On the Home tab, in the Cells group, click Format, and then click Format Control.
Can’t edit certain cells in a protected worksheet in Excel for Mac
If a Microsoft Excel worksheet or workbook is protected, and the option to restrict editing permissions to certain users is selected for a range of cells, you can’t edit those cells in Excel for Mac. Cause. The option to let only certain users edit …
You are unable to select unprotected cells in Excel
Unlock the cells to provide access to a range of cells instead of clicking to select the Allow Users to Edit Rangescheck box. To do so, follow these steps: Start Excel, open your workbook, and then select the range that you want to allow access to.