Sort Spreadsheet Data Tutorial
Microsoft Excel
Objective: To sort spreadsheet data using Microsoft Excel

---

Introduction: Among the many functions that Microsoft Excel comes equipped with, the "Sort" function is one of the more useful. The "Sort" function allows users to sort column and row data in ascending or descending order. This allows the user to customize how the data will be viewed. The "Sort" function can be useful for educators who want to sort through large information files to organize information, such as test scores and experiment results.

---

Skill Practice: Sort data in an Excel Spreadsheet file

Step 1: Open . Open an existing Excel spreadsheet file, such as a Student Gradebook.

Step 2: Choose a column or row that you want to sort, such as grade percentage.

Step 3: To sort all the cells in the column, go to Data > Sort. The "Sort" window appears on the screen.

Step 4: In the "Sort" window, identify the "column" you want sorted, and the "order" you want the column's data sorted (ascending or descending). . Click "OK". The column will be sorted according to your specifications.

Step 5: Go to File > Save to save the sorting adjustments to your spreadsheet file.

Step 6: * Note * - To quickly sort data in ascending order, click on the button.

Step 7: To "Undo" a Sort - If you don't like the results of a sort, go to Edit > Undo immediately following the sort - the Excel file will return to it's original form.