ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I set tabs in Microsoft Office Excel 2007? (https://www.excelbanter.com/excel-worksheet-functions/180906-how-do-i-set-tabs-microsoft-office-excel-2007-a.html)

coxyk

how do I set tabs in Microsoft Office Excel 2007?
 
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[_2_]

how do I set tabs in Microsoft Office Excel 2007?
 
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




Norm[_2_]

how do I set tabs in Microsoft Office Excel 2007?
 
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



coxyk

how do I set tabs in Microsoft Office Excel 2007?
 
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




David Biddulph[_2_]

how do I set tabs in Microsoft Office Excel 2007?
 
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






Gord Dibben

how do I set tabs in Microsoft Office Excel 2007?
 
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.




All times are GMT +1. The time now is 12:57 AM.

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