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
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Shortcut to Re-order list items (2000)
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.
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.
Notifications