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).
-
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:
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".
-