When working with my spreadsheet, I'm unable to tab to the next cell. Ex: I
enter info into a cell in column B, then hit the Tab key and it goes over to
column Q. How can I fix my tabs so that it only tabs to the next column
cell?

Thanks.
Karen

are you sure that columns C to P are not protected?


"coxyk" wrote in message
...
When working with my spreadsheet, I'm unable to tab to the next cell. Ex:
I
enter info into a cell in column B, then hit the Tab key and it goes over
to
column Q. How can I fix my tabs so that it only tabs to the next column
cell?

Thanks.
Karen

I suspect you have the option set to do this. Go to Tools - Options, select
the Transition tab then check the Transition Navigation Keys box. If it is
checked, you will tab to the Q column by default. When unchecked, you tab
to the next adjacent column.

"coxyk" wrote in message
...
When working with my spreadsheet, I'm unable to tab to the next cell. Ex:
I
enter info into a cell in column B, then hit the Tab key and it goes over
to
column Q. How can I fix my tabs so that it only tabs to the next column
cell?

Thanks.
Karen

I have seached and cannot find where Tools - Options are. Can you direct me
please? Microsoft Office Excel 2007 is a little more complexed than the
previous version I used. Thanks.

"Norm" wrote:

I suspect you have the option set to do this. Go to Tools - Options, select
the Transition tab then check the Transition Navigation Keys box. If it is
checked, you will tab to the Q column by default. When unchecked, you tab
to the next adjacent column.

"coxyk" wrote in message
...
When working with my spreadsheet, I'm unable to tab to the next cell. Ex:
I
enter info into a cell in column B, then hit the Tab key and it goes over
to
column Q. How can I fix my tabs so that it only tabs to the next column
cell?

Thanks.
Karen

http://office.microsoft.com/en-us/ex...491511033.aspx gives
translations from 2003 to 2007.
--
David Biddulph

"coxyk" wrote in message
...
I have seached and cannot find where Tools - Options are. Can you direct
me
please? Microsoft Office Excel 2007 is a little more complexed than the
previous version I used. Thanks.

"Norm" wrote:

I suspect you have the option set to do this. Go to Tools - Options,
select
the Transition tab then check the Transition Navigation Keys box. If it
is
checked, you will tab to the Q column by default. When unchecked, you
tab
to the next adjacent column.

"coxyk" wrote in message
...
When working with my spreadsheet, I'm unable to tab to the next cell.
Ex:
I
enter info into a cell in column B, then hit the Tab key and it goes
over
to
column Q. How can I fix my tabs so that it only tabs to the next
column
cell?

Thanks.
Karen

And Ron de Bruin's site shows where the commands are located for 2007

http://www.rondebruin.nl/0307commands.htm


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 21:14:17 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

http://office.microsoft.com/en-us/ex...491511033.aspx gives
translations from 2003 to 2007.