[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Cursor Movement when hitting "Enter"

Posted on 2010-08-19
7
Medium Priority
?
279 Views
Last Modified: 2012-05-10
How do I change where the cursor moves when I hit "Enter"?
0
Comment
Question by:Bright01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 33474279
In 2003 and prior: Tools-Options-Edit tab.
In 2007: Office button-Excel options-Advanced section, first option.
0
 

Expert Comment

by:siyi23
ID: 33474304
I don't which Office version you are using, but I'm going to answer for Excel 2007.

Go to 'Office button' and click 'Excel options' button (right bottom corner). A new window will be opened.
Click on 'Advanced' and you will see a list of checkboxs, and the first one says 'After pushing Enter, move selection'. The you can choose the direction.

Excuse me if the messages aren't exactly real, but I have Spanish version.
0
 

Author Comment

by:Bright01
ID: 33476243
Rorya and siys23,
I only want the cursor to move down in one section of the sheet while keeping the cursor "standard" in the rest of the sheet.  Can I control the cursor at the cell level?
Thanks,
B.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 33476559
Only with code, if that's an option. (we'd need to know which ranges)
0
 

Author Comment

by:Bright01
ID: 33476726
Is it simple (a few lines) or a major undertaking?  I can plug in the range and then replicate as necessary thoughout the sheet.
If difficult, I'll close out the question with the answers I have.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 1000 total points
ID: 33476840
Not complicated really - you'd need a worksheet activate event and a selection change one - something like the code below.
FYI, down IS the standard.



Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, rnage("A:A")) Is Nothing Then
        Application.MoveAfterReturnDirection = xlDown
    Else
        Application.MoveAfterReturnDirection = xlRight
    End If
End Sub

Open in new window

0
 

Author Closing Comment

by:Bright01
ID: 33477423
Thank you!  Very helpful.......
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question