When it comes to Excel, here's a good rule to live by: If you find yourself doing something manually, there's probably an easier way.
Whether you're trying to remove duplicates, do simple calculations, or sort your data, you can almost always find a workaround that'll help you get it done with just a click (or two) of a button.
But if you're not a power user, it's easy to overlook these shortcuts. And before you know it, something as simple as organizing a list of names in alphabetical order can suck up a ton of your time.
Luckily, there is a workaround for that. In fact, there are a few different ways to use Excel's sorting feature that you may not know about. Let's check them out below, starting with the basics.
How to Sort in Excel
- Highlight the rows and/or columns you want sorted.
- Navigate to "Data" along the top and select "Sort."
- If sorting by column, select the column you want to order your sheet by.
- If sorting by row, click "Options" and select "Sort left to right."
- Choose what you'd like sorted.