Detect frozen rows as headers

[Jeff_Hager]

@George_B has an excellent option, but I’ll throw in a second option as I’m big on 2 row headers as well. I add an IF statement that will check if a certain column in a row is empty. If it is, then I display a blank. Blank rows will not show in the inline list.

Arrayformula

Try this in column C2: =arrayformula(IF(LEN(A2:A) = 0, “”, “image url”)) You may need to use “;” instead of “,” depending on the country you live in.