how do I set tabs in Microsoft Office Excel 2007?

[coxyk]

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

 

[Gaurav]

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

 

[Norm]

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]

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.

 

[David Biddulph]

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

 

[Gord Dibben]

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