Skip to Main Content

Digital Scholarship Center: Excel: How To Sort Data

Information about the resources in the Digital Scholarship Center

Excel: How To Sort Data

Being able to store your data efficiently is very useful in Excel. Knowing this skill helps you organize your data and finish your project faster.


1: Open Microsoft Excel, Click the plus button to open a blank workbook.  


2: Insert data into various cells 


3: Highlight the data set you would like to sort by dragging the cursor across the whole data or clicking the triangle on the top left corner of the spreadsheet. 


4: Select the “data” tab on the top of the spreadsheet 



5: Select the “sort” button


6: Select the way you want Excel to sort the data (could be smallest to largest or largest to smallest or in alphabetical order) 




7: Select “ok” (the data will be sorted according to what you selected)



8: Don’t forget to save your work!