Formatting Issues

How to Fix Unwanted Line Breaks When Copying Cells in Excel

Tauseeq Magsi Oct 1, 2026 868 views

Question details

Users need to stop their system or spreadsheet application from automatically inserting extra line breaks or carriage returns when copying and pasting cell data.

How to Fix Unwanted Line Breaks When Copying Cells

Product: Excel, Windows
Device & OS: Windows 10
Scenario: Copying cell data from a spreadsheet or third-party application and pasting it into Excel, Notepad, or other text editors.
Observed behavior: A carriage return or line break is unexpectedly added to the copied content, causing the pasted text to overwrite existing data or insert unwanted blank spaces.

Before you start

Save your current work and temporarily close any active clipboard manager applications before testing your copy-paste functionality to ensure accurate troubleshooting.

Solution 1Recommended

Disable PowerToys Advanced Paste

Use this solution if you have Microsoft PowerToys installed, as its Advanced Paste feature can interfere with standard clipboard behavior and add hidden carriage returns.

Microsoft PowerToys includes an Advanced Paste module that modifies how data is stored in the Windows clipboard. Disabling this feature often resolves formatting glitches where extra line breaks are appended to copied text.

Open Microsoft PowerToys

Locate and open the Microsoft PowerToys application from your Windows system tray or the Start menu.

Navigate to Advanced Paste

In the left-hand navigation pane of the PowerToys settings window, scroll down and click on the 'Advanced Paste' section.

Toggle the Feature Off

Find the 'Enable Advanced Paste' switch and toggle it to the 'Off' position to disable the module.

Test Copy and Paste

Restart your spreadsheet application, select a cell, press Ctrl+C, and paste it into Notepad to verify that the extra line break has been removed.

Clipboard Restored: Disabling Advanced Paste immediately restores the native Windows clipboard behavior without requiring a system restart.

Solution 2

Isolate Conflicting Third-Party Applications

Use this method if disabling PowerToys does not work, as other background applications or recent software updates may be altering your clipboard data.

Free Microsoft Office alternative

Try WPS Office for Seamless and Accurate Data Handling

If recent Microsoft Excel updates or Windows clipboard glitches are disrupting your workflow with unwanted line breaks, WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy clean copy-pasting, a familiar user interface, and robust spreadsheet management without unexpected formatting errors.

1. Download WPS Office: Visit the official WPS website to download and install WPS Office Free on your Windows computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel files directly.
3. Copy and Paste Seamlessly: Highlight your data, press Ctrl+C, and paste it into any application without unexpected carriage returns.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Accurate clipboard handling prevents unwanted line breaks during copy-paste tasks.Lightweight software that runs smoothly on all Windows versions.Familiar user interface allows for a seamless transition with zero learning curve.

Frequently Asked Questions

Why does copying from a spreadsheet add a line break in Notepad?

When copying cells from a spreadsheet, the software includes structural formatting (like a carriage return) to indicate the end of a row. However, third-party clipboard managers, PowerToys, or software bugs can inadvertently duplicate these line breaks when pasting into plain text editors.

How do I paste cell data without any hidden formatting?

You can use the 'Paste Special' feature. Right-click the destination area in your application, choose 'Paste Special', and select 'Unformatted Text' or 'Values Only' to strip away invisible formatting characters like carriage returns.

Does the Windows Clipboard History feature cause extra line breaks?

By default, the native Windows Clipboard History (accessed via Win + V) does not add extra line breaks. However, if it conflicts with other active clipboard utilities like PowerToys Advanced Paste, it may result in unexpected text formatting issues during paste operations.

Document & File Issues