Excel is a powerful spreadsheet program, widely used by millions of people, which can store and manage texts and numbers. Alphabetical ordering is one of the many advantages of Excel. Alphabetically arranged cells allow you to quickly access and reference your data. You can sort Excel cells alphabetically in two different ways.
Steps
Method 1 of 2: Sort alphabetically in two clicks
Step 1. Type the text you want to alphabetize in the cells of any column
Step 2. Highlight the text you want to alphabetize
To select the set of cells to sort in alphabetical order, click on the first cell and scroll down to the last. You can select an entire column by clicking on the column title (A - B -, etc.).
Step 3. Locate the AZ and ZA icons on the standard toolbar, they are side by side under the Data tab
Click on the icon AZ to sort in alphabetical order. Click on the icon ZA to sort in reverse alphabetical order. Your selected cells are then sorted.
- If you can't find the AZ icon, you can add it to the standard toolbar by opening the menu Display in the menu bar, then you select Toolbar and you tick Standard. The standard toolbar will display the two icons AZ and ZA.
Step 4. Well done
Method 2 of 2: Sort alphabetically with the Sort function
Step 1. Fill your Excel sheet with text
Step 2. Select the entire worksheet
To do this, do Ctrl + A as a keyboard shortcut or Command + A. You can also click on this small white box which is at the top left of the sheet, at the intersection of the rows and columns.
Step 3. Open the Data menu in the toolbar, then click the Sort option
A Sort … box appears. If you have customized the column headers, always check in this Sort window that the box My data range has a row of titles is checked. If you have not identified the columns, select the option No header line.
Step 4. Choose the column you want to sort alphabetically
To do this, select the heading sort by. If you have selected header line, in Sort by, you will see what you put as text on the first line. If you chose No header line, you will see the standard letters (A, B, etc.) found at the top of the spreadsheet.
Step 5. Select Ascending to sort the chosen column in alphabetical order
Choose descending to sort the chosen column in reverse alphabetical order.
Step 6. Click OK
Your cells will now be sorted alphabetically.
advice
You can alphabetize any column anywhere in the sheet
Warning
- When you sort alphabetically with the icons AZ Where ZA, only the selected column will be sorted, the other columns will remain unchanged. On the other hand, if you choose to sort with the function Sorting menu Data and if you select all the columns, you will sort your column and the other columns will also be changed.