Fill Blank Cells for Microsoft Excel

This is a software tool that can help you fill in blank cells in a column with values in the cell above or below.

Fill Blank Cells for Microsoft Excel automatically fills blanks in the selected columns with the value of the cell above or below. This becomes essential when you are unable to sort or filter your list and use some other function as empty cells in a column will not let you do that. The tool allows you to fill all blank ranges upwards or downwards in different columns of your table at once.  It will also automatically copy a value to the empty cells until it reaches a non-blank cell. You will need to indicate if your tables have headers and specify if the empty cells need to be filled upwards or downwards. This saves you a lot of work if you had to manually find empty cells and fill them one by one.

The time saved could be substantial as in any real life spreadsheet such empty cells could be in hundreds and even thousands. The functionality offered is very niche of course. But when needed, this could well be a life saver and save a lot of time overall for other processing. You will need to process the sheet to fill in the blanks first before processing the sheet for whatever other processing you need to do. This is a good product and has many useful features. If you have a need, here is a good candidate for trying out.

"Fill Blank Cells for Microsoft Excel automatically fill blanks in the selected columns with the value of the cell above or below. It can save you plenty of time and effort if numerous blocks with missing data in your table don't let you sort, filter your list or use some other Excel function.
With Fill Blank Cells for Microsoft Excel, you can get rid of empty cells in 3 easy steps:
- Fill all blank ranges upwards or downwards in different columns of your table at once.
- Automatically copy a value to the empty cells until it reaches a non-blank cell.
- Choose to split merged cells in your worksheet.
- Indicate if your table has headers.
- Specify if you need to fill the empty cells upwards or downwards.
You no longer need to find and fill each blank block manually - this helpful tool will do it for you in seconds.
The add-in works with Microsoft Excel 2013 32-bit and 64-bit, 2010, 2007, 2003.
For more information please visit http://www.ablebits.com"