Hiding entire rows based on blank Cells

Question

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 button to automatically hide entire rows.

IF column "C" is blank Hide entire row.

See example blow:

A B C D

2827	BF	265	2X4x16 HEM FIR #2 misc.
720	BF	45	2X6x16 HEM FIR #2 misc.
0	BF		2X4X92/5 KD HEM FIR #2 studs LB
66	BF	11	2X4X104/5 KD HEM FIR #2 studs LB
840	BF	140	2X4X105/5 KD HEM FIR #2 studs NLB
0	BF		2X4X116/5 KD HEM FIR #2 studs LB
0	BF		2X4X116 KD HEM FIR #2 studs NLB
0	BF		2X4X140/5 KD HEM FIR #2 Studs LB
2880	BF	320	2X6X104/5 KD HEM FIR #2 Studs LB
135	BF	15	2X6X105/5 KD HEM FIR #2 Studs NLB

philip west · Answer

Filter it, and exclude blanks?

brandon slater · Answer

Thanks Philip,I am unsure how to do this? can you provide an example or more input?&nbsp;

sergeibaklan · Answer

Select entire column C, in ribbon Data-&gt;Filter. In first row of column C click on appeared filter icon, from drop-down menu unselect Blanks.
https://support.office.com/en-us/article/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e

brandon slater · Answer

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.&nbsp;Thanks again,

sergeibaklan · Answer

Brandon,
&nbsp;
Select these rows, perhaps with one more, in column C, when Data-&gt;Filter

Forum Discussion

Hiding entire rows based on blank Cells

5 Replies

Resources