How to Lock a Row in Excel for Easy Scrolling

août 07, 2022 Enregistrer un commentaire

This article illustrates how to lock rows in excel when scrolling. This is necessary when you need to keep the top rows always visible. You can lock single or multiple top rows as required. This article also shows how to lock multiple top rows and leftmost columns at the same time. The following picture highlights the purpose of this article. Have a quick look through the article to learn how to do that.

Download Practice Workbook

You can download the practice workbook from the download button below.

4 Ways to Lock Rows in Excel When Scrolling

Imagine you have the following dataset containing sales made by employees in different years.

Now, if you try to scroll down through the data, then you won't see the years in the top row visible anymore. This makes it a bit difficult to understand the data.

Follow the methods below to solve this issue.

1. Lock Top Row in Excel When Scrolling

First, you need to make sure that the row you want to lock is visible at the top. You can scroll up to do so.
Then select View >> Freeze Panes >> Freeze Top Row as shown in the picture below.

After that, the top row will not move when you start scrolling down.

If Row 10 for example, is visible at the top, then it will be locked instead. Moreover, you won't be able to see rows 1 to 9.

Read More: How to Turn On/Off Scroll Lock in Excel (2 Ways)

2. Freeze Multiple Top Rows in Excel

Now, assume you want to lock the top 5 rows. Then select row number 6 as shown below.

Then, select View >> Freeze Panes >> Freeze Panes as shown in the following picture.

After that, the top 5 rows won't move when you scroll down.

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

Similar Readings

How to Turn Off Scroll Lock in Excel
[Fixed!] Keyboard Arrow Keys Not Working in Excel (8 Quick Solutions)
How to Remove Scroll Lock in Excel (With Easy Steps)
Excel Not Scrolling with Arrow Keys (4 Suitable Solutions)
How to Repeat Rows in Excel When Scrolling (6 Suitable Ways)

3. Hide and Lock Top Rows in Excel

Alternatively, you can hide the top 4 rows as shown below.

You will see a solid green border at the top after hiding the rows. Now, row 5 is visible at the top instead of row 1.

Next, select View >> Freeze Panes >> Freeze Top Row as in the earlier method. Now, you can unhide the hidden rows.

Do not select View >> Freeze Panes >> Freeze Panes if there are hidden rows. Otherwise, an arbitrary number of rows and columns will be locked.

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

4. Lock the Top Rows and Left Columns

If you lock the top row, it won't move when you scroll down. But, if you scroll horizontally, you won't see the employee names visible. This creates a similar problem.

Now, to fix this problem, select cell B2. Remember you want to lock the top row and first column at the same time. Now, notice that cell B2 is right below the top row and immediately right to the first column.

Then, select View >> Freeze Panes >> Freeze Panes as earlier. After that, the top row and the first column won't move when you scroll horizontally or vertically.

Now assume you want to lock the top 4 rows and the first 3 Then, you need to determine the cell right below row 4 and immediately right to the 3rd column. As cell D5 fulfills the criteria, select cell D5. After that, select View >> Freeze Panes >> Freeze Panes as in the earlier methods.

Finally, you will get the desired result as shown in the picture below.👇

Note. You can right-click on the Freeze Panes command to add it to the Quick Access Toolbar. This is helpful if you need to use it often.

Read More: Horizontal Scroll Not Working in Excel (6 Possible Solutions)

Unlock Top Rows in Excel

You can just select View >> Freeze Panes >> Unfreeze Panes to unlock the rows as shown below.

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

Things to Remember

Before using the Freeze Panes command,

Select the row just below the row that you want to lock.
Or, select the column immediately right to the column that you want to lock.
Or, select the cell just below the rows and immediately after the columns that you want to lock.

Conclusion

Now you know how to lock rows in excel when scrolling. Please let us know if this article has helped you to solve your problem. You can also use the comment section below for further queries or suggestions. Do visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.

[Fixed!] Excel Arrows Scrolling Not Moving Cells (6 Possible Solutions)
How to Stop Excel from Scrolling to Infinity (7 Effective Methods)
[Solved!] Vertical Scroll Not Working in Excel (9 Quick Solutions)
How to Stop Excel from Jumping Cells When Scrolling (8 Easy Methods)
Smooth Scrolling with Mouse Wheel in Excel (A Detailed Analysis)

sloanextrany.blogspot.com

Source: https://www.exceldemy.com/lock-rows-in-excel-when-scrolling/

Sloan Extrany