Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel TAB Problem

Old 04-30-06, 12:57 AM
  #1  
Stealth Moderator
Thread Starter
 
namja's Avatar
 
Join Date: Oct 1999
Location: High Definition
Posts: 24,967
Excel TAB Problem

When you enter data in a cell and press the Tab key, it will move the cursor one cell to the right. And that's how it's always been. Until about a couple weeks ago. Now when I hit tab, it goes from cell A1 to cell T1. If I have the Help Window opened on the right side (and the spreadsheet window is smaller), then when I hit tab, it goes from A1 to Q1.

How can I fix this?

I'm running Windows XP Pro SP2 with all the latest updates; Microsoft Excel 2003. I got no macros running.
namja is offline  
Old 04-30-06, 09:54 AM
  #2  
Senior Member
 
Join Date: Mar 2003
Posts: 789
According to a Microsoft page (http://office.microsoft.com/en-gb/as...16591033.aspx), these are the various functions for TAB:

*******************************************
TAB Moves one cell to the right in a worksheet.
Moves between unlocked cells in a protected worksheet.
Moves to the next option or option group in a dialog box.
SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.
CTRL+TAB switches to the next tab in dialog box.
CTRL+SHIFT+TAB switches to the previous tab in a dialog box.
*******************************************

So, did you by accident protect your worksheet? If so, try the following:
Select "Tools", then "Protection" and then "Unprotect sheet".

Just guessing. Let us know if it works.
LolaRennt is offline  
Old 04-30-06, 10:32 AM
  #3  
Stealth Moderator
Thread Starter
 
namja's Avatar
 
Join Date: Oct 1999
Location: High Definition
Posts: 24,967
I wish that were the case.

My problem occurs all the time, even in a brand new workbook.
namja is offline  
Old 08-22-08, 06:56 AM
  #4  
New Member
 
Join Date: Aug 2008
Posts: 1
Fix

The feature to allow page tabbing is turned on, instead of cell tabbing. To
correct this go to the Tools menu -> Options -> Transition Tab - make sure that the Transition Navigation Keys box is not checked.
bluesneone is offline  
Old 08-22-08, 09:00 AM
  #5  
DVD Talk Ultimate Edition
 
Join Date: Dec 1999
Location: Orlando, FL
Posts: 4,160
Hopefully namja's 2+ year torment of living with this problem will finally come to an end.
jdodd is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.