Combine two excel tables or just somehow add additional columns "easy way" ?

[tasic89]

I had an odd situation today. I was asked by co-worker to make her a table in excel, so she can do filter and total rows, like easy.

But than she told me she had some 3 additional columns hidden. I unhide. so next to my formatted table, i had 3 additional columns on the right side with some data to "just" add next to my already formatted table.

I just didn't knew HOW to do it in that exact moment. Now I would just put again that table into range, like to "unformat" the table, and format the table again with those additional columns... But is there any solution, like to join some columns in table afterwards, but not to add them manually (put column to the right, and than manually type the desired column(s)) ?

 

[severynm]

In the Table Design ribbon, you should see an option to Resize Table on the far left side of the ribbon, right under the name of the Table. That should work as long as everything you want to add is adjacent to the table.