| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding rows based on a value
I am looking for a way to hide a row based on the value in a cell.
EG: a price list which hides rows where the quantity column is '0' so that when you print it / view it on screen you only see relevant rows. Thanks. |
|
#2
|
|||
|
|||
|
Menu DataFilterAutofilter and select a value of 0.
-- HTH RP (remove nothere from the email address if mailing direct) "John" wrote in message ... I am looking for a way to hide a row based on the value in a cell. EG: a price list which hides rows where the quantity column is '0' so that when you print it / view it on screen you only see relevant rows. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Hiding Rows Based on Percentile | Excel Discussion (Misc queries) | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
| Hiding rows based on date | Excel Worksheet Functions | |||
Linear Mode
