How can I use the tab button after protecting the worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Once I have protected the worksheet, I can't use the tab button to move from
cell to cell. Any ideas.
 
Joanne,

You can only tab to cells that are UNLOCKED after protection.

Make sure the sheet is NOT protected. Select all the cells that you
want to be able to change when the sheet is protected (i.e. cells w/o
formulas, titles, or column/row lables), click Format>Cells... (Ctrl +
1), go to the Protection tab, and make sure that the Locked checkbox
is unchecked.

hope this helps,

Conan
 
Can you not use your arrow keys? they still work under protection.

Chris
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
Excel Move or Copy Stopped Working? 0
Tab Key 1
Protected worksheet/tab key 2
Using tab key in protected worksheet 4
Tabbing on a Protected worksheet 3
How do I put a formula into an unlocked cell on protected workshee 1
Allow user to change the state of ("click" in) check-boxes on protected worksheets? 2

Back
Top