Shift + Enter moves up one cell

[Loomah]

Hi All
Using xl97(sr2) on NT4(sp6) I'm trying to enter text onto 2 (or more) lines in one cell.

Normally SHIFT+ENTER does the job but it isn't working here! I end up just moving to the cell above!!!

Anyone ever seen this "feature" before or am I just luck?

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[MJPPaba]

Take a look at the [options]menu..[Edit] tab is the box next to the 'move selection after enter' set to UP?

if so change to Down or what ever.

Matthew

crazy times call for crazy people


CrazyPabs


sometimes I wonder why I even bova...

 

[xlbo]

erm

ALT+ENTER creates a new line in the same cell - SHIFT+ENTER has always worked like that AFAIK

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[MJPPaba]

Sorry I mis read the question

crazy times call for crazy people


CrazyPabs


sometimes I wonder why I even bova...

 

[TonyJollans]

Hi Loomah,

Damned confusing, all the shortcut keys in different Office apps, but SHIFT+ENTER in built into Excel (97 to 2003 certainly) and moves in the opposite direction to ENTER alone (which is set under Tools > Options > Edit tab). What you want is ALT+ENTER.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Loomah]

Tony/xlbo

I knew that! I just wanted to make sure you were on your toes!

I'm not in the least bit embarrassed at my blatant stupidity!

Honest. I cant really feel my face turning red despite the fact you can't see me!


;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[SkipVought]

Hey Loomah,

You look "tan" but not rested. What did you do on your "vacation?" ;-)

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[xlbo]

Obviously been celebrating CSKA London's Carling Cop victory too much !!

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question