Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How To Perform Data Sorting In Excel 2010

MS Excel offers easier and simpler ways to sort data as per ones preference. MS Excel smartly rearranges the row based on the content of the particular through data sorting. If you wish to sort a table with names in alphabetical order or you wish to sort data by Amount from largest to smallest or smallest to largest, it can be done swiftly in MS Excel 2010.

In order to sort data, follow these steps.

    • Select the column that you wish sort data.
    • Now choose Data Tab, followed by Sort Below dialog box that will appear on the screen.

MS Excel tutorial

    • If you wish to sort data on the selected column, Choose Continue. If you want to perform sorting based on other columns, choose the Expand Selection option.
    • Here are different condition on which sorting can be done.
    • Values – It helps in sorting data alphabetically or numerically.
    • Cell Color – Based on the color of the cell.
    • Font Color – Based on the color of the Font.
    • Cell Icon – Based on the Cell Icon.

MS Excel tutorial

    • Now simply click on OK and it will sort the data.

MS Excel tutorial

  • Sorting option can even be accessed from the Home Tab. Choose the Home Tab, followed by Sort & Filter. It will offer you some of the quick sorting featuring like shown in the image.

MS Excel tutorial

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow