Microsoft Office Tutorials and References
In Depth Information
Section 11: Sorting and filtering worksheet data
Sorting and filtering
worksheet data
In this section:
After you add data to your worksheets, you might want to change the
Sorting worksheet data
order in which the worksheet rows are displayed. For example, if you
have a worksheet listing orders for a week, you might want to list the
orders for each customer or perhaps reorder the rows in your worksheet
so that the most expensive orders are at the top of the list and the least
expensive at the bottom. You can also hide any rows that don’t meet your
criteria, which is particularly useful if you work with a large data set.
Creating a custom sort list
Filtering data quickly with AutoFilter
Filtering data with a search filter
Clearing a filter
Creating an advanced filter
Just as you can change or limit how your worksheet data is displayed, you
can control what data is entered in your worksheets. By setting validation
rules for groups of cells, you can check each value, and if the value you
or your colleague enters falls outside the accepted range, you can display
an error message informing you or your colleague what went wrong and
what sort of value should be entered.
Filtering Excel tables visually by using
Clearing and removing slicers
Validating data for correctness during
Creating a recommended PivotTable
Analyzing data using PowerPivot
Presenting data using Power View
Search JabSto ::

Custom Search