How to fill empty cells with previous row value in Excel

Have a lot of gaps in your data that have to be filled with the data above? Learn how to quickly & easily fill in previous data in cells. This is a simple trick to get all the preceding data into empty cells below. Maybe you already know how to use these tools and shortcuts, but never thought you could use them like this too!

------------------------------
** After this video, to learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel

Also, as you are a special Viewer/ Subscriber,
we would like to give out a special discount just for you,
so click here -

------------------------------------
SUBSCRIBE NOW!

Click this link to learn more awesome functions in Excel

Click this link to learn how to manage your personal finance using Excel

Thank you for watching
Keep Excel-ing!!

[vikaskolsulkar]

I was searching for exactly this same issue for so long time and your video came as like a gift to me. God bless you

[ricardochica]

You are my savior sir, subscribed now! and big Like! Thank you from Colombia my friend!

[mnshmalvi]

I was thinking a lot about how do I do this, but you made so much easier, thank you God bless you

[atheralam]

Thank you. U saved hours of my time 🙏🏽

[zt]

I spent a day looking for this thank you!

[jayadevb]

excellent. Just it solved my problem. Thanks

[Arthuro]

Absolutely useful. Just helped solve a problem I was working on

[vishalmanikandan]

It helped me with one of the most crucial data sorting tasks! Thank you so much!

[beenabn]

Too good @ 5.41 solved a query dot on - Thank you so much !!

[AN-dpnn]

Thank you so much!!! Helped me solve a problem that I just encountered. Very useful and informative. Please share more tricks.

[anupagarwal]

You have just sorted out my problem...thank you very much

[kcvinod]

Super & more useful this formula for me

[harsinchh]

Sir, how to insert blank rows before/above specific text ?
please reply.

[njsatish]

Thank you for helping with the short cuts

[prasannachitra]

What if I need to take value from side

[ShanmukhaReddy]

how to do this if I have data in 5 merged cells?
I have data in a merged cell (merged up and across), I want to paste this data into the cells below by merging them in a similar way. How to do that?

[mayuri]

Can you plz explain if data is more than 1 lakh then wht to do.

[sagarijadhav]

If i want to fill the series in each empty cell continue with the number just above it... How to do it.?.. If i have 2 in uper cell.. Thn I have to fill 2, 4, 5, 6, 7, 8... Then with next cell in same column have 3 in upper cell..n want to fill next numbers below it ...have huge data... Please guide