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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
12,609
Office Version
  1. 365
Platform
  1. 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
12,609
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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.
 

zubair99

New Member
Joined
Aug 8, 2015
Messages
49

ADVERTISEMENT

no Add-in installed
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
12,609
Office Version
  1. 365
Platform
  1. 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,980
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,129,479
Messages
5,636,574
Members
416,925
Latest member
malamutus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top