Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
hiding rows
Hello,
I know how to hide a row or rows, but is there a way of automatically hiding rows that contains no data ? Thanks K |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
hiding rows
You can hide blank rows using Autofilter but that would not be "automatic".
Automatic usually means VBA. Do you want to go that route? On Fri, 8 Apr 2011 13:48:43 +0100, "dido22" wrote: Hello, I know how to hide a row or rows, but is there a way of automatically hiding rows that contains no data ? Thanks K |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
hiding rows
Too fast on the trigger<g
Give us an idea of what you want hidden and what would be thr triggering event. i.e. data entry in a cell or cells? Calculated value(s) reach a certain point? A selection is made? Gord Dibben MS Excel MVP On Fri, 08 Apr 2011 08:18:53 -0700, Gord Dibben wrote: You can hide blank rows using Autofilter but that would not be "automatic". Automatic usually means VBA. Do you want to go that route? On Fri, 8 Apr 2011 13:48:43 +0100, "dido22" wrote: Hello, I know how to hide a row or rows, but is there a way of automatically hiding rows that contains no data ? Thanks K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |