Forum Discussion

Copper Contributor

Feb 23, 2025

Putting a scroll right and scroll down tab on the taskbar

I have spreadsheets where I want to move down on row when I hit enter and I have them where I want to move right. How can I make a button to put on my taskbar that I can click to change the direction...

excel

HansVogelaar

MVP

Feb 24, 2025

Create the following macros in a module in your personal macro workbook PERSONAL.XLSB, then assign them to custom buttons on the Quick Access Toolbar (QAT):

Sub EnterMoveDown()
    Application.MoveAfterReturnDirection = xlDown
End Sub

Sub EnterMoveRight()
    Application.MoveAfterReturnDirection = xlToRight
End Sub

See Create and save all your macros in a single workbook if you're not familiar with the Personal Macro Workbook.