Home »  Software »  Office Suite Software

How Do I Set Up Universal Sorting in Microsoft® Excel® 2010

February 21, 2012  |  Difficulty: Easy

how to set up the universal sorting for any column in Microsoft® Excel® 2010.

If you create a large table in Microsoft® Excel® you can offer the reader the ability to sort data in a column using his own preferences. It is an easy process, and may be very helpful. The instructions below show how to set up the universal sorting for any column in Microsoft® Excel® 2010.

Setting the sorting filter:

  1. Launch the Microsoft® Excel® 2010 application and open the spreadsheet where you want to place a sorting filter.
  2. Click on the cell above the data you want to sort.
  3. In the “Home” tab click on the “Sort & Filter” dropdown menu and select the“Filter” option.
  4. The dropdown arrow will be added to the cell and if you click on it you can select the rules for sorting the data within the column.

Software:

Gallery

Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

How to share a workbook in Microsoft® Excel 2010 so other people will see the changes

How Do I Share a Workbook in Microsoft® Excel 2010

How to insert a new line, row, or column between ones that already exist

How Do I Add a Line or Column in Microsoft Excel®

how to insert a chart into a Microsoft® Excel® 2010 spreadsheet

How Do I Make a Chart in Microsoft® Excel® 2010

how to sort data in your Microsoft® Excel® 2010 spreadsheet or table

How Do I Sort a Row or Column in Microsoft® Excel®

How to format and merge cells in your Microsoft Excel® spreadsheet

How Do I Merge Cells in Microsoft Excel®

×
Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.