How to Make an Excel Column Alphabetical | Scribe

    How to Make an Excel Column Alphabetical

    • |
    • 4 steps |
    • 36 seconds
      1
      To begin, open your workbook in Excel.
      2
      Click on the Column Header for the column you want to alphabetize.
      3
      Click "Data" form the top menu.\ Click the "Sort" icon to open a pop up menu. You can just click on the "A-Z" icon for a quicker sort, but it will also sort your header if you have one.
      Click "Data" form the top menu.\ Click the "Sort" icon to open a pop up menu. You can just click on the "A-Z" icon for a quicker sort, but it will also sort your header if you have one.
      4
      Select "My list has headers" if you have a header you want to stay at the top.\ Click "OK" to close the pop-up window and sort your column.
      Select "My list has headers" if you have a header you want to stay at the top.\ Click "OK" to close the pop-up window and sort your column.