ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Tab Issue (https://www.excelbanter.com/excel-discussion-misc-queries/250339-excel-tab-issue.html)

bubbafouts

Excel Tab Issue
 
When I use the Tab key it jumps several columns instead of 1 column. I don't
know how it got this way, nor how to get it back.

Bob I

Excel Tab Issue
 
UNcheck Lotus Compatibility option

bubbafouts wrote:

When I use the Tab key it jumps several columns instead of 1 column. I don't
know how it got this way, nor how to get it back.



Tom Hutchins

Excel Tab Issue
 
In Excel 2003 & earlier:
Tools Options Transition tab uncheck transition navigation keys.

In Excel 2007 it's Office Button Excel Options Advanced.
Lotus Compatibility is down towards the bottom.

Hope this helps,

Hutch

"bubbafouts" wrote:

When I use the Tab key it jumps several columns instead of 1 column. I don't
know how it got this way, nor how to get it back.


William

Excel Tab Issue
 
It may be that the columns, or the cells in the columns you wish to jump to,
are locked. This will cause the cursor to jump cells (or columns or rows).

Check if they are protected by going to Tools/Protection/Unprotect.

--
William


"bubbafouts" wrote:

When I use the Tab key it jumps several columns instead of 1 column. I don't
know how it got this way, nor how to get it back.



All times are GMT +1. The time now is 06:48 PM.

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