View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dister dister is offline
external usenet poster
 
Posts: 4
Default My spreadsheet in some cases automatically adds a row below ho


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
"Gord Dibben" wrote:

Which version of Excel?

Are your sections outlined with a blue border?

If you go to DataList what is available for selection?


Gord

On Tue, 7 Jul 2009 11:04:03 -0700, dister
wrote:


I did have a list so that i can drop down the different issues, but it
appears to be a partial list.
"Gord Dibben" wrote:

If Excel 2007 sounds like you have "Tables" from InsertTable

If Excel 2003 it would be "Lists" from DataListCreate List


Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 10:36:01 -0700, dister
wrote:

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.