Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden rows unhide themselves when formulas are written
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden rows unhide themselves when formulas are written
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden rows unhide themselves when formulas are written
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 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden rows unhide themselves when formulas are written
Oops. I misread your intent.
Try tools|options|transition tab|Uncheck "Transition navigation keys" (I'd uncheck all those options.) Dave Peterson wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Radom hidden rows | Excel Discussion (Misc queries) | |||
Can't See Rows (not hidden) | Excel Discussion (Misc queries) | |||
Can't See Rows (not hidden) | Excel Discussion (Misc queries) | |||
Unhide rows | Excel Discussion (Misc queries) | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) |