How do I stop columns and rows from unhiding when I am using a fo.

F

Fishfish

Every time I use a formula to link cells, all of the rows and columns I have
hidden are unhidden, and then hide again when I have completed my formula. It
is driving me absolutely nuts! How can I keep all of my rows/columns hidden
until I need to manually unhide them?
 
J

jimbo693

instead of hiding the columns why not set the column width to 0.01 thi
works as well and will not unhid
 
J

Jeffry Clarke

I have the same problem and it's driving me nuts. Any solutions yet besides
minimizing row height?
 
Top