PDA

View Full Version : Tab in Excel



12-07-2001, 05:46 PM
Something has happened to my Excel settings which causes the cursor to move to Column 'L' whenever I press tab instead of moving to the next adjacent cell. I know it must be simple but where do I fix this?

12-07-2001, 06:07 PM
Do you have locked cells in the s/sheet which is protected ? If a sheet has them then the TAB key moves between unlocked cells.

12-07-2001, 06:07 PM
Do you have locked cells in the s/sheet which is protected ? If a sheet has them then the TAB key moves between unlocked cells.

12-07-2001, 06:10 PM
The Tab is taking you one full screen across.
Under Tools/Options/Transition
deselect the Transition Navigation Keys box to get back to one column per tab.