Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HIDE-IF???
I have a template for a matrix that has roughly 100 columns. Entries are
made into the cells within the appropriate columns and at the end, I'm manually hiding each empty column, so as to compact the look of the matrix. My entries are made from the top downward into laterally contiguous cells. Therefore any empty column has no data entered into cell B. I'd like to be able to say if cell *B is empty, then hide column *. I suppose that this request would have to be run as a macro, but I'm certainly not sure. All suggestions appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Hide Column/s or Change Font color Only for printing | Excel Discussion (Misc queries) | |||
hide a worksheet so that a macro can still find it | Excel Worksheet Functions | |||
How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
Hide AutoShapes On Excel Worksheet | Excel Worksheet Functions | |||
Conditional Hide function for Excel | Excel Worksheet Functions |