ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting Tab in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/15658-setting-tab-excel.html)

RabbiWife

Setting Tab in Excel
 
The tab in Excel goes from one screen to the next (eg. A1 to M1) instead of
to an adjacent cell (eg. A1 to B1). How do I correct this?

I am using Mircosoft Office XP

Gordon

RabbiWife wrote:
|| The tab in Excel goes from one screen to the next (eg. A1 to M1)
|| instead of to an adjacent cell (eg. A1 to B1). How do I correct
|| this?
||
|| I am using Mircosoft Office XP

Are columns B to L protected?

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk



Earl Kiosterud

http://www.smokeylake.com/excel/vfaq.htm,
Look at "Tab key behavior."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"RabbiWife" wrote in message
...
The tab in Excel goes from one screen to the next (eg. A1 to M1) instead
of
to an adjacent cell (eg. A1 to B1). How do I correct this?

I am using Mircosoft Office XP




Peter Rooney

Rabbiwife,

Click on Tools-Options.
Click the Transition tab
remove the tick from "Transition Navigation Keys"
This was originally a function to help users transition from Lotus 123.
I know - I'm old enough to remember!

Cheers

Pete




"Earl Kiosterud" wrote:

http://www.smokeylake.com/excel/vfaq.htm,
Look at "Tab key behavior."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"RabbiWife" wrote in message
...
The tab in Excel goes from one screen to the next (eg. A1 to M1) instead
of
to an adjacent cell (eg. A1 to B1). How do I correct this?

I am using Mircosoft Office XP





James

Setting Tab in Excel
 
Thanks - wasn't my question but I had the same problem - worked well
--
james


"Peter Rooney" wrote:

Rabbiwife,

Click on Tools-Options.
Click the Transition tab
remove the tick from "Transition Navigation Keys"
This was originally a function to help users transition from Lotus 123.
I know - I'm old enough to remember!

Cheers

Pete




"Earl Kiosterud" wrote:

http://www.smokeylake.com/excel/vfaq.htm,
Look at "Tab key behavior."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"RabbiWife" wrote in message
...
The tab in Excel goes from one screen to the next (eg. A1 to M1) instead
of
to an adjacent cell (eg. A1 to B1). How do I correct this?

I am using Mircosoft Office XP





Peter Rooney

Setting Tab in Excel
 
James,

Two years on - but you're more than welcome!

Regards

Pete


"James" wrote:

Thanks - wasn't my question but I had the same problem - worked well
--
james


"Peter Rooney" wrote:

Rabbiwife,

Click on Tools-Options.
Click the Transition tab
remove the tick from "Transition Navigation Keys"
This was originally a function to help users transition from Lotus 123.
I know - I'm old enough to remember!

Cheers

Pete




"Earl Kiosterud" wrote:

http://www.smokeylake.com/excel/vfaq.htm,
Look at "Tab key behavior."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"RabbiWife" wrote in message
...
The tab in Excel goes from one screen to the next (eg. A1 to M1) instead
of
to an adjacent cell (eg. A1 to B1). How do I correct this?

I am using Mircosoft Office XP





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

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