Issue scrolling on a spreadsheet

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
402
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi folks,
I have a spreadsheet which I've been using successfully for months.
I updated it this morning with some text. To achieve this I had to unprotect the spreadsheet and unfreeze panes.
I made my changes, put freeze panes back on, protected it again and then saved it.
Now when I try to scroll right or left using the arrow keys on the keyboard the cursor moves only within a restricted range of cells.
The top 8 rows are frozen and vertical scrolling with either the mouse wheel or vertical arrows works fine.
The cells are a mixture of locked/unlocked/hidden right across the spreadsheet i.e. both within the area that will scroll and outside that area.
I didn't change any formatting on the spreadsheet other than reapplying the freeze panes after making my changes.
I have tried unfreezing and refreezing but to no avail.
Strangely, Scroll Lock doesn't seem to have any affect, whether on or off.
Now, even if I unprotect the worksheet and unfreeze all cells scrolling with the arrow keys will still not work.
Any ideas folks?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,887
Hi

Mayb you have restricted the scroll area of the worksheet?

Try executing in vba:

Code:
ActiveSheet.ScrollArea = ""

or use the sheet properties dialog and clear the scrollarea (for ex. in the developer tab or in the vbeditor).
 

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
402
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Good morning and thanks for the suggestions.


Looking at the sheet properties in the vbeditor the ScrollArea is blank.
I ran ActiveSheet.ScrollArea both from the Immediate Window and in vba, both to no avail.


I have some more information.
Other people use this spreadsheet as well.
For me it is not scrollable but for another user it is.
This would suggest it is not related to the spreadsheet, or would it?
 

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
402
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi,
this is most bizzare.
I had left the spreadsheet open after completing your suggestions, which didn't resolve the problem.
When I subsequently tried the scroll again, without doing anything extra to the spreadsheet, it worked.
I saved the spreadsheet, closed it, reopened it and the problem was there again.
So I left the spreadsheet open without doing anything to it.
I came back to it later and the scroll problem has magically disappeared. Again without me doing anything to it.
Save the form, close it, reopen and the problem is back.
Any ideas? I'm mystified.
 

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
402
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Some more information.
This is the sequence:
• Open the problem sheet
• Check for scrolling issue; issue present i.e. can't scroll past certain section of worksheet
• Open a new blank workbook, don't do anything with it, just open it
• Check for scrolling issue in problem sheet; issue resolved, scroll anywhere you like

This is me scratching my head.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,887
Sorry, I don't know what the problem may be.

You could have some vba that would restrict the scroll during a certain time when the workbook opens but you seem to know your way around vba and so that should not be the case.
 

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
402
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Just for completeness, it's unlikely the issue is caused by other vba.
This same behaviour happens on other users's pcs as well.


It is a bit of a strange one. And I haven't seen it before.
But at least I have a way around it.


Thanks again for your input.
 

Forum statistics

Threads
1,171,026
Messages
5,873,371
Members
432,976
Latest member
Manbjorngris

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top