Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hollywood
 
Posts: n/a
Default How do I turn on "pressing enter goes to the next cell" option?

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR
 
Posts: n/a
Default How do I turn on "pressing enter goes to the next cell" option?

<Tools <Options <Edit tab,

Check "Move Selection After Enter",
And choose direction.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Hollywood" wrote in message
...
This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how
I
can re-activate this option?


  #3   Report Post  
Posted to microsoft.public.excel.misc
DNA
 
Posts: n/a
Default How do I turn on

Tools Options Edit

Check the section "Move Selection After Enter Direction"

HTH

  #4   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom
 
Posts: n/a
Default How do I turn on "pressing enter goes to the next cell" option?

tools/options/edit/move selection after enter

"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?

  #5   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default How do I turn on "pressing enter goes to the next cell" option?

Go into Tools-Options-'Edit' Tab-Make sure "Move selection after Enter" is
selected

--
Regards,
Dave


"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?



  #6   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default How do I turn on "pressing enter goes to the next cell" option?

From the menu bar, Tools Options, click the Edit tab and check the 'Move
selection after enter' box, then use the drop-down to choose which direction
to move.
--Bruce

"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?

  #7   Report Post  
Posted to microsoft.public.excel.misc
Hollywood
 
Posts: n/a
Default How do I turn on "pressing enter goes to the next cell" option?

Thanks to all who wrote in the response! =)

"Hollywood" wrote:

This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how I
can re-activate this option?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tools - Option - "move selection after enter" jules75 Excel Worksheet Functions 0 August 17th 05 10:56 PM
How do I turn on the Last Modified option when opening a file? WomensHealthUSA Excel Discussion (Misc queries) 0 June 8th 05 02:31 PM
Insert worksheet is greyed out, is there an option to turn it on? jwolf Excel Worksheet Functions 1 May 9th 05 11:22 PM
Filter option vishu Excel Discussion (Misc queries) 1 February 28th 05 01:36 PM
How do I enter a working check box option in Excel? Lisa the CPA Excel Discussion (Misc queries) 1 January 31st 05 07:07 AM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"