- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
You will often want to change the ordering of your data. For example, you might want to sort a table of sales reps by their regions, then by YTD sales. You can meet this need by using Excel’s Sort function.
Click on any cell within the data table you are going to sort.
On the Data tab, click the Sort command.
The Sort Dialog box opens. Select the field you want to sort and then specify whether you want to sort Smallest to Largest or Largest to Smallest.
Click the Add Level button to add another level of sorting.
Select another field to sort by, then specify whether you want to sort Smallest to Largest or Largest to Smallest.
After you click the OK button, Excel immediately applies your custom sort.