How do I makd the tab go from column 'L' back to 'A' without cont.

[Guest]

After setting up a table in excel, I only use up to column 'L'. As I tab
from column to column I want the tab to revert back to 'A' after getting done
with 'L'. It just keeps going on to 'M' and farther. Can I stop it at
column 'L' and go back without using the mouse?

 

[Gord Dibben]

See Bob Phillips' site for info.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Also.......

If you start in, say A1, and TAB your way across to column L, hit the <ENTER>
key when leaving L1.

You will drop to A2.

Gord Dibben Excel MVP

On Fri, 29 Oct 2004 14:00:04 -0700, "Making Tabs Stop" <Making Tabs

 

[Celtic_Avenger]

Just a quick thought


You could set your page scroll area.

To do this.....open your workbook project VBA page

and enter the following


Worksheet_Activate()
ScrollArea = "A1:L10"

Where A1 = is the top left cell you want to allow access to and L10 i
the last cell you want access to.

When you press tab after entering Data in column L, you wil
automatically be taken to the next line but column A

Hope this helps

Celtic_Avenge