Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide a row
Is there a formula to hide a row without writing a procedure in the code.
Example: If A1 is blank don't hide, if anything is in A1 hide. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide a row
Physically hide, no. Camouflage using CF, yes, via selecting entire rows
(with A1 active) then using Formula Is: =ISBLANK($A1), and formatting the font color to be the same as the underlying fill color (to blend). If above helps in some way, do click the YES button below. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Richard" wrote: Is there a formula to hide a row without writing a procedure in the code. Example: If A1 is blank don't hide, if anything is in A1 hide. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide a row
Max gave the correct answer, plus there's one other consideration: if the row
you want to hide happens to be the same row with the value to test, how are you ever going to unhide it after it's been hidden? Can't see the cell to remove the entry in it - you'd have to resort to using Format Rows Unhide. Just a passing thought. "Richard" wrote: Is there a formula to hide a row without writing a procedure in the code. Example: If A1 is blank don't hide, if anything is in A1 hide. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
How do I hide hide #REF! in Excel | Excel Discussion (Misc queries) | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
Hide Unhide Hide again | New Users to Excel | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |