You are viewing the article How to Sort Excel Columns Alphabetically at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This post has been viewed 10,025 times.
Microsoft Excel is a great tool for organizing data. This article will introduce you to a simple but extremely useful feature, which is to sort data in alphabetical order.
Steps
Sort in alphabetical order
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9c/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-1-Version-3.jpg/v4-728px-Sort- Microsoft-Excel-Cpumns-Alphabetically-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9c/Sort-Microsoft-Excel-Cpumns- Alphabetically-Step-1-Version-3.jpg/v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-1-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Headline format. The header row is the first row in the spreadsheet, containing the name of the column. Sometimes Excel will sort this whole line because it thinks it’s part of the data, especially if your spreadsheet is full of text. Here are a few ways to prevent this:
- Format the subject line differently. For example, you can bold or change the color of text. [1] X Research Source
- You need to make sure there are no blank cells in the subject line. [2] X Research Source
- If Excel is still sorting, select the header line and using the top ribbon menu, click Home → Editing → Sort & Filter → Custom Sort . sort) → My data has headers . [3] X Research Sources
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f0/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-2-Version-3.jpg/v4-728px-Sort- Microsoft-Excel-Cpumns-Alphabetically-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f0/Sort-Microsoft-Excel-Cpumns- Alphabetically-Step-2-Version-3.jpg/v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-2-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the column to sort. You can click the column header cell or the letter above it (A, B, C, D, etc.).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-3-Version-3.jpg/v4-728px-Sort- Microsoft-Excel-Cpumns-Alphabetically-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Sort-Microsoft-Excel-Cpumns- Alphabetically-Step-3-Version-3.jpg/v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-3-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Data tab. Click the Data tab at the top of the screen to view data options in the ribbon menu above the spreadsheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/80/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-4-Version-3.jpg/v4-728px-Sort- Microsoft-Excel-Cpumns-Alphabetically-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/80/Sort-Microsoft-Excel-Cpumns- Alphabetically-Step-4-Version-3.jpg/v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-4-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Find the Sort and Filter section. The ribbon menu is divided by region with the name below. Look for the area labeled Sort & Filter.
- If you can’t find it in the Data menu, try going back to the Home tab and looking for the Sort & Filter button in the Editing section.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/46/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-5.jpg/v4-728px-Sort-Microsoft-Excel- Cpumns-Alphabetically-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/46/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-5.jpg/ v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the A → Z button. If you want to sort the worksheet alphabetically, just click the A → Z icon in the Sort and Filter section. The selected column will be sorted alphabetically. On most versions of Excel, this button is usually located in the upper left corner of the Sort and Filter section.
- If you want to sort in reverse alphabetical order, click the Z → A icon.
Sort by last name (for English name structure)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/40/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-6.jpg/v4-728px-Sort-Microsoft-Excel- Cpumns-Alphabetically-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/40/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-6.jpg/ v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-6.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
This applies when the worksheet includes the first and last names in one cell. If you have a list of full names (first name, last name structure) in a separate column, sorting will only be by name. With the following instructions, you should be able to split the full name into two columns and then sort by the last name column. [4] X Research Sources
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cf/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-7.jpg/v4-728px-Sort-Microsoft-Excel- Cpumns-Alphabetically-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cf/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-7.jpg/ v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-7.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Insert a new blank column. Place this column just to the right of the first and last name column.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0b/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-8.jpg/v4-728px-Sort-Microsoft-Excel- Cpumns-Alphabetically-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0b/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-8.jpg/ v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-8.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter the formula for the name part. Enter this formula in the top cell of the new column: =LEFT(A1,FIND(” “,A1)) and make sure there is a space in the quotes. This formula will look in the column for the full name and copy any data preceded by a space.
- If necessary, you can replace A with the letter of the column name containing the list of first and last names.
- Replace the number 1 with the line number you are entering.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/23/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-9.jpg/v4-728px-Sort-Microsoft-Excel- Cpumns-Alphabetically-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/23/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-9.jpg/ v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-9.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Copy this formula for the entire column. Click the header of the new column, and copy and paste the formula you just entered. You will see all the names automatically appear in this column.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ad/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-10.jpg/v4-728px-Sort-Microsoft-Excel- Cpumns-Alphabetically-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ad/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-10.jpg/ v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-10.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Create the last name column. Create a new column to the right of the name column. Copy and paste this formula to fill the last name in the column:
- =RIGHT(A1,LEN(A1)-FIND(” “,A1))
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d5/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-11.jpg/v4-728px-Sort-Microsoft-Excel- Cpumns-Alphabetically-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d5/Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-11.jpg/ v4-728px-Sort-Microsoft-Excel-Cpumns-Alphabetically-Step-11.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Sort by last name column. You can now sort the last name column alphabetically, as described above.
Advice
- If the “ribbon” menu disappears, double-click any card to expand it again. [5] X Research Sources
- This article is for Excel version 2003 and later. If you’re using an earlier version of Excel, you may need to look for options elsewhere.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This post has been viewed 10,025 times.
Microsoft Excel is a great tool for organizing data. This article will introduce you to a simple but extremely useful feature, which is to sort data in alphabetical order.
Thank you for reading this post How to Sort Excel Columns Alphabetically at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: