How to Unlock Cells in Excel When Scrolling (4 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes, we lock a certain cell or a range of cells in the Excel worksheet for our convenience. However, it could also happen accidentally or unintentionally. Whatever might be the reason is, we may need to unlock the cells again. In this article, we’ll show you the simple yet effective methods to Unlock Cells in Excel When Scrolling.


Download Practice Workbook

Download the following workbook to practice by yourself.


4 Easy Ways to Unlock Cells in Excel When Scrolling

1. Apply Freeze Panes Feature to Unlock Cells When Scrolling

Cells in several rows and columns get locked when we apply the Freeze Panes feature in Excel. This means that even if we move the Excel window, those rows and columns will be visible to us. We’ve applied the feature to the first 2 Columns and the first 4 Rows in the following pictures. Hence, they are on sight. In the given picture, the first 4 Rows are visible although we’ve scrolled down the window.

Apply Freeze Panes Feature to Unlock Cells When Scrolling

Here, in the below image, we’ve scrolled the window to the right side. But still, you can see the first 2 Columns.

Apply Freeze Panes Feature to Unlock Cells When Scrolling

Now, follow the steps below to unlock those cells.

STEPS:

  • First, go to the View tab and select the Freeze Panes drop-down.
  • Then, from there choose Unfreeze Panes.

  • As a result, the cells are now in unlocked form. You can scroll the window without any difficulties.

Read More: How to Lock Cells in Excel When Scrolling (2 Easy Ways)


2. Unlock Cells with Developer Tab in Excel

Again, we can lock a range of cells in our Excel worksheet. The range B4:C10 is locked in the picture demonstrated below. So, when we try to move to the cell below C10, the arrow keys won’t work.

Unlock Cells with Developer Tab in Excel

Therefore, learn the following steps for unlocking the cells.

STEPS:

  • Firstly, select the Developer tab.
  • Go to the Properties option from the Controls section.

Unlock Cells with Developer Tab in Excel

  • Consequently, the Properties dialog box will pop out.
  • In the ScrollArea box, remove the specified range of cells and keep it blank.

  • After that, close the box.
  • Lastly, you’ll be able to use the arrow keys to switch to other cells outside of the range B4:C10.

Read More: [Fixed!]: Arrow Keys Not Moving Between Cells in Excel (2 Ways)


Similar Readings


3. Excel VBA for Unlocking Specific Cells When Scrolling

In this method, we’ll apply the VBA code to Unlock Cells in Excel When Scrolling. In the given figure, the range B4:C10 is in a locked state. Hence, learn the process to perform the task.

Excel VBA for Unlocking Specific Cells When Scrolling

STEPS:

  • First of all, go to the Developer tab.
  • From the Code section, click on the Visual Basic.

Excel VBA for Unlocking Specific Cells When Scrolling

  • As a result, the VBA window will appear.
  • Now, select Insert ➤ Module.
  • Consequently, the Module box will emerge.
  • Next, copy the following code and paste it into the box.
Sub UnlockCells()
Worksheets("vba").ScrollArea = ""
End Sub

  • Then, save the file and press F5 to run the code.
  • Afterward, close the VBA window.
  • Finally, you can scroll to the other cells.

Read More: How to Lock Rows in Excel When Scrolling (4 Easy Methods)


4. Cells Unlocking with Excel On-Screen Keyboard

Additionally, the Scroll Lock feature in Excel locks a certain cell and we can’t move the selection of that cell to a different one. See the following picture for a better understanding. Here, even if we scroll down the windows using the arrow keys, the B4 cell selection doesn’t change. So, learn the below process to Unlock Cells in Excel When Scrolling.

Cells Unlocking with Excel On-Screen Keyboard

STEPS:

  • In the taskbar search, type On-Screen Keyboard at first.
  • Then, select the shown App.

Cells Unlocking with Excel On-Screen Keyboard

  • As a result, the keyboard will appear on the screen.
  • There, press ScrLk.

Cells Unlocking with Excel On-Screen Keyboard

  • At last, it’ll return the Excel window without any scroll locks.

Read More: How to Stop Arrow Keys from Scrolling in Excel (3 Easy Methods)


Conclusion

Henceforth, you will be able to Unlock Cells in Excel When Scrolling by following the above-described methods. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung Shine
Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo