Expand a table by adding rows ( table feature 2007 and later)

When using the table feature, entering values manually in the row following the last table's row expands the table.
OTH when pasting rows at the end of the table, it does not expand automatically ( or am I missing something?).

The table feature also does not allow to "Insert Copied cells".

Does anyone have a solution to this ?

Thanks for any advice

Are you pasting copying and pasting in all columns of the table or just the non-dependent columns? If you paste only the non-dependent cells (probably oneat a time) the table should populate

The table feature also does not allow to "Insert Copied cells".

Use right click --Insert -- Table rows above/below -- then copy and paste

Hope this leads you in the right direction

Hi Pepe Le Mokko..

Just a silly question.. Is it really a Table.. No I mean, I may be already "Converted to Range"..

for check try this..

Please Login or Register  to view this content.

If its really a table.. then.. Insert Copied Cell will not available.. but you can do this by Ctrl + Shift + "+"

and if its already a Table then Convert to range and recreate the table.. or try to search for "_|" End Table sign (a Small Right Bottom Corner sign) and drag it upto last celll.. may be it was in between a table...not at the end of table..

Thanks for your input.
It is as you say a "real table" so "Inserted copied cells" is not available.
Inserting "above/below" does not help either, the number of rows being variable and the table must be updated monthly