Due to Phase 2 of our renovation, Campbell Library’s Floors 1, 2, & 3 are now closed. The 5th Floor Faculty Offices are open, and the 4th Floor Dreamscape Learn will launch soon. Please visit the Campbell Library Renovation site for details.
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!