Using AutoFilter

The AutoFilter feature makes filtering, or temporarily hiding, data in a spreadsheet very easy. This allows you to focus on specific spreadsheet entries.

To Use AutoFilter:

• Select Data from the main menu.
• Select Filte AutoFilter.
• Click the drop-down arrow next to the heading you would like to filter.
  

• Choose the data you would like to display.

In this example, you would choose West. All other data will be filtered, or hidden, and only the West Sales Region data is visible.

• Open the Employee Sales spreadsheet.
• Use the AutoFilter feature to filter all entries except for the North Sales Region.
• Continue to use AutoFilter until you are comfortable with this feature.
• Save and close the spreadsheet.

Sorting Lists

Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order.

In this example, we will alphabetize the employee names.

To Sort in Ascending or Descending Order:

• Select Data from the main menu.
• Select Sort. The Sort dialog box will appear.
• Select the category you would like to Sort by.
• Select Ascending to sort in alphabetical order from A to Z.
• Click OK.
  

To Sort Multiple Categories:

• Select Data from the main menu.
• Select Sort. The Sort dialog box will appear.
• Select the category you would like to Sort by.
• Select Ascending to sort in alphabetical order from A to Z.
• In the Then by section, select the second category you would like to sort.
• Click OK to sort in alphabetical order and by sales region.
  

• Open the Employee Sales spreadsheet.
• Sort the employee names in alphabetical order.
• Sort by the Sales Region and then by Employee Name.
• Continue to sort the different categories until you are comfortable with this feature.
• Save and close the spreadsheet.