ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   tab problems (https://www.excelbanter.com/new-users-excel/23576-tab-problems.html)

JulieGirl

tab problems
 
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!

Max

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JulieGirl" wrote in message
...
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!




RagDyeR

<Tools <Options <Transition tab,

And *Uncheck*

"Transition Navigation Keys".
--

HTH,

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

"JulieGirl" wrote in message
...
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!




All times are GMT +1. The time now is 05:51 AM.

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