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.

6 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. 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