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

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

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,
9 comments on “Tom’s Tutorials For Excel: Filling Empty Cells With Value From Above
  1. Diego says:

    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.

  2. Diego says:

    Sorry!!

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

    Thanks again.
    Diego.

  3. Nice tip! I like that!

  4. Marie says:

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

  5. Madan Kumar says:

    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 …

Leave a Reply

Your email address will not be published. Required fields are marked *

*