I have a spreadsheet where I have various formula columns
hidden. When I attempt to insert a formula in any of the
unhidden cells, it automatically unhides the hidden
columns, which is dramatically slowing down the
spreadsheet development process.

Any ideas? Is there a setting that I could toggle on-off?