Share via

Protect sheet with TAB key enable

Anonymous
2011-10-19T09:07:23+00:00

I am using protect sheet option with some reference edit allow range. I want protect sheet with TAB Key enable. How can I enable TAB key with protect sheet option.

Thanks

Jayesh Soni

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-10-20T09:13:26+00:00

    The cells must be unlocked in order to tab to them when the sheet is protected.

    ·         Select the cells you want to allow editing.

    ·         Right click and choose Format Cells

    ·         Under Protection tab, uncheck "Locked." The Tab should move to the unlocked cells.

    Was this answer helpful?

    50+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-07-27T16:05:53+00:00

    But unlocking those cells makes it so they are no longer protected? How is that a solution to this issue? I should be able to tab among protected cells....

    Was this answer helpful?

    40+ people found this answer helpful.
    0 comments
  2. Anonymous
    2015-10-28T06:38:29+00:00

    Thank you very much!

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2016-07-31T15:58:59+00:00

    Thanks I searched the web and could not find a good solution then came across this, issue resolved thanks very much.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2011-10-21T07:29:08+00:00

    my problem has been solved.

    thanks

    Jayesh Soni

    Was this answer helpful?

    0 comments