unable to use tab on protected sheet

[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

 

[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

 

[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 -

Thanks A lot Gord it's working.