• Shortcut to Re-order list items (2000)

    Author
    Topic
    #411456

    I want a keystroke combo that I can use to reorder cells in a column. In a Word table you have the shortcut Alt+Shift+Up Arrow or Down Arrow. Anything like this in Excel?

    Regards

    Viewing 0 reply threads
    Author
    Replies
    • #892217

      There are no built-in keyboard shortcuts, but you could create macros

      Sub SortAscending()
      Selection.Sort Key1:=ActiveCell, Order1:=xlAscending, Header:=xlGuess
      End Sub

      Sub SortDescending()
      Selection.Sort Key1:=ActiveCell, Order1:=xlDescending, Header:=xlGuess
      End Sub

      and assign them to convenient keyboard shortcuts. If you store the macros in your Personal.xls, they will be available in all workbooks. See Legare Coleman’s Personal.xls Tutorial (All) if you want to know more about Personal.xls.

    Viewing 0 reply threads
    Reply To: Shortcut to Re-order list items (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: