Carriage Return or Line Break or ALT+Enter in Cell problem

zubair99

New Member
Joined
Aug 8, 2015
Messages
49
Why Carriage Return or Line Break or ALT+Enter adding automatically in every excel cell ?
is it a virus or corrupted excel software because I did not put anything its auto adding in every cell ?
I have reinstall office 2013 many times and windows 7 also but same problem every time.
please help thanks.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
8,970
Office Version
2019
Platform
Windows
Is it happening in just 1 workbook, in some workbooks, or in all workbooks?

Having 'Wrap text' enabled is the only reason that is should happen.
 

zubair99

New Member
Joined
Aug 8, 2015
Messages
49
I have uninstall and reinstall full software its happening in all workbook new or old.
Wrap Text working good and not solve this issue
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
8,970
Office Version
2019
Platform
Windows
If it was any kind of corruption then even if reinstalling excel didn't work, it would have been cleared when you reinstalled windows, that is assuming that you did a full clean installation rather than a repair attempt.

Eliminating the unlikely before continuing, is sticky keys on? https://en.wikipedia.org/wiki/Sticky_keys

Have you installed any excel add-ins? If so, try disabling them, does the problem still occur?

Is it happening when you type data into your sheet, when you copy and paste from another sheet, when you copy and waste web data, copy and paste from another source? If so, what is that source?

Data that you copy and paste will usually retain the source formatting, how much of it is retained depends on the source and how excel interprets that formatting.
 

zubair99

New Member
Joined
Aug 8, 2015
Messages
49
I have installed windows 7 several times.
data copied from pcloud image hosting there are only url not formatting anything from hosting website.
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
8,970
Office Version
2019
Platform
Windows
data copied from pcloud image hosting there are only url not formatting anything from hosting website.
Are you copying the url from the webpage in the same way that you would copy any other text, by dragging over it then copying?
Are you copying from the address bar in your browser?
Are you right clicking a link, then choosing 'copy url' from the context menu?

The first method above will copy any formatting on the page, depending on settings that formatting might not be visible in the browser.

You will most likely find that when you paste to excel, that you are pasting an unseen 'wrap text' with it. Using PasteSpecial instead of regular paste might help, but I find it to be a bit unpredictable with web data.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,257
When you say the data is auto-added, what does that mean?
Also if A1 is an offending cell, if you put =CODE(MID($A$1, COLUMN(A1), 1) in a cell and drag right, do some of the cells return 10 or 13?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,396
Messages
5,444,233
Members
405,275
Latest member
RefreshSQL

This Week's Hot Topics

Top