unable to use tab on protected sheet

V

Vikky

Hi Experts;

I have a excel file with password protected sheet; I can not use tab
key on this sheet.

Is it possible that I can use tab key on a password protected sheet.

Thanks

Regards
Vikky :)
 
G

Gord Dibben

You can Tab to unlocked cells only.

Unprotect the sheet then select the cells you want to Tab to.

Format>Cells>Protection. Uncheck "locked".

Protect the sheet again and Tab to those cells.


Gord Dibben MS Excel MVP
 
V

Vikky

You can Tab to unlocked cells only.

Unprotect the sheet then select the cells you want to Tab to.

Format>Cells>Protection. Uncheck "locked".

Protect the sheet again and Tab to those cells.

Gord Dibben MS Excel MVP





- Show quoted text -
Click to expand...

Thanks A lot Gord it's working.
 
Top