Select the worksheet tab which contains the formulas you want to auto fill, and right click to choose View Code from the context menu to go to the Microsoft Visual Basic for Applications window, and then copy and paste the following code into the Module: If you don’t like to change the data to table, the below VBA code also can help you to achieve this problem.ġ. Then click OK button, and the table has been created, and now, when you insert a blank row, the above formula will be inserted into the new row automatically, see screenshot:Īuto fill formula when inserting blank rows with VBA code In the Create Table dialog, check the My table has headers if there are headers in your data, see screenshot:ģ. Select the data range that you want to auto fill formula, and then click Insert > Table, see screenshot:Ģ.
In Excel, the Table format can help you to fill the above formula into the new inserted blank rows automatically, please do as follows:ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
