keep table from resizing when i place something in the adjacent column to the right

[maccannix]

1. I would like to stop the automatic resize of a table column with entries to the right but keep resize to the bottom
2. When excel automatically resizes table to the right, I would like the sheet to remain the same but remove the right column from the table (don't delete the data or column)

 

[HighAndWilder]

1. I would like to stop the automatic resize of a table column with entries to the right but keep resize to the bottom
2. When excel automatically resizes table to the right, I would like the sheet to remain the same but remove the right column from the table (don't delete the data or column)

I think I know what you are talking about.

I just hide the column to the right of a table and then a new column is not added when I use the column which looks like it is the next column.

 

[maccannix]

I think I know what you are talking about.

I just hide the column to the right of a table and then a new column is not added when I use the column which looks like it is the next column.

Great answer. This works well for individual tables. I just discovered that I could stop the automatic inclusion into the table by using Options, Proofing, AutoCorrect Options, AutoFormat As You Type, Apply as you work, and then turn off Include new rows and columns in tables. This option turns it off everywhere, and turns it off for rows. Your solution is great because it it specific. Thanks again.

 

[HighAndWilder]

Great answer. This works well for individual tables. I just discovered that I could stop the automatic inclusion into the table by using Options, Proofing, AutoCorrect Options, AutoFormat As You Type, Apply as you work, and then turn off Include new rows and columns in tables. This option turns it off everywhere, and turns it off for rows. Your solution is great because it it specific. Thanks again.

Thats interesting. There are so many options that I have not discovered yet. The people that wrote the Excel application are very clever people.