Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically hide rows with zero value
Can you format a worksheet to hide rows that result in a zero value from a
vlookup? For example we have created a report card program and when students don't have a elective course a "0" is returned. Can this row be hidden automatically? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically hide rows with zero value
Autofilter will allow you to hide rows where a cell contains zero
(select Custom | Not Equal To | and enter zero), but this will be manual rather than automatic. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the quickest way to hide a lot of rows and colums ? | Excel Discussion (Misc queries) | |||
Want to auto hide rows in excel when no data in a certain column. | Excel Discussion (Misc queries) | |||
Format to hide empty rows | Excel Discussion (Misc queries) | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions |