In the popping up Assign Macro dialog box, click the New button.ģ. Click Developer > Insert > Button (Form Control) to insert a Form Control button into your worksheet.Ģ. Now you need to protect the worksheet to prevent the formula column from changing, but allow to expand the table by inserting new row and assign new data into the new cells.
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!Īs below screenshot shown, a table named Table1 in your worksheet, and the last column of the table is a formula column.
