ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I've protected a wksht and now I can't tab from column to column (https://www.excelbanter.com/excel-worksheet-functions/51236-ive-protected-wksht-now-i-cant-tab-column-column.html)

carol b

I've protected a wksht and now I can't tab from column to column
 
What is causing this? How do I fix it?

jahoobob

I've protected a wksht and now I can't tab from column to column
 

Unprotect the worksheet. Select the entire worksheet and then uncheck
Locked when you go to Format, Cells, Protection. Select the column(s)
you want protected and check Locked when you go to Format, Cells,
Protection. When you go to protect it again, make sure that Select
unlocked cells is checked (Excel 2003)
carol b Wrote:
What is causing this? How do I fix it?



--
jahoobob

Daniel CHEN

I've protected a wksht and now I can't tab from column to column
 
it seems like that is the default setting of EXCEL once you protect your
sheets, you can not use tab key.

"carol b" <carol wrote in message
...
What is causing this? How do I fix it?





All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com