Fill Blank Cells in Excel with Value Above - Excel Tip

Quickly fill all blank cells with the cell value above in Excel. This quick Excel tip will fill all blank cells in a table using a Go To Special technique and a simple formula.

Find many more Excel tips on our YouTube channel and at our blog. Subscribe to the channel, watch the lessons and become an Excel superstar.

*** Online Excel Courses ***

Find more great free tutorials at;

Connect with us!

[jacquiherron]

Can I just say you just saved me HOURS and HOURS of my life. Thankyou so much!

[SiemionekTM]

You are a f... genius. Thank you so much. What a brilliant

[ansuelizabethbaby]

Thank you Sir. I had a huge spreadsheet to fill the blanks. Very useful.

[shashankshekhar]

Sincere gratitude. You cant even imagine how you simplified my data analysis

[marcelosaludas]

You save y day!. As amazing as simple ! Thanks I was fighting with 1000 cells excel. brillant!!

[dawnmueller]

Very clear and helpful. Appreciate it. Hundreds of rows to deal with. Needed to take every 2nd row and paste and insert it to create a new 3rd row. Not sure how to do in all one step, but between adding a blank row to the 'nth' row, and your video on filling in missing data from row above. I've accomplished my mission! Thanks!

[jefffinton]

This is a fantastic tip. I have been searching around all day looking for this solution and this is going to save me so much time with these three files that have over 20K lines each that have rows upon rows of data like in your example.

[frdeyxi]

Amazing! Thank you! I've just saved a lot of time!

[raxitmehtolia]

Heartiest this tutorial more than a boon, i did use it to solve my some another problem which otherwise would take huge time.

[ericajohnson]

You are a lifesaver! Thank you so much!!!

[paolaqs]

THANKS!! IT WAS USEFUL & EASY TO UNDERSTAND :)

[Knowmore]

Youra genius man!!! Saved me a world of work. Thank you

[jediuddin]

Thank you for a simple and useful tip!

[Hbetonkis]

ABSOLUTELY BRILLIANT! (yes, I realize I was shouting). This just saved me at least an hour! Thanks.

[haycelineb]

You saved us from a lot of trouble. Thank you.

[mrrat]

Thanks a lot you have saved a lot of time.. it's fantastic.. really grateful to you. Wish you all the best.

[frase]

Thanks, extremely useful for canned reports.

[Drinkalot]

how should we proceed in case we have a huge table also with sub totals included?

[banglainfo]

It is not working. When i select the cells after special blank then other cells are unselected

[mohfaisupp]

When I press enter it copies data for only 1 active cell, even though all the blank cells are in active mode or selected mode