How to sort an Excel sheet by a column(s)

May 09, 2011

If you use Excel to manage any data, for example glossaries, you will need to sort this data sooner or later. You can do this as follows:

  • Step 1: Select the entire range by clicking in the top left corner of the spreadsheet (as shown by the cursor below).

    Screenshot: How to select the entire range on a worksheet

  • Step 2: Sort by the column(s) where duplicates are being searched.

    • Excel 2007 or later: click the Sort button available in Sort & Filter group under the Data tab:

      Screenshot: Sort & Filter group in Excel 2007

      First, if your data has column headers, enable "My data has headers" option. This will allow you to specify columns using the names you assigned to them, and not just "Column A", "Column B", etc.
      To sort by a specific column, select that column from the "Sort by" list. Then select the sorting order - "A to Z" or "Z to A".
      To sort by additional columns, click Add Level and select appropriate options for the columns.
      When you are done, click OK.

    • Excel 2003 or earlier: select Data -> Sort... In the Sort dialogue, select a column that you would like to sort by, and choose the sorting order - Ascending (A to Z) or Descending (Z to A). You can make the sorting more accurate by selecting additional columns under "Then by" headings. If your glossary has a header with column names in it, enable "Header row", otherwise choose "No header row".

      Screenshot: How to sort by a column

Add comment

Security code Refresh