software

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

Formulas can't hide rows or columns.

You could have some macro do it, though.

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

--

Dave Peterson

I cannot replicate this behavior on Excel 2003

How are you hiding the rows and columns?

Manually or by autofilter or via code?

Where do you enter the formula that unhides everything?

I would suggest you have some event code running that does the unhiding.Gord Dibben MS Excel MVP

On Wed, 18 Jan 2006 23:48:02 -0800, Hongch gt;
wrote:

gt;I have a worksheet with many hidden rows amp; columns. However, when I try to
gt;write a formula in this worksheet, these hidden rows amp; columns automatically
gt;unhide themselves. Is there any way to disable this?Oops. I misread your intent.

Try tools|options|transition tab|Uncheck quot;Transition navigation keysquot;

(I'd uncheck all those options.)

Dave Peterson wrote:
gt;
gt; Formulas can't hide rows or columns.
gt;
gt; You could have some macro do it, though.
gt;
gt; Hongch wrote:
gt; gt;
gt; gt; I have a worksheet with many hidden rows amp; columns. However, when I try to
gt; gt; write a formula in this worksheet, these hidden rows amp; columns automatically
gt; gt; unhide themselves. Is there any way to disable this?
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson