Introduction: How to Alphabetize Rows and Columns in Excel

Picture of How to Alphabetize Rows and Columns in Excel

If you often work with Excel, a 10-minute task could easily

stretch into a much longer and more tedious chore if you discover later on that you need to rearrange your data. Many of us have been in a situation where we have to alphabetize a list, and have wasted precious time copying and pasting cell after cell. We will teach you how to work more efficiently and save your time with automatic alphabetization. Follow these simple steps to organize your data in a matter of seconds.

Step 1:

1. Select a cell in the column or row that you want to alphabetize. Make sure that the data is just text, and does not begin with any unnecessary spaces; otherwise it could mess up your final product.

Step 2: Step 2

Picture of Step 2

2. With one of the cells selected, click the tab that reads “Data.” From that drop down menu, click on “Sort,” which should be the first option. This will prompt a window to appear.

Step 3: Step 3

Picture of Step 3

3. When the window opens up, it will already be set to sort columns from A to Z. Click the space under the “Column” header to choose which one you want to sort.

Step 4:

Picture of

4.

If you want to alphabetize your rows instead of columns, choose the box that says “Options” and select “sort left to right.”

Step 5:

Picture of

5.

You can also alphabetize your data backwards by clicking “A to Z,” presenting you with a drop down menu that allows you to choose “Z to A.”

Step 6:

Picture of

6.

If you only want to alphabetize a portion of a column or row, rather than the entire thing, you can do that as well. To do this, highlight just the cells that you want to sort. When you click “Data” and then “Sort,” it will ask if you want to only sort the cells that you’ve selected. Click “Continue with the current selection,” and repeat the process as you did before.

Step 7:

7.

Enjoy your saved time, and never do any unnecessary copy-and-paste work ever again.

Comments

tytower (author)2017-04-02

You will find that many programs require you to select all the full line data that you want to sort first . That keeps all the line data attached to the sorted column , otherwise it will sort what you have selectedonly and leave its assosciated data as it was

DIY Hacks and How Tos (author)2017-04-01

Good information that everyone should know.

About This Instructable

1,216views

7favorites

License:

Bio: I like to write helpful articles on various topics.
Add instructable to: