Saturday, January 27, 2018

Alt + Enter Carriage Return Not Working

WHY IS MY ALT + ENTER NOT WORKING?


I recently was asked by someone why the ALT + Enter keyboard combination was not working.  Usually ALT + Enter would create a carriage return in a cell so it would look something like this:

Tried to check to see if word wrap was turned on in the cell. It was checked so that was not the issue.

Tried to check if Edit mode (press F2 or click in the formula bar when you have the cell selected).  That was not the issue.
Check to see if any “strange” add-on or macros were set.  None.

I asked to have the file sent to my computer and it worked.  But on the other computer it did not work.
The last bullet was a clue!  Apparently the way the other person’s keyboard set up was not for English (United States) – US.  Once we set this back to English…it worked!  So the windows to set this up is under Control Panel > Region and Language.

In the Region and Language window, click the Keyboard and Languages tab and click the Change keyboards… button. 

The Text Services and Input Languages window will appear. In the General tab, make sure the English (United States) – US option is selected.

After this was modified, ALT + Enter worked to add any carriage returns..

34 comments:

  1. very good! I need to adopt similar idea to scrolling months now need work out how to change the month label.

    ReplyDelete
    Replies
    1. Hello
      We saw your You tube Channel and that excel video very good an relevant. We would like to contact you to suggests or make a video of our site also same way with mutual benefit

      https://onlinecheckwriter.com

      Delete
    2. Machine Learning Projects for Final Year machine learning projects for final year

      Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.

      Python Training in Chennai Python Training in Chennai Angular Training Project Centers in Chennai

      Delete
  2. hello there , first i want to thank you guys about this amazing and helpful videos it really impacted me as an engineer , i really need your help about something that if i pulled it right it gonna help me alot in my work, what i want to make is to make a table from a table, i want to make is to make a lookup depends on the "Task" Number, but it's only gonna bring the first one that it will find , i want to multi-"Type" if exist as i showed in the picture in the empty one for example if i make a vlookup to the "Task" 8, its gonna give me the "Type" (Windows) but Task 8 have windows and Doors , there is a lot of windows and alot of doors i want him to put in the table at the task 8 for example (1st Type = Window , 2nd Type = Doors), hopefully u guys understand me and sorry for my weal language , thanks a million

    ReplyDelete
  3. Best Advanced Excel Training in bangalore offered by myTectra. India's No.1 Advanced MS Excel Institute. Classroom, Online and Corporate training
    excel training in bangalore

    ReplyDelete
  4. Optionally yet in any case critical, team building works out, when done accurately and picked well considering a reasonable goal can make a work put a more agreeable one for representatives and a glad specialist will probably feel boosted, invigorated and propelled to upgrade the efficiency of the organization. Skillsfuture courses

    ReplyDelete
  5. Thank you...it's works. It's been a while I have this issue and now it's done.

    ReplyDelete
  6. I have enjoyed reading your post,it looks very attractive.Thanks for sharing some useful information.Tableau can help anyone see and understand their data.Get Tableau certification from our institute.
    Best tableau training institutes in Bangalore

    ReplyDelete
  7. worked ..thanks a ton ..language region india was prbolem ..once done to US English ..it worked like a charm

    ReplyDelete
  8. Just read your blog.Good one. I liked it. as we provide hydroponics singapoore at affordable prices. for more info visit our website.

    ReplyDelete
  9. Thanks for sharing, it really worked

    ReplyDelete
  10. Fantastic post as well as great guidance! This article is very useful and helpful for us. Thanks for spreading valuable info. Download KineMaster Gold

    ReplyDelete
  11. In our school tagore public school in jaipur all teachers learn basic to advance use of every tool of microsoft.

    ReplyDelete
  12. How is NUMS Syllabus MBBS merit calculated?
    Marks in Entrance Test x 1100 x 0.50 = 50% Admission test. 50% of HSSC + 50% of admission = aggregate marks. Aggregate percentage = aggregate mark x 100.

    ReplyDelete
  13. very good! I need to adopt similar idea to scrolling months now need work out how to change the month label. Kinemaster Gold

    ReplyDelete
  14. Such a great blog site: There's magic in your words. Whenever you write a blog, you grab the attention of your audience. Your efforts should be appreciated. Eligible citizens can fill the online visa application form Turkey to enter the country.

    ReplyDelete
  15. Nice blog! I need to adopt similar idea to scrolling months now need work out how to change the month label. og whatsapp

    ReplyDelete
  16. This is a very useful article. You can apply for e visas for India via the electronic visa India website.

    ReplyDelete
  17. I generally check this kind of article and I found your article which is related to my interest.Ethical Job Bangladesh Genuinely it is good and instructive information. Thankful to you for sharing an article like this.

    ReplyDelete
  18. Revit No cost Download to care you to direct data into sympathetic and acquire commercial regard at each increase for all period Revit is actual physical and architectural wonderful job software. You could potentially Revit cost-free download in community cause 9. https://freeprosoftz.com/autodesk-revit-crack-key/

    ReplyDelete
  19. Windows 10 Activator Extreme is a tool that locates manufacture and retail keys in many servers for Windows 10 with a broad range of scatterings.
    Windows 10 Activator
    windows 11 activator
    Windows 7 Ultimate Product Key
    windows 8.1 product key

    ReplyDelete
  20. This comment has been removed by the author.

    ReplyDelete

  21. Today, I was just browsing along and came across your blog.Just wanted to say good blog and this article helped me a lot.. If you are willing to travel to India, you will need a visa. Apply for an e visa to an Indian online. Do you have any questions regarding e Visa India documents? You can find all frequently asked questions with the answers on eta Indian e visa website. You can also contact the visa support center by phone or by email. Apply for your visa easily and quickly.

    ReplyDelete
  22. i'm unequipped for perusing articles online especially every now and again, but Im cheerful I did these days. it is chosen dexterously composed, and your focuses are skillfully communicated. I request you agreeably, engage, dont at any point lower composing.! Sai2 Crack

    ReplyDelete
  23. Hii friends, I wanted to write a little Info related to Visa. Are you interested in traveling to any country? Yes, you can e visa apply online . You can fill out your visa application form online within 5 to 10 minutes via our Visacent website. We offer visas to citizens of over 190 countries. You can read more info about visas via our website.

    ReplyDelete
  24. Get inspired with Merry Christmas Wishes and Quotes. ... Wishing you Christmas blessings wrapped in love, tied up with joy! Merry Christmas .
    Christmas Birthday Wishes

    ReplyDelete
  25. software engineering to living since PC definition has change the initial concentration. The new duplicate of opening eight have been develop on the matching way.

    ReplyDelete
  26. This is too good article for more information visit here. If you're interested in traveling and looking for some visa company who provide best visa in uk for click here to know more. Turkey Visa

    ReplyDelete
  27. I like your all post. You have done really good work. Thank you so much for publishing such great and wonderful information which is very helpful for me now.
    Mach3 Crack
    Focusme Crack
    360 Total Security Crack
    File Viewer Plus Crack

    ReplyDelete