ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i change the number of cells advanced when pressing tab (https://www.excelbanter.com/excel-discussion-misc-queries/113653-how-do-i-change-number-cells-advanced-when-pressing-tab.html)

Jesse

how do i change the number of cells advanced when pressing tab
 
hello. i used to be able to advance to the right by one cell when pressing
tab.

now, if i am in column A, for instance, and i hit tab, it jumps
automatically to column K. this has happened on a couple of different
machines in my office.

does anyone know how to change this?

thanks,
jesse

David Biddulph

how do i change the number of cells advanced when pressing tab
 
"jesse" wrote in message
...
hello. i used to be able to advance to the right by one cell when
pressing
tab.

now, if i am in column A, for instance, and i hit tab, it jumps
automatically to column K. this has happened on a couple of different
machines in my office.

does anyone know how to change this?


Tools/ Options/ Transition:
Unset: Transition navigation keys.
--
David Biddulph



Gord Dibben

how do i change the number of cells advanced when pressing tab
 
jesse

ToolsOptionsTransition.

Uncheck "Transition navigation keys"

Might as well uncheck the two below that also.


Gord Dibben MS Excel MVP

On Tue, 10 Oct 2006 08:49:04 -0700, jesse
wrote:

hello. i used to be able to advance to the right by one cell when pressing
tab.

now, if i am in column A, for instance, and i hit tab, it jumps
automatically to column K. this has happened on a couple of different
machines in my office.

does anyone know how to change this?

thanks,
jesse




All times are GMT +1. The time now is 02:19 AM.

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