Hide Irrelevant Fields?

[Nat Wheatley]

On the attached sheet screenshot, I'm wondering if there's a way for only the rows with room total > 0 to display? Ideally, to shift the Red line up to the bottom of the last room that has a total >0 (hide all irrelelvant info?)

Thanks

[martindwilson]

use auto filter on that range, which i have no idea what it is since you attached a useless picture and not an excel workbook!

[Nat Wheatley]

This is just one page of the project. I'd just as soon not attach the entire spreadsheet, as it has info I'd rather not share. The fields shown are just simple references to (copies of) cells on the other pages.

I'm new to Excel, but will look into auto filter.

[Nat Wheatley]

Got it to work. Thanks for the suggestion.