Hide Rows if Cells in a Column are blank

[cmerc2019]

Hello everyone,

I specifically made an account so I can figure out how to do this in Excel. So what Im trying to do is hide the rows when cells from a range of columns does not have data in it.

Example: K4:Q4 will be filled in with data and if theres no data on this entire column then I would like to hide rows A2:A8 because that encompasses information for each of those data.

 

[My Aswer Is This]

So did changing 7 do what you wanted?
Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thanks for your patience and all the help!

 

[cmerc2019]

Yup! Worked as intended. Will definitely come back here with more questions in the future!