How to wrap in an Excel cell

Do you want to know how to wrap in an Excel cell on Mac, Windows or OpenOffice? Read this article! Find out here how to do it, even on smartphones and tablets.

Excel is one of the most popular and widely used spreadsheets, as well as being one of the most comprehensive programs of its kind. However, not everyone finds it easy to use: in fact, it's a system that uses functions that are sometimes complex, and if you're not used to electronic calculation, some functions may be obscure. For example, not everyone knows how to carriage return in Excel: it is not enough, as in other programs, to press the Enter key on the keyboard.

How to carriage return in Excel on a computer

To carriage return in Excel on a Mac or PC, using the normal version of the software for Windows, simply insert the line break by pressing a series of keys. First you have to open the spreadsheet, then double-click in the cell where you want to intervene. At this point you'll type the desired text, then, when you want to carve, you'll have to press the Alt+Enter keys simultaneously. This will allow Excel to wrap the text in a new line of the same cell and you can continue typing. The same operation can be repeated as many times as you want, depending on how many lines of text you want to create in the same cell. If you use a free version of Excel, the procedure is the same. So to carriage return in the Excel cell of OpenOffice or the free online version of Excel you will perform exactly the same procedure as in the Windows version.

In these cases, after carriage return in Excel, it may be useful to resize the cell to make the text flow more smoothly. To do this, simply move the mouse over the separator between the cells on the left side of the sheet, and hold down the button to expand the cell as much as you want.

Carve Excel Cells Automatically

You can also choose to carve Excel cells automatically by setting the Carriage Text format for all the cells you want to work in. This means that in each of them the text will wrap on its own. However, this system only works on the Microsoft Excel desktop version, while it cannot be used in the free online version.

To do this you will first need to select with the mouse the group of cells in which you will be working and for which you will need to set the carriage return function in Excel, then you will need to right-click on one of them. A drop-down menu will appear, from which the "Format Cells" item will be selected. A screen will appear from which you must select the "Alignment" item, then check the box labeled "Carriage Text". Then confirm the operation by clicking "OK". This operation will allow the automatic carriage return function in all selected cells. In addition, the height of the cell will automatically adjust to contain the text each time it is wrapped.

Alternatively, to wrap text in Excel you can activate the "Wrap Text" feature from the Excel toolbar on the Home tab. After selecting the cell containing the text, you should then click on the button related to the function of interest, represented by an icon with a downward arrow. In this case, the text you have already written will be wrapped automatically.

There is also a third possibility, although it is more cumbersome: the use of the formula code.caratt() combined with the function concatenate. The latter assembles the arguments of a single text string, while the latter is able to make the line break. So, in the cell you will have to use the two formulas with this sequence: =concatena("text";code.caratt; "text").

Carriage return in Excel from smartphone and tablet

If you want to carriage return in Excel using the program on your tablet, just select the cell to which you want to apply this function, then click on the home tab and select the "Carriage text" button, exactly as you do on the computer. On the smartphone the procedure is a bit more complicated, due to the smaller size of the screen. After selecting the relevant cell, then through the drop-down menu at the bottom you'll have to select the Home item and then you'll have to click on the "Carriage Text".