| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Rows when a cell = 0
hello,
I would like to hide a row when the first cell in that row = 0. basically somthing along the lines of =IF(A1=0,hiderow,unhiderow) I can hide rows but the file must be unprotected to change which rows are hidden. With numerous people working with the file i would rather not risk people deleting formulas on accident. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding Rows when a cell = 0
Use Autofilter:
Put a header or label cell on top of column A. Then pull-down Data Filter Autofilter and specify Show rows where the header cell does not equal zero. This will hide all the rows for which the A-cell is zero. -- Gary's Student "mday" wrote: hello, I would like to hide a row when the first cell in that row = 0. basically somthing along the lines of =IF(A1=0,hiderow,unhiderow) I can hide rows but the file must be unprotected to change which rows are hidden. With numerous people working with the file i would rather not risk people deleting formulas on accident. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| parse cell and insert rows? | Excel Worksheet Functions | |||
Hybrid Mode
