Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carlos10
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a reference table and have different size cells bill Excel Discussion (Misc queries) 0 January 16th 06 09:53 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
Pivot table - size of file? carolyn Excel Discussion (Misc queries) 1 June 17th 05 05:58 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"