Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 2010 Options revert to default 1
- Thread starter tolver
- Start date
SkipVought
Programmer
hi,
I do not have 2010, but can you acually DISABLE the After prossing Enter, move selection... and NOT move the seletion from the entered cell?
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...for a NUANCE!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
Yes. In all Excel versions.
In 2010, it is File>Options>Advanced>EditingOptions
where it is the first item on the list. Uncheck the box, and the direction grays out.
On my installation, once it's turned off it stays off. (If like me you never get things right the first time, moving the cell after "enter" is a luxury you cannot afford.)
In 2010, it is File>Options>Advanced>EditingOptions
where it is the first item on the list. Uncheck the box, and the direction grays out.
On my installation, once it's turned off it stays off. (If like me you never get things right the first time, moving the cell after "enter" is a luxury you cannot afford.)
-
1
- #4
If it still keeps happening, I would suggest deleting/renaming the QAT file. You will need to apply any customizations that were set in the deleted/renamed QAT file
Canadian eh! Check out the new social forum Tek-Tips in Canada.
I thought I had retired...I was mistaken. I used to work for a large corporation; now I work for my wife.
Canadian eh! Check out the new social forum Tek-Tips in Canada.
I thought I had retired...I was mistaken. I used to work for a large corporation; now I work for my wife.
- Thread starter
- #5
Thank you!
2010 actually does not use QAT files anymore, but that information allowed me to find the information I required
The file is now an *.officeUI and is found in one of the following folders:
In Windows 7 or Vista - C:\Users\%username%\AppData\Local\Microsoft\Office
or
In Windows XP - C:\Documents and Settings\%username%\Local Settings\Application Data\Microsoft\Office (in Windows XP).
I deleted the .officeUI file and that seems to allow my settings to be 'locked in'
Thanks again, love this forum!!!
Tracey
2010 actually does not use QAT files anymore, but that information allowed me to find the information I required
The file is now an *.officeUI and is found in one of the following folders:
In Windows 7 or Vista - C:\Users\%username%\AppData\Local\Microsoft\Office
or
In Windows XP - C:\Documents and Settings\%username%\Local Settings\Application Data\Microsoft\Office (in Windows XP).
I deleted the .officeUI file and that seems to allow my settings to be 'locked in'
Thanks again, love this forum!!!
Tracey
- Status