Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
automatically insert new rows in a list
Good Afternoon,
I use Excel 2003 in Win XP. I am creating a spreadsheet that includes multiple "CTRL + L" lists for the purposes of scheduling concerts. The lists a 1. pieces to be performed 2. musicians involved 3. rehearsal times 4. Tasks to complete When I add items to a list, it takes up a row beneath. My question: Is there a way to set up the list so that it INSERTS a NEW row instead of taking the row below? Thus, when I add to a list it pushes the other stuff down. This way there is not unused space that I must reserve for each list. I'd like to avoid leaving unnecessary blank rows. I'm a newish excel user. I carefully read other posts and the help files without finding an answer. Apologies if I'm asking a redundant question! I read info about INDEX, and "dynamic ranges" with no luck. Thanks, Brighella. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
automatically insert new rows in a list
Hi Brighella
I'm not sure I understand your problem. In XL2003, Control + L will invoke DataLists. The List object is a Dynamic table that grows in size as you add more rows to it, or if you insert rows. The "blank" line with the asterisk that appears at the bottom is merely a place marker for where the next row will go. It is not taking up extra space in the file until the row is completed. -- Regards Roger Govier "Brighella" wrote in message ... Good Afternoon, I use Excel 2003 in Win XP. I am creating a spreadsheet that includes multiple "CTRL + L" lists for the purposes of scheduling concerts. The lists a 1. pieces to be performed 2. musicians involved 3. rehearsal times 4. Tasks to complete When I add items to a list, it takes up a row beneath. My question: Is there a way to set up the list so that it INSERTS a NEW row instead of taking the row below? Thus, when I add to a list it pushes the other stuff down. This way there is not unused space that I must reserve for each list. I'd like to avoid leaving unnecessary blank rows. I'm a newish excel user. I carefully read other posts and the help files without finding an answer. Apologies if I'm asking a redundant question! I read info about INDEX, and "dynamic ranges" with no luck. Thanks, Brighella. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically insert rows with formula | Excel Worksheet Functions | |||
Automatically Insert New Rows | Excel Discussion (Misc queries) | |||
How can I set excel to automatically insert rows | Excel Worksheet Functions | |||
Automatically insert/delete rows to be x apart | Excel Discussion (Misc queries) | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) |