See solution in other versions of Excel: • • • • • Question: How do I wrap text in merged cells in Microsoft Excel 2011 for Mac? Answer:Select the merged cells that you wish to wrap text. Right-click and then select 'Format Cells' from the popup menu. When the Format Cells window appears, select the Alignment tab.

The Best Free Text Editors for Windows, Linux, and Mac Lori Kaufman April 28, 2012, 12:00pm EDT We all use text editors to take notes, save web addresses, write code, as well as other uses. Geany is a small and lightweight Integrated Development Environment. It was developed to provide a small and fast IDE, which has only a few dependencies from other packages. Sublime Text. Sublime Text is a sophisticated text editor for code, html and prose - any kind of text file. You'll love the slick user interface and extraordinary features. Download geany for windows.

Check the 'Wrap text' checkbox. Now when you return to the spreadsheet, you will need to manually adjust the height of the row that contains the merged cells. To do this, position your mouse pointer over the bottom of the row until a double arrowed pointer appears. Then hold down the left mouse button and drag downward. Release the left mouse button when the row is the desired height.

What you want to do is to wrap the text in the current cell. You can do this manually by pressing Alt + Enter every time you want a new line. Or, you can set this as the default behaviour by pressing the Wrap Text in the Home tab on the Ribbon. Now, whenever you hit enter, it will automatically wrap the text onto a new line rather than a new cell.

Now when you view the contents of the merged cells, you will be able to see that the text is wrapping.