About
In this article we will review how to sort a column in Excel on the web.
Environment
Excel on the web in a desktop browser.
Steps
- Navigate to Excel on the web as you normally would.
- Select your desired column by clicking its associated letter.
- Click the Sort & Filter button in the ribbon that resembles a funnel with the letters A above Z to the left of the funnel. This button is toward the right of the ribbon in the Home tab.
- This will display a drop down menu. From this menus select your desired sort from the options of Sort Ascending or Sort Descending.
- In the sort menu, there is also a Custom Sort option. Clicking this will open a new window.
- If you choose to click the Sort button, you will be presented with a window that allows you to add more columns using the + Add 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.