Hi
Sue,
I understand your concern about the
TAB key not working in your protected worksheet. The reason why the
TAB key is not working is that it is one of the keys that are restricted when you protect a worksheet. However, there is a way to allow the
TAB key to work while still keeping the worksheet protected.
Here are the steps to allow the
TAB key to work in a protected worksheet:
- Go to the "Review" tab in the Excel ribbon.
- Click on "Protect Sheet" in the "Changes" group.
- In the "Protect Sheet" dialog box, uncheck the "Select locked cells" option.
- Click "OK" to close the dialog box and protect the worksheet.
By unchecking the "
Select locked cells" option, you are allowing users to select and move between cells that are locked (i.e., the cells that are protected). This will enable the
TAB key to work again.