Welcome toExcel2007.Tips.Net
Helpful Links
ExcelTips
Gardening Tips
Pet Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Tab Key Doesn't Move from Cell to Cell
Summary: Normally the Tab key can be used to move from one cell to another in Excel. If this cell movement doesn't work for you, it could be because of the way you have the program configured.Craig created a form that has unlocked cells. When this form is protected he knows he should be able to use the Tab key to move from one unlocked cell to another. However, Excel isn't behaving that way; the Tab key doesn't move from cell to cell as expected. He wonders why this is happening.
More than likely the reason is rooted in how Excel is configured. Here's what you need to check:
- Click the Office button and choose Excel Options. Excel displays the Excel Options dialog box.
- Click Advanced at the left of the dialog box.
- Scroll through the options until you see the Lotus Compatibility category. (Click here to see a related figure.)
- Make sure the Transition Navigation Keys check box is unchecked.
- Click OK.
Related Tips:
Great Idea! Word is a tool to get what you really want—printed output. This means you need to make sure that Word works as well as possible with your printer, whether it is sitting on your desk or in a room down the hall. Check out WordTips: Printing and Printers today!