Moving view, not moving selection [Closed]

Report
Posts
1
Registration date
Tuesday February 16, 2016
Status
Member
Last seen
February 16, 2016
-
Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
-
Hi there :-)

Is there a way to keep the selection, e.g. multiple cells, but move the view to the top of the sheet? Of course another way than scrolling, or making ctrl+down, then ctrl+shift+up


Sorry if it's an amateur question, I tried searching for answers too.

Thanks in advance

1 reply

Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
446
Hi Ssenemesis,

Well, Ctrl+Arrow and Ctrl+Shift+Arrow will mess with your selection.
But what is wrong about scrolling?

Is your scroll wheel damaged?

You could use a macro and create a shortcut for it:
Sub RunMe()
ActiveWindow.SmallScroll up:=Rows.Count
End Sub


Does this help?

Best regards,
Trowa