Keep hidden columns hidden when entering formulas

I have a spreadsheet with dozens of hidden columns.

When I go to enter any formula the hidden columns open up and then it's very difficult to find the cells I want to reference within my formula.

Is there any way to keep the hidden columns "closed" when entering formulas?

Thanks

Very odd. Can you post a sanitized example?