Lock all the columns past T

Your Tab will stop at T and go back to A one row down.


Gord Dibben MS Excel MVP


On Fri, 22 Aug 2008 13:04:00 -0700, colemererealty
wrote:

Glenn, first I used format-cell-protection-and locked out the cells within
columns a-t that I did not want to be able to type in. then I went to tools
- protection- protect sheet and checked select unlocked cells in order to
allow typing in the unlocked cells and no typing in the locked cells. Did I
do it backwards? because everything works great except when I type the TAB
key the curser goes out to the unused columns not on my page. thanks so much
for helping. colemererealty

"Glenn" wrote:

colemererealty wrote:
I am trying to make a fill in the blank worksheet for my boss. I've locked
out the cells he does not have access to and have protected the worksheet.
Now he should be able to tab through the available cells and fill in the
blanks. However the tab key takes him outside the columns I have used in the
worksheet and I cannot figure out how to stop that.

When you protected the worksheet, did you un-check "Select Locked Cells"?