Forum Discussion
Hiding entire rows based on blank Cells
I am a construction estimator and am using a spreadsheet containing over 100 Rows of specific building materials; I dont use all rows for all estimates. I am trying to figure out how to set up a butt...
Filter it, and exclude blanks?
Thanks Philip,
I am unsure how to do this? can you provide an example or more input?
Select entire column C, in ribbon Data->Filter. In first row of column C click on appeared filter icon, from drop-down menu unselect Blanks.
Thanks Sergei,
That works but leaves me with this question;
I only want to do this on Rows 9 - 120. Do you know how I can set it up to ignore all other rows?
Rows 1 - 8 contain information specific project information that needs to remain visible.
Same with rows 121 - 180.
Thanks again,
Brandon,
Select these rows, perhaps with one more, in column C, when Data->Filter
