conditional cell hiding


Posted by coline on January 28, 2002 4:32 PM

Hi, is there an easy way to conditionally hide cells? Thanks for the help.
Coline

Posted by Juan Pablo G. on January 28, 2002 5:39 PM

Short answer, yes and no. You can't really hide a cell, only rows or columns, BUT, you can make it appear "invisible", that is, without anything "showing" in it.

Can you explain a little further what you're after ?

Juan Pablo G.

Posted by Paul on January 28, 2002 5:39 PM

Do you want to just hide the text in the cell basted on something Else? care to provide an example(NT)

Posted by coline on January 28, 2002 6:13 PM

Re: Do you want to just hide the text in the cell basted on something Else? care to provide an example(NT)

OK, I'm creating a spreadsheet to compute the costs of many different offices. I'd like to use my spreadsheet for each site; however, the number of years they've been in operation changes. I'd like to set up my tables for 20 years, knowing that some offices will only have been in existence for 5 years. In this case, I would like to hide 15 years of possible calculations.
Thanks for the help!

Posted by coline on January 28, 2002 6:15 PM

Hiding rows and columns would work well too . . . Basically, I'm creating a template that will compute the costs of an office for its entire life. I'll be visiting ~40 sites, however, and so the length of time they've been in operation varies. In some cases, I would like to hide several years of data, even though the calculations remain in those cells for programs with longer durations.
Thanks again for the help!


Posted by Paul on January 28, 2002 7:01 PM

Re: Do you want to just hide the text in the cell basted on something Else? care to provide an example(NT)

can you just hide the rows you don’t need? If so select the rows you want to hide and go to format, rows, hide



Posted by anno on January 28, 2002 7:35 PM

how about ...

something like:
=IF(yourformula,yourformula,""),or if you need to do arithmetic operations on what the formulas return:
=IF(yourformula,yourformula,0) and custom format the cells as 0;-0;
thanks to mark w for the custom formatting