Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Sorting & Filtering Data in Excel 2010

View:  
Sorted by:  

How to Sort Excel 2010 Data on a Single Column

You may find data in Excel 2010 worksheets easier to view if it's sorted on a particular column, in ascending or descending order. Excel sorts in the following pattern: numbers, spaces, special characters [more…]

How to Sort Excel 2010 Data on Multiple Columns

If your Excel 2010 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column [more…]

How to Filter Records in an Excel 2010 Table with AutoFilter

Use the AutoFilter feature in Excel 2010 to hide everything in a table except the records you want to view. Filtering displays a subset of a table, providing you with an easy way to break down your data [more…]

How to Filter Numbers in an Excel 2010 Table

If you’re working with a large table of data in Excel 2010, you can apply number filters to columns that contain values to temporarily hide unwanted values. Excel provides several options for filtering [more…]

Filtering by Date in an Excel 2010 Table

If your Excel 2010 table includes columns with dates or times, you can filter the table to display a subset of the data with the dates or times you specify. The rows that do not match the criteria you [more…]

How to Filter an Excel 2010 Table by Color

If you've applied color to fonts or cells in an Excel 2010 table, you can filter the table to display a subset of the data with the colors you specify. The rows that do not match the criteria you specify [more…]

How to Create Custom AutoFilters for Text in Excel 2010

Use the Custom AutoFilter dialog box in Excel 2010 to locate records that either match all criteria or meet one or the other criteria. You can use this method for more flexibility when filtering text [more…]

How to Create Custom AutoFilters for Numbers in Excel 2010

Use the Custom AutoFilter dialog box in Excel 2010 to locate records that either match all criteria or meet one or the other criteria. You can use this method when you want to filter data based on a range [more…]

Filtering and Sorting an Excel 2010 Pivot Table

You can filter and sort the data in an Excel 2010 pivot table to display a subset of data arranged the way you want to view it. Excel automatically adds drop-down filter arrows to the Report Filter field [more…]

Using Slicers to Filter Pivot Tables in Excel 2010

Slicers are a new feature in Excel 2010 that you can use to filter your pivot tables. Slicers make it a snap to filter the contents of your pivot table on more than one field. Because slicers are Excel [more…]

Using Advanced Table Filtering in Excel 2010

With Excel 2010's advanced filtering methods, you can specify complex filtering criteria and designate a specific area of your worksheet to manage your criteria selections when filtering table data. Use [more…]

Advertisement
Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!