tab button not working in excel

T

Traci

Help! I've done something weird in an excel spreadsheet. I don't know what
I did, but the tab key stopped working. I reset the transition key checkmark
in tools>options>transition, and now it tabs, but it not from field to
field...meaning instead of going from A1 to B1, it goes from A1 to Q1 or W1!!
I don't think it is password protected, although I am not the only user to
have acess to it. Any ideas would be GREATLY APPRECIATED!!!!
 
N

Nick Hodge

Traci

If any of the cells are unlocked (Format>Cells...>Protection>Locked =
unchecked) and the worksheet locked then the tab key will tab between cells
that are unlocked. Is this the default behaviour in a new workbook?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

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

Code to format cells on several worksheets 2
Linking data in MS Word into Excel 5
Grayed out Tab in Excel 2
Refreshing Pivot Table on a protected spreadsheet tab 1
tab between protected cells 3
Problem tabbing between merged cells in Excel 2010 0
Password protect individual tabs in an excel spreadsheet 1
cannot tab to next unlocked cell 0

Top