Advice 1: How to make an alphabetized list in Word

Sorting is an operation often used when processing arrays of data. However, sometimes it is needed and when working with conventional texts. In Microsoft Office Word available.
How to make an alphabetized list in Word
You will need
  • Text editor Microsoft Office Word
Instruction
1
To sort a simple line of text one paragraph, select them. When you create a new document menu text editor opens by default on the Home tab. If it doesn't open at the moment - open. Here you need the section "Paragraph" in which you have placed a button which opens the settings window sort data - click it.
2
In this window you can specify three sort criteria that can be applied to the selected data sequentially. They are grouped in three sections with the headings "First" and "Then", but when you sort lines of a paragraph are active only the first one. Each section contains two drop-down list. In the first of them to sort text strings should be left the default value of "paragraphs", and the second ("type") "text". If these lines represent the date values or numbers in the second list, you can specify the paragraphs. In addition, there is placed a switch the sorting direction - ascending or descending. There is also a "Settings" button that opens a list of additional settings. It is possible to specify the used separator character fields and the need to take into account the case of letters. You can also choose the alphabet you want to use for sorting. When all necessary settings, click OK to begin the operation.
3
If you need to sort the data placed in the table, we need to act similarly when sorting a single column. But if you want to sort the data in two or three columns, it is necessary to allocate them all and then in the settings window sort will be available the second and third sections of the terms. The remaining steps are no different from simple sorting lines.
4
In Word, you can paste tables from the table editor Microsoft Excel. This makes possible much more sophisticated ways of sorting data. This can be done in Excel using its powerful Arsenal of data, and then transferring the fragments in the document text editor and, if necessary, edit here.

Advice 2 : How in Word to make the alphabet

In the application Wicrosoft Office Word many time-consuming operations can be done in a few mouse clicks. If you created a list and now want to place in it the items in alphabetical order, use the editor tools.
How in Word to make the alphabet
Instruction
1
To accomplish this you must use the tool "Sort". It is only available in edit mode tables. But you don't have to draw it by hand. And after you are finished with the list, you will again be able to return to the previous document, converting the table to text.
2
Select a portion of text in which you want to sort paragraphs in alphabetical order. Remember that each item in the list should begin on a new line. Go to the Insert tab and then under "Table" arrow button under the miniature table.
3
In the context menu of the tool select "convert text to table". Will appear a new dialog box where you can specify additional settings. Also you can simply accept the default values, then the table will be created from a single column, where each new list item will be placed on a separate line.
4
Select the table that you created will be available in the menu "Working with tables". Open the Layout tab and locate the section "Data". Hit it on the button-thumbnail "Sorting". This will open a new dialog box. The text can be sorted in descending order or ascending order (that is, either from the letter "I" to the letter "A", or Vice versa). Select the marker option that suits you.
5
Click on the OK button, the window "Sorting" will be closed automatically. The text in the table will be sorted according to user-set parameters. After that table again to convert to text or hide its borders.
6
Select the table and again open the Layout tab. In the "Data" section click on the "convert to text". Opens a new dialog box, select the marker in the "paragraph Mark" to each item that was previously in a separate line started with a new paragraph. Click on the OK button.
7
If you need to hide the border without deleting the table itself, click the Home tab, select the table and click the arrow button next to the thumbnail of the "Border" tab in the "Paragraph". In the drop down menu select "No border".

Advice 3 : How in Word to make the list alphabetical

Word processor Microsoft Office Word is not intended to organize user input. However, in text documents often have to create alphabetical lists, so the program added the function to sort the rows. To use it simply, and it is unlikely that such sorting will cause difficulty even for the novice user of Word.
How in Word to make the list alphabetical
You will need
  • Word processor Microsoft Office Word 2007 or 2010.
Instruction
1
Launch a word processor. If the alphabetical list you want to add to an existing document, upload it, and place the cursor at the desired location of the text. Keep in mind that the list will be created as a separate paragraph of text, that is, you need to provide a separation from previous and subsequent fragments of the document.
2
Enter all lines of the list, not paying at this stage of attention on the correct order. The only thing that matters now is to end each line of the list of input characters "carriage return", i.e. by pressing Enter.
3
Select all rows in the list and open the dialog box with the settings of the sorting text. To invoke it, use the button with the image placed one above the other letters "A" and "I" and an arrow pointing down. Placed this button in a group of commands "Paragraph" tab of the "Main" menu in Word.
4
In the box under "First" default value "paragraph", leave it unchanged. In the adjacent drop-down list - "Type" - the default value should be changed only if the strings contain dates or numbers. To the right of this list is posted two more fields that specify the sort direction is "ascending" and "descending" - select an option by clicking the corresponding checkbox.
5
If the selected portion of the document except the strings list includes the title, check the box next to "with title bar" at the bottom of the settings window.
6
By default, sorting is performed case-insensitive letters, but if you want to first in the list were strings starting with uppercase letters, and then from small, open advanced settings for sorting. For this window the basic settings placed the "Settings" button. Check the box "match case" and close the window by clicking the OK button.
7
Click OK and in the main settings window sort, then the word processor will put strings in alphabetical order.

Advice 4 : As in table Excel to automatically sort the names alphabetically

Ms Excel is a powerful spreadsheet editor. It allows you to work with bulk data types, namely sort them by the given sign, ask the necessary formulas and much more.
As in table Excel to automatically sort the names alphabetically

Sort by the given filter



One of the important and necessary functions of Ms Excel program is automatic sorting by a given parameter. This function allows to systematize the data in the table Ms Excel. It is possible to sort different types of data: text, such as names and numeric, such as date. There are at least two types of sorting.

To arrange the names alphabetically, you need to choose sorting by one characteristic. It is worth saying that the names in Ms Excel you can organize in ascending order, i.e. from "A" to "z" or descending order. This so-called simple sorting.

In this type of sort is enough to select the column which contains the names, order. Then in control panel of Ms Excel at the top right, find the option "Sort & filter". Click on it with the left mouse button, you will open a window where you can choose the sort from the first letter of the alphabet to the last, in reverse order, or to determine the required parameter. A simple sort will fit in the case if Microsoft Excel is only one column with the names.

If your document contains many columns, the Ms Excel program may request clarification or not to expand the scope of the formatting. In this connection, will display a dialog box. You can select the extension range or order in accordance with the allocated value. If you select automatic extension, the formatting of the cell associated with the column formatting will remain tied to it. In another case, sorting will not affect them. At this point, you should be careful because the data in the document when properly selected sorting risk to mix.

Custom sorting



The user can also use another way to sort the names alphabetically by selecting the custom range. In this case, you will need to specify the column that will sort the data. The actions of the user of the program Ms Excel will be the same, only you should choose in the "Sort and filter" option to "Custom sort". Then, the user selects the column that must be ordered data. In this case, the column with the names. The next step is to select sort alphabetically from the first letter to the last or Vice versa. Such a sort is called a complex.

Remember that in Excel you can sort any column, regardless of its location on the sheet. What version of Ms Excel installed, the settings for automatic sorting may vary, the essence of the work remains unchanged.
Is the advice useful?
Search