How to sort data in a column or row in Excel?

By aanimal07/01/2023
Jean-Philippe Parein
IT specialist
May 24, 2021 at 11:36 a.m.
0
Excel lets you perform simple and sometimes complex calculations using formulas or using macros and Visual Basic for Application code. However, it also allows you to apply other functions to make your table much more readable and pleasant. In this tutorial, we are going to sort a column in our spreadsheet as well as a row.

Sort column data in Excel

  1. Select the column of your spreadsheet to sort. Click on its header (the letter of your column).
  2. In the Ribbon, select the Data tab, then click on the Sort icon.
    < div>
  • In the sort dialog on the right, select from the Order drop-down menu the option From Z to A to sort in order increasing the cells of your column. If you want to sort them in descending order, choose the option From Z to A.
  • Click the Ok button. Your column is now sorted according to the order of your wish

    • Sort row data in Excel

    1. Select the rowof your spreadsheet to sort. Click on its header (the number of your line).
    2. In the Ribbon, select the Data tab, then click on the Sort icon.
      < div>
  • In the sort dialog on the right, select from the Order drop-down menu the option From Z to A to sort in order increasing the cells of your column. If you want to sort them in descending order, choose the option From Z to A.
  • If the sort by line selection is not available, click the Options button. On the new dialog box, check the left to right box, then press the Ok button.
  • Click the Ok button. Your line is now sorted in the order you want
    • The command buttons allow you to quickly apply an ascending or descending sort. The sort window allows you to refine the sort preferences, it offers more options such as the possibility of sorting according to cell colors.
    This tutorial is offered to you by the trainer Jean-Philippe Parein Find his course Learn and Master PowerPoint Complete Guide in full on Udemy.
    Download:Microsoft Excel for Windows 10 | Microsoft Excel for macOS
    Find other tutorials on Microsoft Excel:

    How to sort column data or a row in Excel?

    Category

    Hot Articles

    How to choose the right underwear for kids
    19/05/2022

    How to choose the right underwear for kids

    “A measure that benefits”: stop blaming!
    05/02/2022

    “A measure that benefits”: stop blaming!

    How to clean silverware with baking soda?
    22/06/2022

    How to clean silverware with baking soda?

    Twitch: one more banished exhibitionist!
    09/04/2023

    Twitch: one more banished exhibitionist!

    Linda Hardy poses in lingerie, Internet users love it, she is sublime!
    07/02/2022

    Linda Hardy poses in lingerie, Internet users love it, she is sublime!

    How to wear high waisted jeans? - Marie Claire
    05/02/2022

    How to wear high waisted jeans? - Marie Claire

    The moods institute The teachers work a lot and are rarely absent, let it be known!
    03/02/2022

    The moods institute The teachers work a lot and are rarely absent, let it be known!

    Zollabgabe Erhöht Sich Bei Offenen Zellfernsehern
    19/08/2022

    Zollabgabe Erhöht Sich Bei Offenen Zellfernsehern