How To Enter A Line Break In Excel For Mac
Choose the Cell. Type the first line and press Alt+Cmd+Enter keys. Also use Control + Option + Enter or Control + Command + Enter keys to create/add a line break in the cell. Note: These keyboard keys combination work in both Excel for Mac 2011 or later versions. If you have a question about Mac Excel line break, inform us via comment. On Windows you can easily insert a line break by hitting the Alt-ENTER keys. However, while using Office for Mac these keystroke combinations.
If you have long text to enter in an Excel cell or just require pushing text to next lines for clarity or for any other reasons, you may add a new line easily.
In this tutorial, I will show you ways of adding a new line in Excel cells.
The example of new line in a cell (Windows)
While entering the text in a cell and you want next words/characters in the new line then use this short key before writing the new words you want in the next line:
Alt + Enter
The demo below shows adding a line as I am typing a word. After the word “With” the “Alt + Enter” keys are pressed and we are writing into next line.
Insert new line in Mac OS
The short key for adding a new line in the Mac OS is:
CONTROL + OPTION + RETURN
So, follow these steps in the Excel for Mac:
- Double click in the cell where you want to add a new line
- Single click in the area/letter where you want the line break
- Press the above keys i.e. CONTROL + OPTION + RETURN
For existing text in new line (Windows)
If you want to add a line in existing text, double click in the cell and single click in the area or character from where you want the new line added. Then press Alt + Enter as shown in the interactive graphic below.
In the above demo, we have pre-written text in the cell. I just double-clicked after the word “With “ and press Alt + Enter to move the next words to the next line.
For Mac users, press the CONTROL + OPTION + RETURN.
The auto wrap option
If you require new lines added automatically as the text in the cell exceeds the width then you may use the Wrap Text option.
It is full offline installer standalone setup of Softube Plug-Ins v2.2.76 Crack for 32/64. SubmitSoftube Plug-Ins v2.2.76 Free Download Latest Version for Windows. Softube mac torrent.
For that, you may select a cell, column etc. and press the Wrap Text button under the Alignment group in Home tab.
You may read about this option with screenshots in its tutorial here: Excel wrap text
Related Tutorials:
Related Articles
- 1 Get Rid of Unneeded Cells in Excel
- 2 Wrap Text in Microsoft Excel 2003
- 3 Find a DSL Modem's IP Address
- 4 Send PDF Files Via Gmail
Because Excel's primary purpose is to display, organize and calculate numerical data such as your business' profits or expenses, the 'Enter' key confirms a cell's contents and moves to the next rather than inserting a line break. If your spreadsheet's layout requires it, however, you can add line or paragraph breaks to cells through a keyboard shortcut. Adding line breaks can help make the labels for your data more readable and can even be used to create a dual-label cell.
1.Double-click the cell to which you want to add the line or paragraph break.
2.Place the text cursor in the location where you want to add the line or paragraph break.
3.Hold down the 'Control' and 'Option' keys. Press 'Enter' once for a line break or twice for a paragraph break.
Warning
- Information in this article applies to Excel for Mac 2011. It may vary slightly or significantly with other versions.
References (1)
About the Author
Laurel Storm has been writing since 2001, and helping people with technology for far longer than that. Some of her articles have been published in 'Messaggero dei Ragazzi', an Italian magazine for teenagers. She holds a Master of Arts in writing for television and new media from the University of Turin.
Photo Credits
- Dynamic Graphics Group/Dynamic Graphics Group/Getty Images