How to define table size

[carlos10]

I need to define the size of the table, so that the cursor goes back to the fisrt column, next row, when I insert data and reach the end of the line.

Can it be done in Excel?

Thanks in advance,

[Ardus Petus]

Select ("highlight") your table.

Type in values, and validate with TAB

HTH
--
AP


"carlos10" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> I need to define the size of the table, so that the cursor goes back to
> the fisrt column, next row, when I insert data and reach the end of the
> line.
>
> Can it be done in Excel?
>
> Thanks in advance,
>
>
> --
> carlos10
> ------------------------------------------------------------------------
> carlos10's Profile:
http://www.excelforum.com/member.php...o&userid=33521
> View this thread: http://www.excelforum.com/showthread...hreadid=533113
>

[Gord Dibben]

With A1 selected, start entering data and Tab your way across to K1.

Leave K1 by hitting the Enter key. You will drop to A2.

Alternate methods of defining cell order can be found at Bob Phillips' site.

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


Gord Dibben MS Excel MVP

On Sat, 15 Apr 2006 04:01:55 -0500, carlos10
<[email protected]> wrote:

>
>I need to define the size of the table, so that the cursor goes back to
>the fisrt column, next row, when I insert data and reach the end of the
>line.
>
>Can it be done in Excel?
>
>Thanks in advance,