Tom’s Tips For Excel Videos: Filling Empty Cells With Value From Above
Sometimes you get data in a column which has a lot of blank cells that represent whatever text was in the last filled cell above them.
When you need to fill in hundreds or thousands of empty cells, here’s a video tip showing how to do it quickly and easily.
Filling cells with value from above
Hi there,
Tom, this tip is not working in one of my xcel sheets. It fills the first group, but not the followings. Any hint?
Thanks!
Diego.
Sorry!!
I was pressing Ctrl+Shift+ Enter and the correct way is Ctrl+Enter.
Thanks again.
Diego.
No problem Diego! Thanks for the follow-up and for visiting my blog page.
-Tom
Nice tip! I like that!
Thanks Michael, and thanks for visiting my Excel website.
-Tom
Thanks for the Great tip Tom!
Will definitely include this in my next Excel Tips and Techniques class.
My pleasure Marie! Thank you for your kind comment, and for following my pages here and on social media. Have a nice weekend!
Tom am regularly checking in you Facebook like.Its very simple,interesting,Knowledgable and easy to learn. Thanks a bunch. If possible please share me the VBA training link …
Thanks a lot. I’ll be producing more material in 2017 and will announce their releases as they get produced.