This post will guide you how to fill blank cells in a range with linear values in Excel. How do I fill up empty cells by linear interpolation in Excel 2013/2016.
Fill Blank Cells with Linear Values
Assuming that you have a blank cells in a range (B1:G1), and you want to fill blank cells with linear values. How to do it. You can do it by the following steps:
#1 select range B1:G1 in your worksheet
#2 go to HOME tab, click Fill command under Editing group. And select Series from the drop down menu list. And the Series dialog will open.
#3 select Linear option under Type section, and enter one step value that you want to use. Click Ok button.
#4 you should see that blank cells have been filled up with linear values in your selected range of cells.