Protect sheet with TAB key enable

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.


Jayesh Soni


Question Info

Last updated December 8, 2019 Views 4,109 Applies to:
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.

16 people were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.