View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default all hidden rows automatically unhide

Tools|Options|Transition Tab|Uncheck Transition navigation keys
(xl2003 menu system)

In fact, I'd uncheck all these settings.



WHY wrote:

I have some hidden rows and columns in my spreadsheet. When I write a
formula, eg sum(a1:b10), and click cell a1, all hidden rows and columns
automatically unhide. How do I stop the hidden rows and columns from unhiding
on their own accord?


--

Dave Peterson