To unlock columns, rows, or cells in Excel, follow these steps:
- Open the Excel spreadsheet and go to the View tab.
- Select the Protect Sheet button.
- In the drop-down menu, choose Unprotect Sheet.
How to Unlock Cells in Excel
If you are scrolling through the worksheet or the side, but a part remains locked, it is likely because you have chosen to lock cells at a certain point. To resolve this issue, select View and then Unprotect Sheet. You can also press CTRL+SHIFT+F or CTRL+1. After removing the Locked checkbox, go to the Protection tab in the Format Cells popup and click OK. This will unlock all cells when the worksheet is protected.
How to Unlock Columns in Excel
To unlock a column:
- Right-click on the column header and select Unhide Column. Alternatively, you can click on the lock icon below the column header.
- Click OK in the confirmation message.
How to Lock Only Certain Cells in Microsoft Excel
To lock rows and columns in Microsoft Excel:
- Select the cell immediately following the row or column you want to lock.
- Access the Protect Sheet menu by clicking on View and then Protect Sheet.
How to Disable Cell Scrolling in Excel
To enable cell scrolling, open Microsoft Excel. Scroll Lock is turned off by default. If you want to disable scroll lock, simply press the Scroll Lock button again.
How to Lock a Table in Word
To lock or unlock table header rows and columns in Microsoft Word:
- In the Format bar, select a table or a table element.
- Click on the Row Header or Column Header button.
- In the drop-down menu, select Lock Header Columns or Lock Header Rows.
How to Modify Protected Cells
Solution #2: Protect Excel Cells with a Password
Note: Choose the cell you want to modify.
- Select the Home tab.
- In the Cells section, choose Format and then Format Cells.
- Go to the Protection tab and select the Locked checkbox to remove the checkmark.
How to Restore Scroll Bars
To display scroll bars in Microsoft Word and Microsoft Excel for Windows:
- Click on File and then Options.
- Select the Display section in the Advanced tab.
- Choose Show Horizontal Scroll Bar or Show Vertical Scroll Bar and click OK.
Scroll Lock Key
The Scroll Lock key is a toggle key, similar to the Num Lock and Caps Lock keys, and it has an LED that shows when it is activated. It is primarily used in Microsoft Excel to scroll through the worksheet using the arrow keys.