If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|