• Excel Video Tutorials

Data Sorting in Excel 2010


Advertisements

Sorting in MS Excel

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest.

To Sort the data follow the steps mentioned below.

  • Select the Column by which you want to sort data.
  • Choose Data Tab » Sort Below dialog appears.
Sort Data
  • If you want to sort data based on a selected column, Choose Continue with the selection or if you want sorting based on other columns, choose Expand Selection.

  • You can Sort based on the below Conditions.

    • Values − Alphabetically or numerically.

    • Cell Color − Based on Color of Cell.

    • Font Color − Based on Font color.

    • Cell Icon − Based on Cell Icon.

Sorting Options
  • Clicking Ok will sort the data.
Sorted Data

Sorting option is also available from the Home Tab. Choose Home Tab » Sort & Filter. You can see the same dialog to sort records.

Sort From Home Tab

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements