Fill header row

[jscole]

Hello all,

I need to fill a header row to the right, see example attached.

The blank cells need to be populated with the left most populated cell. Please help.

[dilipandey]

Hi jscole,

Welcome to the forum.

Follow below steps:-

Select your data, press F5, click "Special", select Blanks, OK,
Now type = sign and press left arrow, and now press ctrl + Enter .. done

see attached:- header row.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[jscole]

Thank you so much DILIPandey!

[dilipandey]

you are welcome jscole..

Cheers

suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>