Solved

cannot scroll down in excel

Posted on 2016-10-26
5
22 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
Comment Utility
Hi, is it possible for you to upload the file?
0
 
LVL 5

Accepted Solution

by:
Yamaafg earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
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 will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

763 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

7 Experts available now in Live!

Get 1:1 Help Now