Tom’s Tutorials For Excel: Filling Empty Cells With Value From Above

by Tom Urtis 9 Comments ↓

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

‹ Tom’s Tutorials For Excel: Filtering Automatically On Cell Entry

Tom’s Tutorials For Excel: Toggling the GETPIVOTDATA Function On and Off ›

Posted in Tom's Tutorials for Excel
Tags: Analytics, Big Data, Business Intelligence, Cells Ranges Lists, Cut Copy Paste Clear Fill, Data Science, Excel Expert, Excel Guru, Formulas Functions, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tips and Tricks, Tom Urtis

9 comments on “Tom’s Tutorials For Excel: Filling Empty Cells With Value From Above”

1. Diego says:

   April 10, 2012 at 4:52 am

   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.

   Reply
2. Diego says:

   April 10, 2012 at 4:59 am

   Sorry!!

   I was pressing Ctrl+Shift+ Enter and the correct way is Ctrl+Enter.

   Thanks again.
   Diego.

   Reply
   • Tom Urtis says:

     April 10, 2012 at 10:53 am

     No problem Diego! Thanks for the follow-up and for visiting my blog page.

     -Tom

     Reply
3. Michael Rempel says:

   May 21, 2014 at 2:19 pm

   Nice tip! I like that!

   Reply
   • Tom Urtis says:

     May 21, 2014 at 2:35 pm

     Thanks Michael, and thanks for visiting my Excel website.

     -Tom

     Reply
4. Marie says:

   May 23, 2014 at 12:51 pm

   Thanks for the Great tip Tom!
   Will definitely include this in my next Excel Tips and Techniques class.

   Reply
   • Tom Urtis says:

     May 23, 2014 at 1:28 pm

     My pleasure Marie! Thank you for your kind comment, and for following my pages here and on social media. Have a nice weekend!

     Reply
5. Madan Kumar says:

   December 18, 2016 at 8:59 pm

   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 …

   Reply
   • Tom Urtis says:

     December 18, 2016 at 9:13 pm

     Thanks a lot. I’ll be producing more material in 2017 and will announce their releases as they get produced.

     Reply