![]() |
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 |
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 |
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