Advice 1: How in Excel to make a list in one cell

Microsoft Office Excel is more suited for working with spreadsheets. However, it is possible to make the text almost the same as in a text editor, including the to do list in one cell.
How in Excel to make a list in one cell
Instruction
1
Launch Excel and position the cursor in the cellwhere you want to create a list. Before starting to enter data, set the cell in a suitable format. To do this, click the right mouse button and select in the right-click menu item "Format cells".
2
Alternative: activate the Home tab, in the "Cells" on the toolbar, click "Format" and select the context menu "Format cells". This will open a new dialog box.
3
For any list, even in the form of digital values, it would be better to use text format, so click in the window that opens on the tab "Number" and in the "number formats", select with the left mouse button the "Text". This means that your list will look exactly how you enter, and will not be converted to the formula or function.
4
On the Alignment tab can additionally mark with a marker the box "wrap text" under "Display" and set the options for text alignment in the cell. After parameter setting is finished, click on the OK button, the window "Format cells" will be closed automatically.
5
You will need to mark the list in the formatted cell, so start writing data with the icon or number line. Once the data is in the first row are entered, press the Alt key and while holding it, press the Enter key. This will allow you to move to the next line in the same cell.
6
If you are used to enter text not in the cell and in the formula bar, use the same principle: press the Alt and Enter everytime you want to go to a new line. At the end of the data input adjust the width of cellsby dragging the column border to the right or use the AUTOFIT feature for columns.

Advice 2: How to Excel transfer word

The main purpose of the Microsoft Office Excel - working with data in spreadsheets. Typically, this numerical data, but sometimes the cells contain text constants. In addition, the text used when creating tables, so the need to organize the transfer in words arises from time to time when working in table editor.
How to Excel transfer word
Instruction
1
Start Excel, load the desired document and select the cells for which you want to set the wrap option for text words.
2
Select the desired cell or group of cells. You can select a whole row or column by clicking the mouse pointer on its title. If the transfer should be arranged on the whole page in an opened document, then highlight, click on a corner square where converge the column headers and rows. You can do without the mouse, by pressing Ctrl + A.
3
Click the highlighted area right click and from the context menu, select "Format cells". The settings for the formatting, open the command consists of six tabs among which you need to choose "Alignment".
4
Check the checkbox "wrap words" - it is placed in the section "Mapping" in the tab. Then click OK and the new format will be applied to the selected range of cells.
5
If after adjustment of text the right way part of it will be hidden by the bottom border of the cells, check them set to a fixed height value. Cancellations can be made, for example, selecting all rows and then dragging the mouse to the border between any two rows before the desired row height. In this case all selected rows will be set to the same height.
6
It is possible that after the described procedure will have to correct the text in the cells, not to leave unsightly "dangling rows". This can be done manual editing, inserting in the right places a line break using Alt + Enter.
7
To give the text in separate cells more readable, you can even organize transfer in far too long a word. To do this, insert a hyphen in place of the transfer, and the rest Excel will do it myself. Manual editing of this and the previous steps make the last turn, immediately before the output of a document for printing or saving it. Otherwise any formatting of cells can shift all breaks are not created automatically.
Search
Is the advice useful?