The main purpose of Microsoft Office Excel is to work with data in spreadsheets. Typically, these are numerical data, but sometimes cells contain text constants as well. In addition, the text is also used in the design of tables, so the need to organize word wrap arises from time to time when working in a spreadsheet editor.
Instructions
Step 1
Start Excel, load the desired document into it and go to those cells for which you need to set the option to wrap text by words.
Step 2
Select the desired cell or group of cells. You can select an entire row or column by clicking on its heading. If you need to organize the transfer on the entire page of an open document, then to select it, click on the corner cell - the one where the column and row headings converge. You can do without a mouse by pressing the keyboard shortcut Ctrl + A.
Step 3
Right-click the selection and select Format Cells from the context menu. The formatting settings window, opened by this command, consists of six tabs, among which you need to select "Alignment".
Step 4
Check the "wrap by words" checkbox - it is placed in the "Display" section of this tab. Then click OK and the new format will be applied to the selected range of cells.
Step 5
If after rearranging the text as needed, some of it will be hidden by the bottom borders of the cells, check if they have a fixed height value. You can undo it, for example, by selecting all the lines and moving the border between any two rows with the mouse to the desired line height. In this case, the same height will be set for all selected rows.
Step 6
It is possible that after the described procedure it will be necessary to correct the text in the cells so that there are no ugly "hanging lines" left. This can be done by manual editing by inserting a line break in the right places using the key combination alt="Image" + Enter.
Step 7
You can even hyphenate a word that is too long to make the text in individual cells more readable. To do this, insert a hyphen in the hyphenation position, and Excel will do the rest itself. Make manual edits to this and the previous steps last, just before printing or saving the document. Otherwise, any cell formatting may offset any hyphenation not automatically generated.
