About
In this article we will review how to sort a column in Excel locally installed on your Desktop.
Environment
Excel locally installed on your computer.
Steps
- Navigate to Excel as you normally would.
- Select your desired column by clicking its associated letter.
- Click the Data tab in the ribbon.
- Click the Sort button in the ribbon that provides your desired sort direction. The one with the A on top sorts ascending. The one with Z on top sorts descending.
- If you wish to sort by multiple columns, you can do so by clicking the Sort button which looks like two cells one cell has the Z on top and the next has an A on top.
- If you choose to click the Sort button, you will be presented with a window that allows you to add more columns using the + button. For each column you can choose your sort order. Once complete, click OK and your columns will be sorted.
Hint: (If your columns include headers, you will want to check mark "My list has headers")
For more help, please contact ITS at its@manhattan.edu or 718-862-7973.