Line space in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-3115114%22%20slang%3D%22en-US%22%3ELine%20space%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3115114%22%20slang%3D%22en-US%22%3E%3CP%3EEvery%20time%20I%20try%20to%20put%20in%20a%20new%20line%20of%20text%20in%20a%20single%20cell%20(Alt%2BEnter)%2C%20it%20always%20freezes%20the%20Excel%20sheet%20and%20I%20have%20to%20come%20out%20and%20start%20again.%26nbsp%3B%20Why%20is%20this%20and%20what%20can%20I%20do%20to%20make%20it%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3115114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3115505%22%20slang%3D%22en-US%22%3ERe%3A%20Line%20space%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3115505%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296834%22%20target%3D%22_blank%22%3E%40OldBean%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EA%20question%20that%20automatically%20arises%20is%20whether%20this%20problem%20only%20occurs%20with%20certain%20worksheets%20or%20workbooks%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E...and%20not%20only.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20the%20following%20beforehand%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstall%20the%20latest%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Finstall-office-updates-2ab296f3-7f03-43a2-8e50-46de917611c5%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eupdate%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frepair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERepair%3C%2FA%3E%20Office%20programs%3C%2FP%3E%3CP%3EStart%20Office%20applications%20in%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fopen-office-apps-in-safe-mode-on-a-windows-pc-dedf944a-5f4b-4afb-a453-528af4f7ac72%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Esafe%20mode%3C%2FA%3E%3C%2FP%3E%3CP%3EIdentify%20possible%20problems%20with%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-remove-add-ins-in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eadd-in%3C%2FA%3E%3C%2FP%3E%3CP%3ECheck%20if%20the%20file%20was%20created%20by%20a%20third%20party%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20not%20helps%E2%80%A6%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20I%20recommend%20to%20provide%20more%20information.%3C%2FP%3E%3CP%3EYou'll%20get%20a%20quicker%20and%20more%20accurate%20answer%2C%20and%20those%20who%20want%20to%20help%20don't%20have%20to%20invest%20time%20guessing%20the%20problem.%3C%2FP%3E%3CP%3EI%20recommend%3A%20Always%20inform%20about%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2Fhard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%3C%2FP%3E%3CP%3EIf%20possible%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20project%20step%20by%20step%2C%20or%20add%20photos%20with%20the%20appropriate%20description.%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3EDrag%20and%20drop%20here%20or%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Freplypage%2Fboard-id%2FExcelGeneral%2Fmessage-id%2F132794%2Fattachments-key%2F47224124-c13e-45ee-ae54-dbe4f78c48ec%23%22%20target%3D%22_blank%22%3Ebrowse%3C%2FA%3E%20files%20to%20attach%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EMaximum%20size%3A%2071%20MB%20%E2%80%A2%20Maximum%20attachments%20allowed%3A%205%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EDon't%20forget%20that%20not%20every%20Excel%20user%20has%20a%20clue%20about%20every%20job%20and%20what%20you%20see%20he%20can't%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20link%20you%20will%20find%20some%20more%20information%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3121831%22%20slang%3D%22en-US%22%3ERe%3A%20Line%20space%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3121831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20repair%20the%20Office%20program%20and%20also%20started%20the%20excel%20sheet%20in%20safe%20mode%2C%20but%20the%20problem%20hasn't%20been%20resolved.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Microsoft%20Office%20Home%20and%20Student%202010%20version.%26nbsp%3B%20I%20am%20using%20Windows%2010.%26nbsp%3B%20I've%20attached%20a%20file%20that%20I'm%20trying%20to%20put%20in%20another%20row%20of%20text%20in%20a%20cell%2C%20which%20locks%20up%20the%20file%20whenever%20I%20try.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20enough%20information%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Every time I try to put in a new line of text in a single cell (Alt+Enter), it always freezes the Excel sheet and I have to come out and start again.  Why is this and what can I do to make it work?

4 Replies

@OldBean 

A question that automatically arises is whether this problem only occurs with certain worksheets or workbooks? ...and not only.

 

You can try the following beforehand

 

Install the latest update

Repair Office programs

Start Office applications in safe mode

Identify possible problems with the add-in

Check if the file was created by a third party

Hope I was able to help you with this info.

 

If this not helps…

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5
 

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE 

 

I repair the Office program and also started the excel sheet in safe mode, but the problem hasn't been resolved.

 

I have Microsoft Office Home and Student 2010 version.  I am using Windows 10.  I've attached a file that I'm trying to put in another row of text in a cell, which locks up the file whenever I try.

 

Is that enough information?

 

 

@OldBean 

Downloaded your file and tried ALT+Enter in many cells with no problem.

The line break works without problems. It not hangs or freezes no matter how I claim it.

 

Have you also tried these options?

Update Windows 10 with Update Assistant

Install the latest update

Repair Office programs

Start Office applications in safe mode

Identify possible problems with the add-in

Uninstall all add inns and try the file again

 

Don't forget....

The support for Office 2010 is ended 

If your version of Office 2010 is managed by your work or school, contact your IT Help Desk about how to upgrade. Your IT department will likely have their own upgrade plan.

If you're using Office 2010 at home, you'll still be able to use it, but we recommend you upgrade to a newer version of Office so you can stay up to date with all the latest features, patches, and security updates. To learn more about upgrading see How do I upgrade Office?

 

A solution you can, in my opinion, if you are using a newer Office version, look in Microoft Store there you can buy a  newer version according to your needs, you can also use the free web version, or you can contact your Contact your educational institution if you can get a student version there. With Office 2010 you will continue to have to deal with various bugs in the future and there are no updates and support to be expected.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

 

Thank you for your help. I'll probably buy an updated version.