ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to define table size (https://www.excelbanter.com/excel-worksheet-functions/83385-how-define-table-size.html)

carlos10

How to define table size
 

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


Ardus Petus

How to define table size
 
Select ("highlight") your table.

Type in values, and validate with TAB

HTH
--
AP


"carlos10" a écrit
dans le message de
...

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

How to define table size
 
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
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,




All times are GMT +1. The time now is 02:36 PM.

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