how to disable moving down on Enter key in Excel 2007?

Posted by earlyadopter on Super User See other posts from Super User or by earlyadopter
Published on 2010-05-13T17:15:22Z Indexed on 2010/05/13 17:25 UTC
Read the original article Hit count: 243

Filed under:

excel-2007

|

preferences

|

menu

|

microsoft-office

|

office-2007

There used to be a check-box in preferences in Excel 2003 to disable moving down on Enter key after you edited a cell. Where could I find that setting in Excel 2007?

<whining on>It drives me insane how microsoft trashes users skills and "fingers" memory to make what their new users may be will find easier. What about us, using these products for ten years?<whining off>

I want to control moving around with arrow keys, and Enter to only return me from the cell editing mode to navigation, not moving down. I'm not in a data entry business!! I'm analyzing data, editing just few cells time-to-time.

© Super User or respective owner

Related posts about excel-2007

Inserting (jpg) pic inside MS Excel 2007 cell

as seen on Super User - Search for 'Super User'
Is it possible to insert a jpg image INSIDE a cell .... or do cell ONLY excel alphaNum char (or ref) ? >>> More
Conditional formatting using cell styles in Excel 2007?

as seen on Super User - Search for 'Super User'
Excel 2007 has added support for cell styles, which I find very useful. I love it when I can change formatting in one place and the change propagates throughout the spreadsheet. I also love conditional formatting. Can the two be combined? Can I conditionally apply a cell style? >>> More
FileSystemWatcher.Changed fires immediately when Excel 2007 opens XLS file in compatibility mode

as seen on Stack Overflow - Search for 'Stack Overflow'
We use a FileSystemWatcher to monitor documents opened from our Document Management system, and if the user saves the document, we ask if they would also like them updated in our system. We have a problem with XLS files in Excel 2007 (have not verified that the problem does not exist in 2003, but… >>> More
How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In

as seen on Super User - Search for 'Super User'
(cloning from question on SO) I created a function in VBA. I want Excel 2007 to show the Autocomplete when writing this function in the cell's Excel. Detail as How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In (.xlam)? ps. In Excel 2010, the autocomplete works In… >>> More
Excel 2003 charts not looking right in 2007

as seen on Super User - Search for 'Super User'
I'm not exactly sure this goes here but I don't know where else to look for help. I have some Excel files containing charts made with Excel 2003. When I open the file in Excel 2007 and save it (non 2007) is messes up the charts. However, when in Excel 2007 and I Save as a .xlsx type the charts… >>> More

Related posts about preferences

Android Preferences: How to load the default values when the user hasn't used the preferences-screen

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using a PreferenceActivity to let the user set some values. I am feeding it the xml file with the defined preferences. I have set all the android:defaultValue="" for them. When I start my application, I need the preferences, or if they are not set yet manually, I want the default values: SharedPreferences… >>> More
Reinstalled Ubuntu 12.04 and now I cannot change preferences like theme, wallpaper, and nautilus preferences

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
So I just down-rev'd ubuntu from 13.04 back to 12.04 LTS desktop 64 (Precise). I am using Unity. I just reformatted the Ubuntu partition, but kept my home directory intact, and everything seemed to reconnect just fine. No data was lost. However, I found that I cannot seem to change my preferences… >>> More
Xcode - "Preference Pane" project - how to access bundle?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have created a "Preference Pane" project. In this project I would like to load an image from my bundles resources folder. This seems difficult because "[NSBundle mainBundle]" seems to return the following: 27/12/10 9:24:18 PM System Preferences[5076] NSBundle </Applications/System Preferences… >>> More
Windows Server 2008 Directory Services, Group Policy Preferences - More Control Panel Settings

as seen on Internet.com - Search for 'Internet.com'
In Windows Server 2008, Group Policy Preferences makes it possible to reap the chief benefits of an Active Directory environment by simplifying client management. Control Panel Settings nodes in the Group Policy Management Editor makes this possible. >>> More
Formatting Keywords to UPPERCASE In Oracle SQL Developer

as seen on Oracle Blogs - Search for 'Oracle Blogs'
I received this question from a customer today, and it took me more than a few minutes to remember where this preference was located in SQL Developer. This tells me that the topic is ripe for blogging How do I go FROM: select * from scott.emp where ename like '%JEFF%' TO SELECT * FROM… >>> More