English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Is there any tools or option in Microsoft Excel and in Words that can do Alphabetical order?

2006-06-24 02:22:35 · 3 answers · asked by talkbox 4 in Education & Reference Words & Wordplay

3 answers

yes sort
you have to highlight it and
in excel
Data --> Sort --> Assending order

in word
Table --> Sort

2006-06-24 02:39:55 · answer #1 · answered by ♥♫♥ÇHÅTHÜ®ÏKÃ♥♫♥ 5 · 0 0

Yes, in Excel, you can highlight the column of the information you want to sort. Then you would need to go to the Data menu at the top of the screen, then click sort to sort the information. Note: The data will be sorted by the first words listed in the cell (i.e., Bob Jones would come first then Bob Smith). If you need to sort or alphabetize by last name, then the last name would need to be the first word in the cell or in a cell by itself (i.e., Jones, Bob or Smith, Bob).

In Word, only information in a table can be sorted:

Sort a list or table
Show All
Hide All
Select the list or table you want to sort.
On the Table menu, click Sort.
Select the sort options you want.
Sort a single column in a table

Select the column or cells (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.) you want to sort.
On the Table menu, click Sort.
Select the sort options you want.
Click Options.
Select the Sort column only check box.
Sort by more than one word or field inside a table column

For example, if a column contains both last and first names, you can sort by either last name or first name.

Select the columns you want to sort.

On the Table menu, click Sort.

Under My list has, click an option.

Click Options.

Under Separate fields at, click the type of character that separates the words or fields you want to sort, and then click OK.

In the Sort by box, enter the column containing the data you want to sort by, and then in the Using box, select which word or field you want to sort by.

In the first Then by box, enter the column containing the data you want to sort by, and then in the Using box, select which words or field you want to sort by.

Repeat step 7 in the second Then by box if you want to sort by an additional column.

Click OK.

2006-06-24 09:35:06 · answer #2 · answered by nikki 1 · 0 0

Yes, it's called SORT. The buttons are available on the toolbar, and they are up and down arrows.

2006-06-24 09:26:14 · answer #3 · answered by PariahMaterial 6 · 0 0

fedest.com, questions and answers