How to Alphabetize Cells in Excel

PDF download Download Article
PDF download Download Article

Excel is a powerful spreadsheet tool used to store and manage text and numbers, and alphabetizing is one of the many benefits of using Excel since it allows you to quickly organize, access, and reference data. To alphabetize cells in Excel using two clicks, highlight the range of cells and click on the "AZ sort" or "ZA sort" icon on the standard toolbar. To alphabetize cells in Excel using advanced Sort options, highlight the entire worksheet, click on "Sort" from the "Data" menu, then select the columns and order you wish to sort by from the resulting dialog box.

Method 1
Method 1 of 2:

Alphabetizing in Two Clicks

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Alphabetize-Cells-in-Excel-Step-1-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/78\/Alphabetize-Cells-in-Excel-Step-1-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/71\/Alphabetize-Cells-in-Excel-Step-2-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/71\/Alphabetize-Cells-in-Excel-Step-2-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    To highlight, click on the first cell and drag down to the last cell you want to alphabetize. You can highlight an entire column by clicking on the lettered column heading.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Alphabetize-Cells-in-Excel-Step-3-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/8\/87\/Alphabetize-Cells-in-Excel-Step-3-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Click the "AZ sort" icon to sort in ascending alphabetical order. Click the "ZA sort" icon to sort in descending order. Your highlighted cells will now be sorted.
    • If you cannot locate the "AZ sort" icon you can add the standard toolbar by opening the "View" menu on menu bar then select "Toolbars" and check "Standard." The standard toolbar will now be visible and will include the "AZ sort" icon.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c6\/Alphabetize-Cells-in-Excel-Step-4-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/c6\/Alphabetize-Cells-in-Excel-Step-4-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    5. Advertisement
Method 2
Method 2 of 2:

Alphabetizing with Sort

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Alphabetize-Cells-in-Excel-Step-5-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/d1\/Alphabetize-Cells-in-Excel-Step-5-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b4\/Alphabetize-Cells-in-Excel-Step-6-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-6-Version-2.jpg","bigUrl":"\/images\/thumb\/b\/b4\/Alphabetize-Cells-in-Excel-Step-6-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    To do this use the shortcut keys "Control + A" or "Command + A." You can also highlight by clicking the blank box in between the row and column headings on the top left.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Alphabetize-Cells-in-Excel-Step-7-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-7-Version-2.jpg","bigUrl":"\/images\/thumb\/b\/bf\/Alphabetize-Cells-in-Excel-Step-7-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    A "Sort" box will appear. If you have labeled the columns, select the "Header row" option under "My list has." If you have not labeled the columns, select the "No header row."
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/00\/Alphabetize-Cells-in-Excel-Step-8-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-8-Version-2.jpg","bigUrl":"\/images\/thumb\/0\/00\/Alphabetize-Cells-in-Excel-Step-8-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    " If you selected the "Header row" option, the options under "Sort by" will be your column headings. If you have selected "No header row," the options will be the standard letter column headings.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7a\/Alphabetize-Cells-in-Excel-Step-9-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/7a\/Alphabetize-Cells-in-Excel-Step-9-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Or select "Descending" to sort the chosen column in descending order.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cf\/Alphabetize-Cells-in-Excel-Step-10-Version-2.jpg\/v4-460px-Alphabetize-Cells-in-Excel-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/cf\/Alphabetize-Cells-in-Excel-Step-10-Version-2.jpg\/aid1320958-v4-728px-Alphabetize-Cells-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Your cells will now be alphabetized.
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    Is there a way to reverse the order of names listed to make it last name before first name?
    Community Answer
    First, highlight the set of cells that are connected to the last name. Click 'Sort', which in 2016 is located under the 'Sort & Filter' menu as 'Custom Sort'. Next, look for the column to sort your names to and select the column letter that corresponds with the worksheet column you want to sort by. Click 'OK' and the columns will be sorted to the specifications you selected.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 8
  • Question
    How will changing the order of one column affect the other columns?
    Community Answer
    If only one cell is selected, Excel will assume you want the entire block of information sorted. If more than one cell is selected, it will only sort the selection, and often will return a message asking to confirm that you really want to sort only part of a block of information (a rare use case).
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 10 Helpful 12
  • Question
    Is there a way to have future additions to an already-alphabetized list be added in their correct place?
    Community Answer
    Not automatically. You can either insert a line where the entry should be alphabetically before adding, or simply add it to the bottom and re-sort.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 1
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • Alphabetizing cells with the "AZ sort" icon will only alphabetize the column you have highlighted. Any data in the following columns will remain static and will not sort in line with the cells you alphabetized. Alphabetizing by using the "Sort" option under the "Data" menu will allow you to alphabetize 1 column and keep any corresponding data in line.
        Thanks
        Helpful 0 Not Helpful 0
      Advertisement

      You Might Also Like

      Add Header Row in Excel: Freezing, Printing, Tables, Power Query
      How to
      Print Part of an Excel Spreadsheet
      How to
      Recover a Corrupt Excel File
      How to
      Unprotect an Excel Sheet
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Unhide Multiple Rows in Microsoft Excel
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      Advertisement

      About This Article

      Article Summary X

      1. Highlight the cells to alphabetize.
      2. Click Sort & Filter .
      3. Click Sort A to Z .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 480,889 times.

      Is this article up to date?

      Advertisement