Format to hide empty rows

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello All,

Does anyone know how to set a conditional format to hide a colum and/or row
if they are left blank?

Example:

I have a spread*** that imports info from another work*** or file into
10 rows.
In some cases I only populate rows 1 through 5 leaving 6 through 10 blank,
So I'd like to hide those rows.

Please help.
.

Quantcast