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 Excel to make the condition

In various programming languages for verification of any terms and conditions are "conditional statements". The table editor Microsoft Office Excel has its own set of functions that can be called a very simplified programming language. In this analogue of the conditional operator is a function of "IF".
How in Excel to make the condition
You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
Select the spreadsheet cell into which shall be placed the function of checking the conditions and start the wizard to create formulas. This can be done by clicking on the icon placed to the left of the formula bar. In the opened window, open the drop-down list "Category" and select "Logical". Below this list appears the list of functions, scroll to the line "IF", click OK, and Excel will open the form creation function. This same form can invoke another method in the command group "Libraries and functions" on the Formulas tab open the drop-down list of "Logical" and select "IF".
2
In the "Logfilesize" place the conditionwhich need to check this feature. For example, if you need to check whether the value in cell A1 is negative, start by clicking on that cell with the mouse or manually entering its address (A1). Then add the "less than" sign and a zero to obtain: A1
3
Go to the next form field - "Znacheniya". Enter the number, word or address of the cells in the table that needs to display a cell if a specified condition is met. A word or phrase should be in quotes, numbers without quotes, and the address of the cell it is easiest to define by clicking on it with the mouse pointer. For example, from the previous step here you can put the text ""negative"".
4
The following form field "Znacheniya" - fill in exactly the same way as the previous one, but place the value to display in case of failure to meet the specified conditions. In the example used here, it is logical to place the inscription ""negative value not"".
5
Click OK, and Excel will immediately check for the specified condition and display the result. After the wizard is used for the above example, the formula in the cell should look like this: "=IF(A1

Advice 3: 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 4: 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.
Search
Is the advice useful?