How to Limit Scroll Area in Excel (3 Easy Ways)

Limit the Scroll area in Excel is a useful trick. Sometimes, you might want to hide some cells from your viewer. Also, for practical purposes, you might want to stick to the specified area. That’s where this article comes in handy.

Download Practice Workbook

You can download and practice this workbook.

3 Ways to Limit Scroll Area in Excel

There are many ways we can limit the scroll area in Excel. We will show you three easy and simple ways for that. So, let’s begin.

For that, we have made a data set containing World Cup Winners and Runner Ups.

Dataset - how to limit scroll area in excel

1. Limit Scroll Area Manually

You can manually select the scroll area in the Excel Sheet.

Select the Properties option from the Developer tab.

Limit Scroll area in Excel

A window like this will show up.

Now, in the ScrollArea box write the area that you want to scroll. Doing so, all other areas will be fixed and your selected area will remain active.

We used (A1:E30) as our area.

Selecting for Scroll Area


Note: This is a short-term solution. When you close the file and reopen it again the changes will be lost.

Read More: How to Limit Sheet Size in Excel (3 Suitable Ways)

2. Use of Hide Option from Context Menu to Limit Scroll Area

You can limit the scrolling area by hiding cells. It’s an easy and permanent solution.

First, select Column F and press CTRL+SHIFT+Right Arrow simultaneously.

Thus, all the Column right of E will be selected.

Then, Click Right on the Mouse. A similar window like this will open. And select Hide in the option. Thus, all the columns from F will be hidden.

Hide Cells in Excel

For rows, we want all the cells hidden from row 31.

So, select row 31 and press the CTRL+SHIFT+Down Arrow simultaneously.

And all the rows from 31 will be selected.

Now, Click Right on your Mouse and Select Hide.

Hide cells to limit scroll area

Thus, your scroll area will be limited up to Column F and Row 30.

Read More: How to Set Limit in Excel Cell (5 Simple Ways)

3. Use of VBA Code to Limit Scroll Area

You can use the VBA code to limit the scroll area. We will use a VBA code in this section to demonstrate the process.


First, Select Visual Basic from the Developer bar.

VBA code to limit Scroll Area

Now, Click on Module.

And, write the following formula and close the window.

Sub controllScrollarea() 
Dim sk As Worksheet
Set sk = ActiveSheet 
sk.ScrollArea = "$A$1: $E$30"
End Sub

VBA code to limit scroll area in Excel

Here, I have used the ScrollArea method of a worksheet to limit the scrolling area within A1 to E30 range. You can change the range as you want.

Then, Select Macros from the Developer tab. A box will open containing the Macro.

Now, Select the Macro and press Run.

Doing so, you will be constrained to scroll in the specified area.

You will see that you can scroll within the mentioned cells.

Read More: How to Set Limit for Visible Area in Excel (3 Ways)


That’s all for the article. I’ve tried to show you some easy but handy ways to limit the scroll area in Excel. I hope you will find all these three methods useful. There are other articles on this website related to this problem that you might find useful. If you have any queries regarding any of these methods, feel free to leave them in the comment section.

Related Articles


Sourav Kundu

Sourav Kundu

Bio: Hi, I am Sourav Kundu. I live in Adabor, Dhaka. I graduated in Naval Architecture and Marine Engineering from BUET. I am really excited to be a part of SOFTEKO family. I want to develop my research skill and find innovative solutions for the given problems.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features