Can I make Excel scroll smoothly without using middle-click?

excel vba add-in
Luke picture Luke · Aug 26, 2011 · Viewed 50.1k times · Source

I must work with nightmare Excel files. (I didn't create them, I just have to work with them).

They were so big (more than 50 big columns and 100 big rows) then I must scroll up/down and use "<" and ">" buttons to scroll left and right. When I scroll around, Excel always jumps to the next column or row. This make me crazy!

Can I develop a plugin or add-in to make Excel just scroll smoothly, like web browsers do? If so, please give me some resource or just some keyword to learn how to do it.

Answer

JMax picture JMax · Aug 26, 2011

Another tip: when you click on Scroll lock on your keyboard, this will change the way your arrows keys will work.

Instead of moving from cell to cell, it will move the screen.

Yet, as Issun said, you cannot change Excel and AFAIK, you cannot "split" a cell when scrolling.

Furthermore, you can also change the number of rows that will scroll in the Windows Control Panel.

Related questions

onLoad ribbon callback fails (not firing/working) from Excel VBA .xlam

I've created a simple Excel add-in to demonstrate the problem whereby the ribbon onLoad event isn't firing when the project is saved and automatically loaded as a .xlam but does work when opened as a .xlsm. I've checked it for …

Read More
How can an Excel Add-In respond to events in any worksheet?

Our workbooks are server-generated SpreadsheetML, which cannot include any VBA code. Creating native Excel files or Excel 2007 XML files is also not an option, unfortunately. So, I have an Excel Add-In (VBA, not XLL) that each of our users installs …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More