Problem with hidden rows automatically unhiding

S

scarlet

When I'm linking a cell in worksheet 1 to a cell in worksheet 2, all of the
previously hidden rows in worksheet 1 automatically unhide. Can I do
something to keep the rows in worksheet 1 hidden until I manually unhide
them? Thanks!
 
M

Max

Fwiw I'm not able to replicate your scenario. When I link a cell (presumably
this cell would be visible of course) in Sheet1 to another in Sheet2, other
rows originally hidden in Sheet1 stays hidden.
 
D

Dave Peterson

Are you seeing the hidden rows/columns when you're building the formula??

And you're building the formula by typing an equal sign, then pointing and
clicking?

If yes, then turn off the Lotus Transition settings.

In xl2003 menus:
Tools|Options|Transition Tab
Uncheck all those settings.

(It's really the "transition navigation keys" setting that's the offending
setting, but I'd still turn them all off.)
 

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
hidden rows and autofill troubles 0
Prevent unhiding columns 1
Unhide a row 1
I am unable to unhide rows through the format menu. 8
HIDDEN ROWS 6
Unhiding rows in Excel 2007 5

Top