Is there a way to add Arrow Keys to Excel's Quick Access Toolbar?

[New_Here]

Hi Everyone,

Good Evening from Sri Lanka,

Can someone please tell me if there is a possibility of adding Arrow Keys to the Quick Access Tool Bar?

Or is there any method that the selection of a particular cell can be moved down immediately after a Pasting of "Paste and match Destination Formatting" is Done? So that I can move on to copy paste the next data?

Many Thanks.

[offthelip]

You can add an icon to activate a macro very easily to the quick access bar, first of all create a macro with this code in it:


Sub movedown()
ActiveCell.Offset(1, 0).Select
End Sub




Then on the customise quick access bar, select more commands , then on the left hand screen select macros on the drop down and select the macro yoiu have just created, then on the right hand screen choose whether you want it for all workbooks or just the one you are working on, then click ADD. Then select the icon in the rH screen and select modify and choose a down arrow icon.

[New_Here]

Thank you OfftheLip ! Great Favor. Highly Appreciate it.... :hi::hi::hi::thumb