I have a bunch of validation comboboxes on this excel spreadsheet. Because I
have the columns so small, it will not show the full length. Is there a way
for it to automatically expand?

Or is there a way to get the cells in a freeze frame to not be affected by
the resize of a column although it's in the same column?