TAB key doesn't move from cell to cell

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

Guest

I have created a spreadsheet with permissions for users to edit ranges
(without having to enter a password). I protected the worksheet, but now as
users enter information into a cell, they cannot use the TAB key to move from
cell to cell. They are able to use the arrow keys, but old habits are hard
to break and I was wondering if there is a way to make the TAB key usable
again.
 
hi.
try this.
Tools>options>transition tab> uncheck transition navigation keys

regards
FSt1
 
Thank you for the response, but the checkboxes on that tab were already
unchecked so that didn't help solve the issue.

I did find another posting that stated that if all cells are locked (on a
protected sheet), then the TAB key won't work (it only works between unlocked
cells). Unless they are wrong, I guess I'll just have to tell my people to
get used to using the arrow keys.

Thank you again for your quick response. I do appreciate it.
 
Back
Top