Sort and Filter data in Microsoft Excel 2007, 2010, 2013

Create a data list in order to be able to Sort and to Filter in Microsoft Excel 2010

Respect the principles to display your data

Display a list of data

Guidelines to create Data Base in Excel:

  • Use only one list per sheet
  • Avoid empty columns and empty rows inside the list
  • Display one type of data per column
  • Keep distance between data list from other items
  • Put the other information above or below the data list in order to avoid hiding the filtered data
  • Make sure that all columns and rows are shown

 

SortingSort & Filter command

Sort a column
Click on the column
On Home tab
Click Sort & Filter command
Choose Sort A to Z Or Sort Z to A

Sort multiple columns
Click on any cell in the data list
Click Sort & Filter command
Click Custom Sort
Next to Sort by
Open the drop down list to choose the fieldSort on Multiple Levels
Below Sort On, keep Values
Below Order, keep A to Z
Click Add Level
Do the same like above
It’s possible to get lot of levels
Click OK

Filtering

Activate the auto FilterFilter Ingeneer
On Home tab
Click Sort & Filter command
Click Filter command

Filter for unique values
Make sure the Filter is activated
Open the filter triangle next to the field
Remove the check mark next to (Select All)
Then, check mark the value(s) you want displayed
Recognize where the filtered fields are
Observe the specific symbol on the right side of the fieldsFilterd field

Clear Filter
Open the filtered field
Click Clear Filter From “ Name of Field

Custom filter with numeric dataFilter numbers Greater or Equal
Make sure the Filter is activated
Open the filter triangle next to the field
Open Number Filters list
For example:
Choose Greater Than Or Equal To
Enter the number
Click OK

Custom filter with textText Filter, Begins with
Make sure the Filter is activated
Open the filter triangle next to the field
Open Text Filters list
For example:
Choose Begins With
Enter the text
Click OKDAte Filter

Custom filter with date
Make sure the Filter is activated
Open the filter triangle next to the field
Open Date Filters list
For example:
Choose This Year
Click OK

Show all data
Open the filter triangle
Click Clear Filter…

 

Was this article helpful?Logo régulier, pour capsule

Send me a message
Marjolaine: mberube@centracces.com

819-824-8884