Excel Text on Multiple Lines in One Cell: How to Do It

How-to basics · Updated November 18, 2026

To put text on multiple lines in one Excel cell, select the cell, start editing it, and press Alt+Enter on Windows where you want a new line. On a Mac, use Control+Option+Return. Turn on Home > Wrap Text if the lines do not display as expected.

What a line break in a cell does

A line break creates a new line inside the contents of one cell; it does not move text into another cell. For example, a single cell can contain a person’s name on the first line and a job title on the second. The cell remains one value for sorting, copying, formulas, and data entry, even though it appears on multiple lines.

This is different from letting Excel wrap text automatically. Wrapping moves text to another visible line when it reaches the cell’s edge, based on the column width. A manual line break puts a new line at a particular point regardless of where the text would otherwise wrap. You can use both together: insert breaks to control the layout, then enable Wrap Text so the cell can show its contents.

Line breaks are useful for compact labels, addresses, instructions, or short notes. They are generally less suitable when each piece of information needs to be sorted, filtered, calculated, or analyzed separately. If a cell contains a city, state, and postal code as separate lines, for example, consider whether those details would be more useful in separate columns.

Insert a line break with the keyboard

In Excel for Microsoft 365 on Windows, double-click the cell or select it and press F2 to edit its contents. Click or use the arrow keys to position the insertion point, then press Alt+Enter. Type the next line and press Enter when you are finished editing.

  1. Select the cell you want to edit.
  2. Double-click it, or press F2, and place the cursor where the next line should begin.
  3. Press Alt+Enter on Windows. On a Mac, press Control+Option+Return.
  4. Continue typing, then press Enter to commit the cell’s contents.
  5. If needed, select the cell and choose Home > Wrap Text.

If you are entering new content from scratch, you can type the first line, use the shortcut, and continue with the next line. If you are editing existing text, make sure the cell is in edit mode and that the cursor is at the intended position. Selecting a cell without entering edit mode and pressing the shortcut may not put the break where you expect.

On Excel for the web, keyboard behavior can depend on the browser and operating system. Try the Windows shortcut while editing the cell; if it is intercepted or does not work, use the web app’s available editing controls or open the workbook in the desktop app. Shortcuts can also vary with keyboard layout and remote-desktop software.

Show all lines with Wrap Text and row height

A line break can be present in a cell even when the row does not visibly show every line. Select the cell and choose Home > Wrap Text. Excel will display content on multiple visible lines within the column width. If the row is too short, increase its height by dragging the boundary below the row number, or use Home > Format > AutoFit Row Height.

AutoFit is often the quickest fix after adding a break, but it does not work perfectly in every layout. Merged cells are a common exception: Excel may not automatically calculate the height needed to show all wrapped text in a merged area. You may need to set the row height manually or avoid merging cells. A narrow column can also create additional automatic wrapping beyond the manual breaks, so widening the column may make the result easier to read.

  • Text is cut off: enable Wrap Text and check the row height.
  • There is too much wrapping: widen the column or shorten the text.
  • Lines appear crowded: increase the row height or adjust the font size.
  • Several cells need the same setting: select them together before choosing Wrap Text.

Wrap Text is a display setting, not a command that inserts a fixed break into the stored text. If you change the column width, wrapped lines may shift. A manual break stays at its position in the text, although the surrounding content can still wrap differently.

Combine text from cells with a formula

A formula can place a line break between text values, which is useful when a result should update automatically as its source cells change. With a first name in A2 and a last name in B2, enter =A2&CHAR(10)&B2 in another cell. If A2 contains Ava and B2 contains Chen, the result is Ava on the first line and Chen on the second. Select the formula cell and turn on Wrap Text to display the break.

CHAR(10) supplies the line-feed character used for a line break in an Excel cell. The formula result is still a single cell value. If you do not see separate lines, first check Wrap Text and the row height. Also check that both referenced cells contain the expected text; a blank source cell can leave an apparently empty line or make the output look different than intended.

For more than two pieces of text, join each item with a line-break character. With headings in A2, B2, and C2, a formula such as =A2&CHAR(10)&B2&CHAR(10)&C2 puts each heading on its own line. This approach is convenient for a small, fixed set of cells. For larger datasets, keeping the values in separate columns is usually easier to maintain and analyze.

Paste text that already has multiple lines

You can paste text containing line breaks into a cell, but the result depends on how you copy it. If the copied text is a single block with internal line breaks, Excel may place those breaks inside one cell. If you copy several rows or cells, Excel will usually distribute them across the worksheet grid instead. Before pasting a large block, check whether the source is one text field or a table with separate records.

Text copied from a web page, email, or document may contain line breaks, tabs, or other formatting that changes how it lands in Excel. If a paste creates more rows or columns than expected, use Undo immediately and try copying only the specific text block. You can also paste into a plain-text editor first to inspect the line structure, then copy the cleaned text into Excel.

When importing a CSV file, line breaks inside a field are supported only when the file and the program reading it handle quoted fields correctly. A line break can otherwise be interpreted as the end of a record. If a workbook will be exchanged with another system, test the export and import path rather than assuming every application will preserve multiline cells in the same way.

Manual breaks, automatic wrapping, and separate cells

Choose the method based on what the text represents. A manual break is best when you want a deliberate layout inside one value, such as a two-line heading. Automatic wrapping is useful when a paragraph should fit a particular column but does not need fixed break points. Separate cells are usually better when the pieces represent distinct data that might be filtered, sorted, counted, or used in calculations.

  • Manual line break: controls where a new line starts in one cell.
  • Wrap Text: adjusts visible lines to the available column width.
  • Separate columns or rows: keeps distinct facts independently usable.

For example, an event label could reasonably show the event name above its location in one cell. A contact list should generally keep first name, last name, street, city, and postal code in separate fields. Putting everything in one multiline cell may look tidy, but it can make searches, mail merges, reporting, and data validation harder later.

Common problems and practical fixes

If the shortcut inserts a line break in the wrong place, enter edit mode and reposition the cursor before using it. If the content appears as one long line, turn on Wrap Text and check the row height. If a formula returns a line break but the cell still looks unchanged, the same display checks apply. The line-break character can be present without being obvious in the formula bar or in a cell with wrapping disabled.

A cell may show more lines than expected because manual breaks and automatic wrapping can work together. For example, a sentence with one manual break may occupy four visible lines in a narrow column. Widen the column to distinguish intentional breaks from width-driven wrapping. Avoid using repeated spaces to align text; spacing can shift when fonts, column widths, or device settings change.

When printing, check Print Preview because row heights, page breaks, and column widths may make a cell look different on paper than on screen. Adjust the column width or row height, and review page scaling if content is clipped. If you share the workbook, remember that recipients may view it with different column widths or fonts, so a layout that depends on exact spacing may not travel well.

Frequently Asked Questions

What is the shortcut for a new line in an Excel cell?
On Windows, edit the cell and press Alt+Enter at the point where the new line should begin. On a Mac, use Control+Option+Return.

Why is my Excel cell not showing multiple lines?
Select the cell and choose Home > Wrap Text. Then check whether the row is tall enough; use Home > Format > AutoFit Row Height or adjust it manually.

Can I add a line break in an Excel formula?
Yes. Join the text with CHAR(10), such as =A2&CHAR(10)&B2. Turn on Wrap Text in the cell containing the formula so the break is visible.

Does Wrap Text insert a permanent line break?
No. Wrap Text changes how text is displayed according to the cell width. A manually inserted break stays at a chosen point in the cell’s contents.

Can I put multiple lines in one cell and still sort the worksheet?
Yes. Excel can sort a row containing a multiline cell as part of the table. The cell remains one value, though, so its individual lines cannot be sorted or filtered as separate fields without first separating the data.

Choose a layout that stays useful

For a quick visual improvement, a manual line break plus Wrap Text is usually all you need. Use AutoFit or set row height so every line remains visible, and review the result at the column width where the workbook will be used. If the lines contain separate facts that matter for analysis, keep those facts in separate cells instead. Choosing between formatting and structured data early can save substantial cleanup when the spreadsheet grows.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.