Excel ALT+ENTER - did this go away?

%3CLINGO-SUB%20id%3D%22lingo-sub-1272426%22%20slang%3D%22en-US%22%3EExcel%20ALT%2BENTER%20-%20did%20this%20go%20away%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1272426%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20some%20reason%2C%20I%20cannot%20be%20in%20a%20cell%20and%20use%20ALT%2BENTER%20to%20move%20down%20a%20line%20and%20continue%20typing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20this%20feature%20go%20away%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHelp!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-mash%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1272426%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1272438%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20ALT%2BENTER%20-%20did%20this%20go%20away%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1272438%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F604977%22%20target%3D%22_blank%22%3E%40MashPotatoes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20such%20cells%20please%20be%20sure%20Wrap%20text%20is%20set%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20273px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F181327i010FB9DE6462CFA9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1272452%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20ALT%2BENTER%20-%20did%20this%20go%20away%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1272452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BHi%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20have%20wrap%20text%20set.%26nbsp%3B%20This%20is%20a%20simple%20spreadsheet%20I%20have%20used%20for%20some%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20name%2C%20addresses%20listed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20like%20to%20track%20updated%20info%20w%2Fa%20date%20off%20to%20the%20side.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-mash%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1272486%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20ALT%2BENTER%20-%20did%20this%20go%20away%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1272486%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthe%20only%20work%20around%20is%20adding%20a%20bunch%20of%20spaces.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20think%20of%20anything%20else%2C%20please%20let%20me%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3Emash%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1272467%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20ALT%2BENTER%20-%20did%20this%20go%20away%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1272467%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20the%20info%20looks%20like%20in%20the%20text%20bar%20on%20top%20of%20the%20spreadsheet%3A%3C%2FP%3E%3CP%3E04012020%20Emailed%20for%20update%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2012152019%20New%20Customer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20how%20the%20info%20should%20look%20inside%20the%20cell%3A%3C%2FP%3E%3CP%3E04012020%20Emailed%20for%20update%3C%2FP%3E%3CP%3E12152019%20New%20Customer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-mash%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

For some reason, I cannot be in a cell and use ALT+ENTER to move down a line and continue typing.

 

Did this feature go away?


Help!

 

Thanks -mash

16 Replies
Highlighted

@MashPotatoes 

For such cells please be sure Wrap text is set

image.png

Highlighted

@Sergei Baklan Hi there.

 

I do have wrap text set.  This is a simple spreadsheet I have used for some time.

 

I have name, addresses listed.

 

I like to track updated info w/a date off to the side. 

 

Thanks -mash

Highlighted

@Sergei Baklan 

This is what the info looks like in the text bar on top of the spreadsheet:

04012020 Emailed for update                                    12152019 New Customer

 

This is how the info should look inside the cell:

04012020 Emailed for update

12152019 New Customer

 

Thanks -mash

Highlighted

@Sergei Baklan the only work around is adding a bunch of spaces.

 

If you think of anything else, please let me know.

 

Best,

mash

Highlighted

@MashPotatoes 

Do you mean it shall be as in the bottom cell?

image.png

 

Highlighted

@Sergei Baklan I'm hoping for items to be entered one on top of the other like an itemized list:

1. data <ALT+ENTER>

2. data <ALT+ENTER>

3. data <ALT+ENTER>

 

and so on.

 

ALT+ENTER is not working.

Highlighted

@MashPotatoes 

Another attempt

image.png

Above is with Alt+Enter

Highlighted

@Sergei Baklan Yes... it's not working on my end even with wrap text in alignment format.

Highlighted

@MashPotatoes 

Is that Excel for Windows Desktop or more exotic one?

Highlighted

@MashPotatoes 

Try to open attached file with the sample from previous answer if it works with you

Highlighted

By chance, are you accessing Excel via Remote Desktop?  I've seen the behavior you've described when someone was using Excel in this capacity.  Alt+enter would not work at all.

Highlighted
Highlighted

@Patrick2788 No.. just from my laptop.

Highlighted
After shutting down computer, restarting, same problem.

I went into Excel and checked for an update (even though I receive updates all the time). Update found, computer restarted and VIOLA... ALT+ENTER works now.

Hopefully this will help someone... I was spinning my wheels today trying to figure out.

v/r,
mash
Highlighted

@Sergei Baklan 

After shutting down computer, restarting, same problem.

I went into Excel and checked for an update (even though I receive updates all the time). Update found, computer restarted and VIOLA... ALT+ENTER works now.

Hopefully this will help someone... I was spinning my wheels today trying to figure out.

v/r,
mash

Highlighted

@Patrick2788 

After shutting down computer, restarting, same problem.

I went into Excel and checked for an update (even though I receive updates all the time). Update found, computer restarted and VIOLA... ALT+ENTER works now.

Hopefully this will help someone... I was spinning my wheels today trying to figure out.

v/r,
mash