How to Paste Word Text Into One Excel Cell on Mac
Question details
The user needs to paste text copied from Microsoft Word into a single Excel cell on a Mac without the text breaking into different cells.

- Product
- Excel
- Device & OS
- Mac
- Scenario
- Copying text data from a Word document and pasting it into an Excel spreadsheet.
- Observed behavior
- When pasting normally, the copied text is split across multiple rows or columns because Excel interprets tabs, paragraph breaks, and table cells as separators.
Review the text you are copying from Word; if it contains heavy formatting, tables, or excessive tab spaces, Excel will naturally attempt to separate those elements into individual cells.
Double-Click the Destination Cell Before Pasting
Activating the cell's edit mode prevents Excel from interpreting paragraph breaks and tabs as cell dividers.
By double-clicking, you enter the active editing mode for that specific cell. This forces Excel to treat everything you paste as plain text belonging to that single cell, regardless of the paragraph formatting in the original Word document.
Highlight the desired text in your Microsoft Word document and press Command + C to copy it.
Navigate to your Excel spreadsheet on your Mac and double-click the specific cell where you want the text to go. You should see a blinking text cursor inside the cell.
Press Command + V to paste. All text will remain within the boundaries of that single cell.

Paste Text Directly into the Formula Bar
The Formula Bar acts as a plain-text input field, bypassing Excel's default grid-pasting behavior.
Remove Tabs and Paragraph Breaks in Word First
If the text still formats awkwardly, you can strip the problematic separators from the Word document before copying.
Easily Manage and Format Your Data with WPS Office
WPS Spreadsheet offers a smooth, highly compatible experience for handling data on your Mac. You can seamlessly paste Word text into a single cell, easily adjust text wrapping, and process large datasets without performance lags.
- 1. Download WPS Office: Install the free WPS Office suite on your Mac and open WPS Spreadsheet.
- 2. Copy your Word Text: Highlight your text in the WPS Writer or Microsoft Word document and copy it.
- 3. Double-click and Paste: Double-click a cell in WPS Spreadsheet until the cursor appears, then paste to keep everything in one cell.

Frequently Asked Questions
Why does Excel automatically split my copied text into multiple cells?
Excel is programmed to interpret tab characters as instructions to move to the next column, and paragraph breaks (Enter/Return) as instructions to move to the next row. This is helpful for pasting tables but causes issues when you want paragraph text in one cell.
How do I insert a manual line break inside a single Excel cell on a Mac?
If you want to manually start a new line of text within the same cell, place your cursor where you want the break and press Option + Command + Return (or Option + Return on some Mac keyboards).
What if the text is still hidden after pasting into one cell?
If the text is in one cell but cut off, you need to enable 'Wrap Text'. Click the cell, go to the Home tab on the ribbon, and click the 'Wrap Text' button. You may also need to increase the row height to see all lines.




