G
Guest
Is there a way to program Excel to automatically hide rows when cells have a
certain value? For example, if a cell in the row equals zero, could the
computer automatically hide the row. I have a summary sheet that pulls
values from other sheets. When an item total is zero, I hide the row
manually. By hiding rows, the data presented to other parties only shows
pertinent information. It would be great to automate the process of hiding
rows.
certain value? For example, if a cell in the row equals zero, could the
computer automatically hide the row. I have a summary sheet that pulls
values from other sheets. When an item total is zero, I hide the row
manually. By hiding rows, the data presented to other parties only shows
pertinent information. It would be great to automate the process of hiding
rows.