ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   entering data using tab (https://www.excelbanter.com/excel-discussion-misc-queries/51500-entering-data-using-tab.html)

Karen Boyd

entering data using tab
 
At one time when I pushed tab after typing data into a cell, my cursor would
move to the next column over in the same row, making that cell the active
cell. so entering in A1 -- tab moved me to B1. All is good and is what
expected.

For some reason if I enter in A1 -- tab my active cell is now H1. It is
driving me nuts. I cannot find any reference in help how to fix this, and I
don't know what I did to break it. Entering in B1 -- tab also takes me to
H1. Once I get to G1 when I tab I now end up in M1. There seems to be no
reason behind this. Any help would be appreciated. I use Excel 2003.

Debra Dalgleish

entering data using tab
 
Choose ToolsOptions
On the Transition tab, remove the check mark from Transition Navigation
keys.
Click OK

Karen Boyd wrote:
At one time when I pushed tab after typing data into a cell, my cursor would
move to the next column over in the same row, making that cell the active
cell. so entering in A1 -- tab moved me to B1. All is good and is what
expected.

For some reason if I enter in A1 -- tab my active cell is now H1. It is
driving me nuts. I cannot find any reference in help how to fix this, and I
don't know what I did to break it. Entering in B1 -- tab also takes me to
H1. Once I get to G1 when I tab I now end up in M1. There seems to be no
reason behind this. Any help would be appreciated. I use Excel 2003.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com