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

[zubair99]

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.

 

[zubair99]

anyone please help

 

[jasonb75]

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]

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]

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]

I have installed windows 7 several times.
data copied from pcloud image hosting there are only url not formatting anything from hosting website.

 

[zubair99]

no Add-in installed

 

[zubair99]

All sticky keys are disabled.

 

[jasonb75]

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]

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?