Solved

cannot scroll down in excel

Posted on 2016-10-26
5
45 Views
Last Modified: 2016-10-26
Hello experts,

I have received an excel template from a user and when I want to scroll down it does not work.

What could be the issue?

Thanks.
0
Comment
Question by:tony01excel tony
5 Comments
 
LVL 5

Expert Comment

by:Yamaafg
ID: 41860134
Hi, is it possible for you to upload the file?
0
 
LVL 5

Accepted Solution

by:
Yamaafg earned 500 total points
ID: 41860138
Meanwhile try following to see if it helps in case scroll area is set for the sheet.

go to tab "developer" tab
go to properties
check in the "scrollArea" to see if there is a range entered. If so, delete the range and save.

Hope this helps.
1
 
LVL 17

Expert Comment

by:xtermie
ID: 41860141
If you don't have the developer tab, you can find it by right clicking on the ribbon and selecting Customize ribbon
Then you check the box next to the developer tab in the right pane and press OK
0
 

Author Closing Comment

by:tony01excel tony
ID: 41860142
Apparently there was a scroll area entered for the sheet. I removed it and it works now. Thanks!
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41860649
Scroll area needs to be set each time. You may find code is setting it in the WorkBook Open event or WorkSheet Activate event
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now