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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Making Tabs Stop - 29 Oct 2004 22:00 GMT

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?

Reply to this Message

Gord Dibben - 30 Oct 2004 00:12 GMT

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

>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?

Reply to this Message

Celtic_Avenger - 31 Oct 2004 00:09 GMT

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

Reply to this Message