Stop Excel 'wraparound' scrolling

Jehannum_2000

New Member
Joined
Sep 14, 2024
Messages
16
Office Version
  1. Prefer Not To Say
Platform
  1. Windows
The first 7 rows of the spreadsheet are fixed in place (with Freeze Pane, if I remember rightly).

If the user is on row 8 and presses the up arrow key where there is a locked, unselectable cell above, Excel scrolls to row 65 (the last row that allows data entry).

This is annoying for the user. There is not usually any data this far down, so they just see blank rows.

Instead, I want the active cell simply to stay at row 8, i.e. for there to be no scrolling down to row 65.

I don't want the user to have to use Scroll Lock (which may or may not be on their keyboard). I want Excel or VBA to enforce the above behaviour.

I'd be grateful for a solution.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

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
Back
Top