Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a reference table and have different size cells | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
Pivot table - size of file? | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions |