For all of these use cases, Excel users would find that shortcuts make their lives easier. From the simple and popular shortcuts which let you easily copy, cut, and paste data, to the more unknown ...

These shortcuts are found in both the "Data" and "Home" tabs. Excel automatically tries to alphabetize vertically by column, but you can easily adjust this setting to sort horizontally by row.