how to manage columns to the right of a table

I've got a number of tables in my workbook. When I try to use a column to the right of a table, it wants to become part of the table... such as automatically filling out a formula down to the bottom row of the table.

I need to be able to type in headers and create various formulas independently of the table.

Would the solution involve going into name manager and making some kind of adjustment? Or is there a better way?

Thanks!

The idea is that it does become part of the table, so formulas automatically fill rather than copying down manually.

Having said that leave a blank column then start entering your data. This will not be part of the table.

leave one column blank between original table and your new header, fill your column then delete blank column

Thanks! I was aware of the blank column but was hoping I wouldn't have to do that (retroactively, to a huge complex workbook).