excel icon

How To Fill Empty Cells With Value Above In Excel

Last Updated on

If you have to deal with various software that lets you export excel file a lot, you have probably come across to a situation where you can’t manipulate the data within the file because some cells have been merged together.

merged cells in excel

The solution to this is to unmerge the cells then fill the empty cells with the first value of each data set. Now, if there aren’t that much data, you would probably just use the autofill function manually to accomplish this.

Fill empty cells with value above

But what if you have 1000s of rolls of data?

In this video, it shows how can be done automatically without any fancy equation. Check it out!

Referencec: https://www.ablebits.com/office-addins-blog/2014/05/02/fill-blanks-excel/

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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