Hidden rows/columns expand when referencing cells?

T

tink

When I use a formula referencing a cell in the same sheet or another sheet
all hidden rows and columns expand. How can I prevent this? This just
started yesterday.
 
D

Dave Peterson

In xl2003 menus...

Try Tools|Options|Transition tab|Uncheck "Transition navigation keys"
 

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

Cell data entering slow! 0
Copy addition formula of non-consecutive horizontal cells 2
Create form with checkbox les that expand and collapse sections of the form? 0
Drop down list control value in vba 2
Task Information Dialog Box not making duration changes to task 0
Excel --> Word 4
External cell reference between two excel worksheets both in One Drive 0
Hide columns based on row values 2

Top