My spreadsheet in some cases automatically adds a row below how?

D

dister

I have a spreadsheet that tracks certain data. The tracking is broken down
into 4 sections each section having 10 rows. For the first section if i go to
the end of the row there are two blank rows as soon as i add any data to one
of the blank rows, excel automatically adds a row below that section. How
does it do that? I would like to do the same to the rest of the sections.
 
G

Gord Dibben

If Excel 2007 sounds like you have "Tables" from Insert>Table

If Excel 2003 it would be "Lists" from Data>List>Create List


Gord Dibben MS Excel MVP
 
D

dister

I did have a list so that i can drop down the different issues, but it
appears to be a partial list.
 
G

Gord Dibben

Which version of Excel?

Are your sections outlined with a blue border?

If you go to Data>List what is available for selection?


Gord
 
D

dister

I am using 2007 with the Tables feature. The original spreadsheet was
created in 2003. I am currently trying to figure out how a cell can
automatically be added using 2007. I have created a new table but am still
struggling to have excel automatically add an additional row as i add data.
D
 
Top