Sort and Filter in Excel

Sorting data is an integral pension of data analysis. You might nonattendance to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons. Sorting data helps you rapidly visualize and espouse to your data enlarged, organize and locate the data that you deficiency, and ultimately make more operating decisions.
You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and become antiquated (oldest to newest and newest to oldest) in one or more columns. You can plus sort by a custom list you make (such as Large, Medium, and Small) or by format, including cell color, font color, or icon set.

Filtering Data

The filter feature applies a slip the length of menuto each column heading, allowing you to choose specific choices to narrow a table. Using the above example, allocates interpret you wanted to filter your table by Company and Salesperson. Specifically, you painful sensation to locate the number of sales

To do this using the filter you would:

  • Go to the Data tab on Excel ribbon
  • Select the Filter tool
  • Select Eastern Company from the dropdown menu
  • Select Dylan Rogers from the Salesperson dropdown menu

Sort text

  1. Select a cell in the column you want to sort.
  2. On the Data tab, in the Sort & Filter group, do one of the following:
    • To quick sort in ascending order, click A to Z command in Excel that sorts A to Z or smallest number to largest (Sort A to Z).
    • To quick sort in descending order, click Z to A command in Excel that sorts Z to A or largest number to smallest (Sort Z to A).

Share This Post

Leave a Reply

Your email address will not be published.