Fill Blank Cells In Excel Range
Fill blank cells in a range of cells could take long time doing it manually. Dose for Excel‘s Fill Blank Cells utility can easily fill these blank cells with one click.
- Fill blank cells based on values
- Fill blank cells with linear values
- Fill blank cells with fixed value
Click DOSE » Insert » Fill Blank Cells…
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells-pane.png)
Fill blank cells based on values
- Select a range of cells.
- And then apply this function by clicking on DOSE » Insert » Fill Blank Cells….
- For example, if you want to fill blank cells based on the values of upper cells then just check Based on values option button and check Down option button.
- Then click on Insert. See screenshots.
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells-based-on-values-test.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells-based-on-values-result.png)
Fill blank cells with linear values
- Select a range of cells.
- And then apply this function by clicking on DOSE » Insert » Fill Blank Cells….
- In below example, if you want to fill blank cells with linear values that calculate the average between first cell value and last cell value then just check the Linear values option button and From left to right option buttons.
- Then click on Insert. See screenshots.
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells-linear-test.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells-linear-result.png)
Fill blank cells with fixed value
- Select a range of cells.
- And then apply this function by clicking on DOSE » Insert » Fill Blank Cells….
- In below example we will fill blank cells with “Engineer” value, if you want to fill blank cells with a fixed value you specify then simply check Fixed value option and enter your value in the Filled value box.
- Then click on Insert. See screenshots.
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells-fixed-value-test.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Fill Blank Cells](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-fill-blank-cells-fixed-value-result.png)
More Features:
Dose for Excel Languages
Dose for Excel Multi-Language Dose for Excel Add-In supports many languages, you can change the…
Excel Extend Selection To The Last Used Column
Easily Extend Selection To The Last Used Column Normally if you want to select a…
Excel Insert Empty
Insert Empty Rows Or Columns At Certain Interval In Excel If you ever want to…
How To Color Alternate Row In Excel
Color alternate row or column in Excel With this utility you can quickly apply shading…
Excel Select Used Range
Select Used Range With One Click Most annoying thing is when you want to select…
Excel Convert Hyperlinks
Extract URL’s From Hyperlinks Or Convert Plain Text Cells Into Hyperlinks In Excel Easily convert…