ALT + ENTER

H

Heather

I cant seem to figure out what pressing both ALT + ENTER does. I am working on a spreadsheet, and Im supposed to click on a cell and put my cursor before a certain word in the cell, and press ALT + ENTER. I know its supposed to show only the word after the cursor, but its not doing that...it does nothing at all. Help!
 
P

Peo Sjoblom

It will insert a carriage return, so if you have xxxxx xxxx and you put the
cursor between the 2 strings and do alt + enter
it will change to

xxxxx
xxxx



--

Regards,

Peo Sjoblom


Heather said:
I cant seem to figure out what pressing both ALT + ENTER does. I am
Click to expand...
working on a spreadsheet, and Im supposed to click on a cell and put my
cursor before a certain word in the cell, and press ALT + ENTER. I know its
supposed to show only the word after the cursor, but its not doing that...it
does nothing at all. Help!
 
H

Heather

I just got it to work, but I had to re-write the words that were in the cell. Is that normal?
 
D

Dave Peterson

Are you holding the Alt key and hitting enter.

(What did you do? What do you see when you're done?)
 
H

Heather

Yes. I got it to work. I just had to retype the words in the cell in order to place the cursor before the letter of the second word. Thanks for everyones help!!!!
 
D

Dave Peterson

You shouldn't have to retype the words. You should be able to just use the
mouse to position the I-beam like cursor where you want the alt-enter.

But glad you got it working.
 
D

Debra Dalgleish

To put the cursor between the words, you can click in the formula bar,
at the top of the worksheet, or double-click on the cell, or select the
cell, and press the F2 key.
 
A

Andy Brown

Yes. I got it to work. I just had to retype the words...

As Dave says, you shouldn't have to. However, over several PCs I've used in
the past, sometimes it would work sometimes not. Never figured out why.

Rgds,
Andy
 
Top