QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Sort Data in Ms Excel 2016?

By Neha T Leave a Comment

Sorting  comes in a frame when we need to arrange data in a certain fashion i.e. smallest to largest or vice-versa. You can also create your own order for sorting data. So let us move on How to Sort Data in Ms Excel 2016 ?

Steps to Sort Data in Ms Excel 2016:

Step 1: Select the cell to which you want to apply sorting operation. Like, I selected the cell below Total. Inside Home tab, under Editing group, we have Sort and Filter button. Click on it; it provides three sorting operations Sort Smallest to Largest, Sort Largest to Smallest and Custom. Here,  you can directly choose among smallest to largest or largest to smallest.

how-to-sort-data-in-ms-excel-2016But for demonstration, I chose Custom Sort to explain the particular tool.

how-to-sort-data-in-ms-excel-2016-step-1Step 2: As you will select Custom Sort, a Sort dialog box will appear. First, check the Options tab to see whether the sorting will be done from top to bottom or from left to right. For that click Options tab.

how-to-sort-data-in-ms-excel-2016-step-2Step 3: A Sort Options dialog box will pop up. At the top, there is  Case sensitive checkbox. If you want that sorting must also take care of case sensitivity then mark that checkbox. Under Orientation section, select whether you want to perform sorting in a top to bottom fashion or from left to right fashion. Then click OK.

how-to-sort-data-in-ms-excel-2016-step-3Step 4: Next, in Sort dialog box you can see a Column section, as we selected top to bottom sorting. In case if we have selected Left to right sorting then Row section would have appeared.

how-to-sort-data-in-ms-excel-2016-step-4Now under Column section, in Sort by drop box select the column on which you want to apply sort. In Sort On drop box select the base of your sorting i.e. whether you want to sort on values, or colour of cell, or colour of the font, etc. I chose a value. In Order drop down box, I chose Smallest to Largest. But you can also customise the order of sorting Which I have discussed later in the article.

how-to-sort-data-in-ms-excel-2016-step-4-1And here is how data has been sorted. You can observe the data in front of the Total values has also shuffled to match the sorting result.

Step 5: Now let us learn how to customise the Order drop down box in Sort Dialog box. As we know the, it already provides the sorting of months and days. You can also create your own order. For example, I have written an order of Batches from 1 to 5.

how-to-sort-data-in-ms-excel-2016-step-5Step 6: Go to the File>Options.

how-to-sort-data-in-ms-excel-2016-step-6Step 7: An Excel Options dialog box will be opened. Click on the Advanced option.

how-to-sort-data-in-ms-excel-2016-step-7Step 8: Under Advanced option in General Section, click on Edit Custom Lists button.

how-to-sort-data-in-ms-excel-2016-step-8Step 9: A Custom Lists dialog box will pop up. The Import list from cells: box will show the reference of the cells we selected. If it does not appear you can also select it from the spreadsheet where you have written your order list and click on Import. Then click OK.

how-to-sort-data-in-ms-excel-2016-step-9This is how we can add an order of our choice in Order drop down box of Sort dialog box.

Thank you. Keep reading.

You Might Also Like:

how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? Auto Fill in MS Excel 2016How to use Autofill in MS Excel 2016? Filter in Excel - feature imageHow to Filter Data in Excel? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016? how-to-delete-macro-in-ms-excel-2016-featured-imageHow to Delete Macro in MS Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Use (Add, Modify & Delete) Quick Parts in Outlook 2010
  • How to create a filter to block email in gmail
  • How to Change Pointer(Cursor) in Windows 10?
  • How to add notes in gmail
  • How to Embed Google Map in Joomla 3.x

Copyright © 2023 · QueHow · Contact Us