Comments on: How to fill empty cells with 0, with value above/below in Excel

In this article, you’ll learn a trick to select all empty cells in an Excel spreadsheet at once and fill in blanks with value above / below, with zero or any other value. Continue reading →

Comments page 2. Total comments: 201

  1. last day my senior done this through command and today i am trying but i forgot it ,mean while i google it and found this article ....finally i done it successfully .
    Thanks to Ekaterina Bespalaya,it save my time a lot.

  2. Hello Team Ablebits,

    I want know that if i have pleny of different rows with different data and every data has one blank row and i want insert above data in below rows with any formula or tick is there any way?

  3. Hi,
    I have a data in which I want to fill text of end row in upper rows. I want to fill 320304 in all upper rows.

    55
    215.24
    0.23
    237.24
    756
    7,745.72
    841.02
    1,806.26
    307.32
    0.04 Goods Receipt 320304

  4. This is very helping me!! Thank you so much Ekaterina Bespalaya..

  5. Thank you. Very helpful.

  6. really amazing and time saving . Very helpful.

    thanks

  7. How to add null value in empty cells?

  8. Thanks a lot, really works.

  9. Thank you so much!

  10. This has solved my 2 year old pending query, thanks a tonne for the solution... :) :)

  11. Thanks sir

  12. how to replace blanks cells with zero in specific data column using VBA macros

  13. Thanks for the excellent share. Best part is you have share every possible move for the single function, this method is great and will really help a larger audience as it gives brighter options to choose which method one's like.

    Cheers!!!

  14. I'm so grateful that you exist. TRULY

  15. Thank you, worked perfectly :)

  16. Bless you! :D :D

  17. had 3k records to fill in the gaps for.. saved my life

  18. Hello, this does not seem to be working for me.... In the cells to be filled with the above cell content, only the formula entered appears, not the value. eg in the empty cells I see "=A2" but not the value...

  19. Filter the Blank Cells.

    if C1 contain the data to fill & 1st blank cell is C2

    then type +C2=C1

    then drag it to the below.....

    This is easy for me..

    1. Hi Santhosh,
      Can you please be specific with the formula. For example I have two column, the first column contains a list of code and second column contain corresponding product . But in the column of the product there are some blanks which need to be fill with the codes. can please give formula for it.
      for ex:
      A B
      1 Apple
      2
      3 banana
      4 orange
      5
      6
      7 grapes
      8
      thank you

  20. Really Helpful ! Thank you

  21. I work in the financial services and you lot just saved me my job!!! Thank youuuuuu :)

  22. Thanks . Many Many help us jillal

  23. Thanks . Many Many help us.

  24. That's gr8!

  25. Thank you so much!

  26. Really helpful! Thanks so much!!

  27. Thats amazing! You helped me save so much time.
    Thanks a lot for sharing the wonderful tips!

  28. I would like to highlight every other row in my Excel worksheet to facilitate viewing data. Is there an easy way to do that? I have over 50 rows each month.

    1. Hi Brad,

      You can use predefined Excel table styles (Banded rows feature) or set up your own conditional formatting rule to alternate row color. We have a special tutorial that covers both methods in detail: How to highlight every other row in Excel

  29. THANK YOU SO MUCH..Saved me lots of time. God Bless!

  30. Learnt something new today.. thanks a lot

  31. What a great piece! Thanks a lot.

  32. Its very helpful.Thank you so much for this detailed explanation

  33. Thank you for the clear concise instructions!

  34. Do you know if there's any way to do this in google sheets?
    Thanks!

  35. thank you so much - amazing tips..

  36. Grt!

  37. Great tip! Thanks a lot :)

  38. Thank you very much sir, it saved me lot of time and tension

  39. EXCELLENT SIR, I AM APPLY THIS FORMULA THIS IS WORKING AND HELP FULL. THANK YOU ONCE AGAIN SIR

    1. You mean Miss, not Sir. Why would you assume the writer is a man? You are talking to an excel Queen here.

  40. thank you for these :)

  41. Thank you so much....amazing short cut.....

  42. Wow! Thank you so much. You saved a lot of time for me! ;)

  43. Saved me a lot of time. Brilliant, thank you!

  44. Hurrah! After all I got a weeb site from where I be able to in fact take valuable facts regarding my study and
    knowledge.

  45. Thanks for this, extremely time saving method, works perfect!!

  46. you are in point of fact a excelkent webmaster. The website loading pace is incredible.
    It kind of feels that yyou are doing any unique trick.

    Moreover, Thee contdnts are masterwork. you've performed a fantatic task in this topic!

  47. Thanks a lot, great shortcut!

  48. Thank you.

  49. Thank you for this!! My wrist was hurting from dragging and I knew there had to be a better way. Talk about a life saver!!

  50. How could I fill the blank cells with formulas that change? Let's say i want to add vlookup only in blank cells but the first reference must change in every cell so that it will be the horizondal value.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)