How to start a new line inside a cell in Excel

How to start a new line inside a cell in Excel

May 13, 2022 By ariannaflamini

Working in Excel, it often happens that you have to write text arranged in multiple lines and you want to start a new line of text in a cell. For those who are not particularly practical in this field or do not know how to use Excel, sometimes it happens to press the Enter key of the keyboard, but this way it is automatically moved to another cell of the spreadsheet. Actually this operation is easier than you think. This guide will explain you how to start a new line of text inside a cell in Excel. There are various options, including running a key combination on your computer’s keyboard or configuring the spreadsheet property correctly.

If you are working with your computer and you are using the desktop version of Excel for macOS or Windows or the online version, the operations to be performed are similar and what you need to do is read the next steps of the guide.

As for the combination of keys to start a new line in a cell, go to your spreadsheet, click the cell you want to insert the text into, and start typing. When you want to start a new line, press Alt+Enter on your computer keyboard at the same time.

Another method is cell formatting. You can set the Wrap Text format to all cells of your choice, where the text you type will automatically start a new line from time to time. Highlight the cells you need to work on and on which set the line break on; right-click on one of them and from the menu shown click Format Cells. Then click Alignment, click on the section Wrap Text and confirm with the button Ok.

An additional option and similar to the previous one, to start a new line in an Excel cell, is to use the Wrap Text function. You have to select the cell that contains the text and then click on the Home tab, at the top. Press Wrap Text on the left, whose icon contains letters and an arrow. This will automatically start a new line of text.

Remember to resize the cell that contains the text to make it more homogeneous with the rest of the spreadsheet. If you don’t know how to do it: click on the separator between the letter of the cell you are using and the next one and, holding down the left mouse button, expand it to the size you want.

Excel is also available in mobile version for Android, iOS and iPadOS and in a few lines I will explain how to start a new line of text in an Excel cell on both tablets and smartphones. For the tablet, select the cell where you want the text to start a new line and click on the Home tab at the top. Finally, press the Wrap Text button. While on smartphone, due to the small size of the screen, you have to press on the cell that contains the text, after which via the drop-down menu located at the bottom, you have to select Home and then Wrap Text.

Windows 11 Update: what it fixes
Windows 11 Update: what it fixes
In 1985, Microsoft Corporation produced operating environments and operating systems grouped under the name Microsoft Windows, oriented towards personal computers, servers, smartphones and workstations. Microsoft Windows took its name from the programming interface of an app with windows called File…

Microsoft Announces Xbox & Bethesda Conference for June 12
Microsoft Announces Xbox & Bethesda Conference for June 12
Microsoft formally reports when Xbox and Bethesda's double occasion will occur, prodding that it'll include a lot of games and world debuts. With E3 close to the corner, Xbox fans are more energized than any other time to see what…

Sony has disabled PlayStation Plus pre-paid code redemption
Sony has disabled PlayStation Plus pre-paid code redemption
PlayStation Plus prepaid code recovery and new buys have been crippled for existing endorsers, keeping clients from "stacking" their memberships to the paid assistance for PlayStation proprietors. The transition to hinder gamers with a functioning PS Plus membership from adding…

Windows and Android: are they really less safe than Apple?
Windows and Android: are they really less safe than Apple?
Because of malware, Windows and Android are the most at-risk platforms compared to the giant which is Apple, according to an analysis conducted by Atlas VPN. The information we have is based on a data analysis of AV-Test GmbH which…

How to add Amazon App Store on Windows 11
How to add Amazon App Store on Windows 11
Windows 11 allows you to add your most loved applications to the Taskbar, alter the Start Menu, and add the Amazon App Store. Aside from many changes, the last option allows you to run Android applications on your work area…

How to fix stuck at restart screen in Windows 11
How to fix stuck at restart screen in Windows 11
If Windows 11/10 is stuck on restarting, stacking some screen with the turning dabs liveliness moving unendingly, welcome mode, login screen, beginning Windows or won't boot, you should boot in Safe Mode or Advanced Startup Options to either investigate or…