Find solution
PUT IN ALPHABETICAL ORDER?

In Microsoft Excel how do you put everything in alphabetical order?

  • I have 7 pages of words that I need to put in alphabetical order in excel so I can delete the repeated words and narrow down my list. Can anyone help me out?

  • Answer:

    You can sort by selecting them and then u should go from data->sort. By clicking on "sort" its going to appear a box which ask how to sort.

lalalizz... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Highlight all of your data, then go to "Data" on the top menu and select 'Sort'. choose the right column to sort by, then in Ascending order (for alphabetical) Make sure you highlight ALL of your data, including anythign to the right/left of what you want to sort. If you have a table with data in Column A, B & C. The names are in B. If you highlight all the names in B and to the Sort, you will only sort B. The stuff in A & C won't move with the names. If you highlight all A, B & C...then select B to sort by anything associated with a name in B will move as well. Columns A & C will move around, keeping all the same data within a row in the same row.

thoughtdream

there is an "a-z with an arrow that points down" button up top, just click it

wishing4more

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.