Formulas can't hide rows or columns.

You could have some macro do it, though.

Hongch wrote:

I have a worksheet with many hidden rows & columns. However, when I try to
write a formula in this worksheet, these hidden rows & columns automatically
unhide themselves. Is there any way to disable this?

--

Dave Peterson