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.
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.
Last edited by jscole; 01-02-2013 at 09:47 AM.
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>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Thank you so much DILIPandey!
you are welcome jscole..
Cheers
suggest you to mark this thread as [SOLVED].. thanks.
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks