Sorting & Filtering Data in Excel 2013

View:  
Sorted by:  

How to Use Custom Filters in Excel 2013

In addition to filtering a data list to records that contain a particular field entry in Excel 2013, you can create custom AutoFilters that enable you to filter the list to records that meet less-exacting [more…]

How to Use Ready-Made Number Filters in Excel 2013

Excel 2013 contains a number filter option called Top 10. You can use this option on a number field to show only a certain number of records (like the ones with the ten highest or lowest values in that [more…]

How to Sort on Multiple Fields in Excel 2013

When you need to sort a data list on more than one field in Excel 2013, you use the Sort dialog box. And you need to sort on more than one field when the first field contains duplicate values and you want [more…]

Sort Excel 2013's Data Lists on Font and Fill Colors and Cell Icons

In Excel you normally sort the records of a data list or rows of a table on the values (entries) contained in one or more columns of the list or table; however, Excel 2013 also enables you to sort on the [more…]

How to Subtotal Data in Excel 2013

You can use Excel’s Subtotals feature to subtotal data in a sorted list. To subtotal a data list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

The Excel 2013 AutoFilter Feature

Excel’s AutoFilter feature makes filtering out unwanted data in a data list as easy as clicking the AutoFilter button on the column on which you want to filter the data and then choosing the appropriate [more…]

How to Sort Columns of a Data List in Excel 2013

You can use the column sorting capability in Excel 2013 to change the order of the fields in a data list without having to resort to cutting and pasting various columns. [more…]

How to Filter with the Excel 2013 Top Ten Option

The Top Ten option on the Number Filters option’s submenu in Excel 2013 enables you to filter out all records except those whose entries in that field are at the top or bottom of the list by a certain [more…]

How to Use Advanced Filtering in Excel 2013

When you use advanced filtering in Excel 2013, you don’t use the field’s AutoFilter buttons and associated drop-down menu options. Instead, you create a so-called Criteria Range somewhere on the worksheet [more…]

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.