• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Table will not auto update and add new data into the table

Hi there

Have a table in Excel it does not when I add data underneaththis and press control t it will not add it to the table and the setting areticked for it to automatically update the data add but it will not do this.

Any ideas how to get my new data added to my current table?

Thanks
Leicester Fox
 

vletm

Excel Ninja
Leicester City Fox
Please, reread:
 

GraH - Guido

Well-Known Member
As it was not answered on the other forum.
Simply copy/pasting underneath an existing table will resize the table automatically. No need to CTRL+T. That is required to convert a range to a table.
If your table has a total row, you paste by selecting the first cell of the total row. The new rows are inserted while keeping the total row alive, so to speak.
 
As it was not answered on the other forum.
Simply copy/pasting underneath an existing table will resize the table automatically. No need to CTRL+T. That is required to convert a range to a table.
If your table has a total row, you paste by selecting the first cell of the total row. The new rows are inserted while keeping the total row alive, so to speak.
Hi GraH Guido

Thank you for Replying this work :)

Many Thanks

Leicester Fox :)
 
Top