Moving view, not moving selection Closed

Question

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

Configuration: Windows 7 / Firefox 38.0

TrowaD · Answer

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

Moving view, not moving selection

1 response

Similar discussions

Subscribe To Our Newsletter!