How to alphabetize cells in excel

———————————————————————————————————

Introduction

Alphabetizing a set of data means to sort alphabetically in Excel. Basically, you sort out a list in Excel alphabetically. It can be carried out both ways, either in ascending or descending order. The application has still another function prematurely to easily sort data. This includes alphabetizing that provides strings (i.e. getting them in alphabetical order) and ordering exact values — both from biggest to smallest and smallest to biggest. A lot of people know how to alphabetize in Excel, but few of these actually know the most effective and fastest ways to do it. In this short article, I am likely to highlight some of the greatest techniques to alphabetize in Excel 2010. Please read until the end!

How To Alphabetize In Excel & Why to Alphabetize Data

If you are physically sorting important computer data in Microsoft Excel, you are wasting your time! The complete position of spreadsheets is to produce knowledge sorting easily and quickly. Alphabetizing will have numerous benefits:

It could make it simpler for an individual to appear up a particular price or person’s title
As it can help other people who utilize the spreadsheet understand it quicker and with less energy and
It creates the data more sensible.
It’s offers you the ease to search prices based on alphabetical order.
Additionally, it helps it be simpler for you yourself to creatively identify copy documents in important computer data set.

The process to Alphabetize Data Using Just 2 Clicks In Excel Ribbon

1. Open the Microsoft Excel 2010 spreadsheet that contains the data you need to alphabetize or enter the random data. Select column you wish to alphabetize. In the following example, I have selected the column B (cell B5:B12). Alphabetize in excel 1 2. Then click the “Data” tab at the menu bar of the spreadsheet and then look up the “Sort” ribbon. Click the “AZ sort” icon to sort in ascending alphabetical order. Or Click the “ZA sort” icon to sort in descending order.Your highlighted cells will now be sorted in ascending order and obtain the sorted data as output. Alphabetize in excel 2

Alphabetizing a column using Shortcut keys

If you are an individual who wants to use the keyboard significantly more than doing the exact tasks with the mouse, then here I’ll share a list of shortcut keys which is useful for you while sorting columns in excel. Alphabetize in excel 3 Note: Before using these shortcuts, make sure that you have already selected your data in the spreadsheet.

Alphabetize a List of Data using Excel Formula (COUNTIF and VLOOKUP)

————————————————————————————————————————————– This is another method and I will use excel formulas as well to alphabetize on Excel a list of data. Here I have an example to alphabetize data in column B (Student Name). The two formulas that I am going to use are COUNTIF and VLOOKUP. However, this method is not used frequently. Many of you would be thinking that “how we can sort a data list using a COUNTIF function?” Here I am using a simple trick to alphabetize the Student Name. For Example, I used column A as “Sorting order” to the existing table. After this, use a formula =COUNTIF($B$5:$B$12,”<=”&B5) for the first student, and then drag this formula to fill it in the entire range. Here is the screenshot; This formula gives the sorting order of each item in the list. Now, to arrange the following data based on the sorting order, I will use a VLOOKUP function. Here I have Column D for sorted data. For cell D5, use the VLOOKUP formula as for D5 cell =VLOOKUP(1, A: B,2,0). Similarly, for the second and third items, you can use the formula as =VLOOKUP(2, A: B,2,0) and =VLOOKUP(3, A: B,2,0) and so on…

After applying this VLOOKUP formula, the list gets alphabetized. Please see the screenshot. Tip: In place of manually entering the 1-8 in the above-mentioned formula, you may also utilize the row function to help ease your task. Row () function gives you the row number of the current cell. So, with the use of the row function, the formula will be as =VLOOKUP(ROW()-1, A: B,2,0). Please try once.

Sorting Data Table with Multiple Columns Using Sort Icon:

————————————————————————————————————————————– When you have a listing with two columns like “Roll number” and “Student Name, and you have to alphabetize this list based on “Student Names,” then you need to use the “Sort” button instead of the “A to Z” and “Z to A” buttons. The sort button under the “Data” tab provides you with more control over how you would like the list to be sorted. It allows selecting just one column to be sorted, it manages your table headers, and additionally, it may sort your data on the basis of text font or color. Follow below steps to utilize this technique as I have used in the example given below:

To begin with find the table to be alphabetized.
After this click the “Sort” button, on the “Data” tab.

Alphabetize in excel 6 3. This will open a “Sort” dialogue box, in the ‘Column’ drop-down choose the column based which you wish to alphabetize your data. 4. In the ‘Sort On’drop-down choose the ‘values’ option. Using ‘Sort On’dropdown you are able to sort important computer data centered on cell colour, font colour or cell icons. And In the ‘Order’field select “A to Z” for Ascending sort or “Z to A” for descending sort. Here in the example I have selected A to Z. 5. Finally click on the ‘Ok’ button and your data is sorted. Alphabetize in excel 9 Conclusion ————————————————————————————————————————————– Done Successfully! Those are the basics methods on how to alphabetize and sort by values in Excel.

Sort information exactly as you need it

Updated on February 4, 2021

What to Know

For newer versions of Excel, highlight cells > select Sort & Filter > Sort A to Z.
In Excel 2003, 2002 for Windows, 2008, and 2004 for Mac, highlight cells > select any cell in the column > Data > Sort > Ascending > OK.

This article explains how to alphabetize in Excel. Additional information covers how to sort multiple columns and advanced sorting. Instructions apply to Excel for Microsoft 365, Excel 2019, 2016, 2013, 2010, 2007, and 2003 or earlier as well as Excel for Mac 2016, 2011, 2008, and 2004.

How to Sort Alphabetically in Excel

The simplest way to alphabetize a column in Excel is to use the Sort feature.

Highlight the cells you want to sort and make sure there are no blank cells in the list.
Select Sort & Filter in the Editing section of the Home tab.
Choose Sort A to Z to alphabetize your list.

In Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac, follow these steps.

Highlight the cells you want to sort and make sure there are no blank cells in the list.
Click on any cell in the column you want to sort.
Select Data on the toolbar and choose Sort. The Sort dialog box will open.
Choose the column you want to alphabetize in the Sort By box, select Ascending.
Click OK to sort the list alphabetically.

Sort Alphabetically by Multiple Columns

If you want to alphabetize a range of cells in Excel using more than one column, the Sort feature enables you to do so, as well.

Select all of the cells that you want to sort by alphabetizing two or more lists in the range.
Click Sort & Filter in the Editing section of the Home tab.
Select Custom Sort. A Sort dialog box will open.
Select the My Data Has Headers checkbox if your lists have headers at the top.
Select the primary column by which you want to alphabetize the data in the Sort By box.
Choose Cell Values in the Sort On box.
Select A to Z in the Order box.
Click the Add Level button at the top of the dialog box.
Select the second column by which you want to alphabetize the data in the Sort By box.
Choose Cell Values in the Sort On box.
Select A to Z in the Order box.
Click Add Level to sort by another column, if desired. Click OK when you are ready to alphabetize your table.

In Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac, follow these steps.

Select all of the cells that you want to sort by alphabetizing two or more lists in the range.
Select Data on the toolbar and choose Sort. The Sort dialog box will open.
Select the primary column by which you want to alphabetize the data in the Sort By box and select Ascending.
Choose the second column by which you want to sort the range of cells in the Then By list. You can sort by up to three columns.
Select the Header Row radio button if your list has a header at the top.
Click OK to sort the list alphabetically.

Advanced Sorting in Excel

In certain situations, sorting alphabetically just won’t do. For instance, you may have a lengthy list containing the names of months or weekdays that you would like to sort chronologically. Excel will tackle this for you, as well. Start by selecting the list you want to sort.

Select Sort & Filter in the Editing section of the Home tab.
Select Custom Sort. The Sort dialog box will open.
Select the dropdown arrow in the Order list and choose Custom List. The Custom Lists dialog will open.
Choose the sort option you want to use.
Select OK twice to sort your list chronologically.

In Excel 2003 and 2002 for Windows or Excel 2008 and 2004 for Mac, select the list you want to sort.

Select Data on the toolbar and choose Sort. The Sort dialog box will open.
Select the Options button at the bottom of the dialog box.
Select the dropdown arrow in the First Key Sort Order list and choose the sort option you want to use.
Select OK twice to sort your list chronologically.

Excel provides numerous ways to enter, sort, and work with virtually any kind of data. Check out 6 Ways to Sort Data in Excel for more helpful tips and information.

Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe

Getgarminexpress