all hidden rows automatically unhide

W

WHY

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?
 
D

Dave Peterson

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

In fact, I'd uncheck all these settings.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
form buttons on sheet collapse on unhide - sometimes 5
Problem with hidden rows automatically unhiding 2
Sort partially hidden data 1
Cannot unhide the hidden rows in my spreadsheet 3
Why do hidden columns/rows unhide automatically? 1
unhide row does not unhide the hidden rows 4
Automatically hide/unhide rows 5

Top