Fill Blank Cells for Excel will copy the contents downwards or upwards from the first populated cell. You can specify if your table has headers or choose to split the merged cells.
Keep an eye on the Backup the worksheet option. We always recommend selecting it as Excel doesn't let you cancel changes made by add-ins.
Select the range in your table where you need to replicate cell values.
Run the add-in by clicking the Fill Blank Cells icon in the Transform group on the Ablebits Tools tab:
You can see the Fill Blank Cells dialogue window and its elements:
Click Fill to get all the blank cells in the chosen range filled with the values from above or below.
I have recently needed to use the fill down option on a column with 6800 rows. The fill down nature was to copy the formula "=Countif" from A2 down to A6801. When I attempted to use the Fill Blank Cell option on the rest of the rows, the result or outcome of the formula on A2 was copied down to A6801 and not the formula itself unlike the Cntl-D fill down option. With that in mind, will you kindly let me know if there is another way in Ablebits to copy down or fill down (or up etc.) a formula and not the result of the formula?
Thank you and have a great day.
Thank you for your comment.
Unfortunately, our Fill Blank Cells add-in works only with values. Please have a look at this article on our blog describing how to copy formulas in Excel. Hope you will find it helpful.
How do I see the Fill Blank Cells window and its elements?
Thank you for your question. Please note that the Fill Blank Cells tool is a component of Ultimate Suite. If you have already installed the add-in, just click on the Fill Blank Cells button under Ablebits Tools in your Excel Ribbon and you will get the window of interest displayed. If you have not installed Ultimate Suite yet, please feel free to download its trial version. This is a direct link for you: https://www.ablebits.com/files/get.php?addin=xl-suite&f=free-trial
The function of filling cells in white, is very interesting, however, it is filled with the values of the lower or higher cells.
In my work, I create dynamic tables, where I have to fill in blank cells with the value ZERO, in order to generate sales statistics and averages.
It will be possible that in later versions, add this function, to be able to choose which value you want to insert in the empty cells.
Thank you for contacting us and for your feedback.
I have forwarded your idea to our developers. They have added this feature request to their development schedule, but I can't give you an exact timing when the functionality is implemented.
In the meantime, I'd recommend you to look at the following article on our blog:
Feel free to contact us again if we can help in any other way.
when filling blanks, is there a way to also fill with the copied cell's colors?
Thank you for your comment.
Unfortunately, the tool does not copy the formatting of the cells, only the values. However, I will pass your idea to our developers and we will consider this as a new feature in our coming Ultimate Suite updates. I will let you know when it's implemented.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!