How to Fill Blank Cells with Linear Values in Excel

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

fill blank cells with linear value1

#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.

fill blank cells with linear value2

#3 select Linear option under Type section, and enter one step value that you want to use. Click Ok button.

fill blank cells with linear value3

#4 you should see that blank cells have been filled up with linear values in your selected range of cells.

fill blank cells with linear value4

 

 

You might also like:

Sidebar