ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using tab key in Exel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/173133-using-tab-key-exel-2003-a.html)

Rene

Using tab key in Exel 2003
 
I'm creating a spreadsheet and want to go to the next tab to the right.
However, when I press the tab key, my cursor goes five columns over instead
of to the immediate cell on the right. I've tried the locking, unlocking,
protect, unprotect bit, but I'm not sure if I'm doing it correctly as it
still doesn't work. Help!

Kevin B

Using tab key in Exel 2003
 
Sounds like Lotus 1-2-3 navigation is in effect.

Click TOOLS in the menu and select OPTIONS. Click the TRANSITION tab in the
dialog box and if the TRANSITION NAVIGATION KEYS check box has been checked,
click the checkbox to remove.

Tab should now work as planned.
--
Kevin Backmann


"Rene" wrote:

I'm creating a spreadsheet and want to go to the next tab to the right.
However, when I press the tab key, my cursor goes five columns over instead
of to the immediate cell on the right. I've tried the locking, unlocking,
protect, unprotect bit, but I'm not sure if I'm doing it correctly as it
still doesn't work. Help!


Kevin B

Using tab key in Exel 2003
 
If you mean you wish to go to the next worksheet that would be Ctrl + PgUp to
move to the next sheet on the right or Ctrl + PgDn to move to the next sheet
on the left.
--
Kevin Backmann


"Kevin B" wrote:

Sounds like Lotus 1-2-3 navigation is in effect.

Click TOOLS in the menu and select OPTIONS. Click the TRANSITION tab in the
dialog box and if the TRANSITION NAVIGATION KEYS check box has been checked,
click the checkbox to remove.

Tab should now work as planned.
--
Kevin Backmann


"Rene" wrote:

I'm creating a spreadsheet and want to go to the next tab to the right.
However, when I press the tab key, my cursor goes five columns over instead
of to the immediate cell on the right. I've tried the locking, unlocking,
protect, unprotect bit, but I'm not sure if I'm doing it correctly as it
still doesn't work. Help!



All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com