tab problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I press tab to move from a cell to the one next to it, instead I am
moved to the first cell to the right of what is showing on the screen. For
example, if I am in A1, press tab it jumps to P1 if I have a full screen
showing. I haven't been able to find anyone else this happens to. Please
help if you can!
 
One guess is that sheet protection** is turned on, with cols A and P left
*unprotected* (say, for data input purposes) while the intervening cols B to
O are *protected* (possibly containing formulas)
**via Tools > Protection

If so, try check and deactivate the sheet protection:
Click Tools > Protection > Unprotect Sheet
Enter password (if any) > OK
 
<Tools> <Options> <Transition> tab,

And *Uncheck*

"Transition Navigation Keys".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When I press tab to move from a cell to the one next to it, instead I am
moved to the first cell to the right of what is showing on the screen. For
example, if I am in A1, press tab it jumps to P1 if I have a full screen
showing. I haven't been able to find anyone else this happens to. Please
help if you can!
 
Back
Top