all hidden rows automatically unhide

G

Guest

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

Why do hidden columns/rows unhide automatically? 1
Cannot unhide the hidden rows in my spreadsheet 3
Expand and collapse rows 7
Problem with hidden rows automatically unhiding 2
Why won't my unhide command work? 5
Unhide columns 2
Identify Hidden Columns - New issue! 19
Unhide query design grid in design view. 3

Top