Extending table size automatically

[Mahmoudelnemr]

I have 2 tables Table1 and table11 in the attached sheet

i need them to extend automatically when a new record is entered
is it possible ?

Thanks in advance

[AliGW]

If they are real Excel tables, they will automatically extend when a new record is added at the bottom.

[Mahmoudelnemr]

If they are real Excel tables, they will automatically extend when a new record is added at the bottom.

Dear AliGW,

Thanks for your reply, They are created tables, however thy dont extend
here is a screenshot and worksheet attached above
Attachment 632906

[Mahmoudelnemr]

Attachment 632907

Row 2 is part of table, row 3 not

[AliGW]

But you haven't typed anything - you have to enter data into the first cell of the row and then the table will grow to accommodate it.

[Mahmoudelnemr]

Have u seen last screen shot ?
I typed into first row and second row

[Mahmoudelnemr]

Note the bottom right corner

Attachment 632911

[AliGW]

You haven't set your tables up correctly.

I would start again.

1. Create your headers and add one line of data (can be dummy data).
2. Select the entire range (headers and the line of dummy data).
3. Insert > table.

Once you do it correctly, it will work. You do not set up a table with a few empty rows - that's not the way to do it.

I use tables all the time - they will work, but only if you have set them up properly.

You have also set up some named ranges - you don't need these to be set up for entire columns - use just the table array.

[Mahmoudelnemr]

I foolowed the instructions it didnt the problem presists.
You are right the default is that it extends automatically, its first time for me to face this problem. but idk whats wrong with these tables in the attached file

[AliGW]

I told you what is wrong - they have been set up incorrectly. You can only fix them by converting them back to ranges and starting again. And get rid of the named ranges first.

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

[Mahmoudelnemr]

ok thank you