Share via

Fillable form and tables

Anonymous
2025-04-06T01:24:24+00:00

I have created a fillable form and when hit the submit button the information is then added to a table on a different worksheet. Now I would like to extract certain parts of the table information and having trouble, when a new line is inserted the formulas need to be added to.the new lines. I have tried using macros to help but no success. Is there a way to extract and use the new information without actually having to manually add the formulas each time?¹

* Changed to a question

Microsoft 365 and Office | Excel | For home | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-04-06T09:22:47+00:00

    Hi MichaelMetzler

    Welcome to Microsoft Community.

    I realize that you've encountered a problem with " Fillable form and tables ", and I understand how you feel. Don't worry, I'll do my best to help you.

    To automatically include formulas in new rows of your Excel table and extract data dynamically, follow these steps:

    Method 1 – Create a table in Excel to automatically fill formulas when inserting rows

    Steps:

    • Select the range B4:D10.

    • Press Ctrl+T. The Create Table dialog box will pop up. Check the My table has a title box and click OK.

    • Excel will create a table.
    • Select the row and right-click to display the context bar. Select Insert to insert the row. We will select row 8 here.

    • Excel has inserted a new row above the previously selected row and also automatically filled in the formula.

    • Complete the row.

    Method 2 – Apply keyboard shortcuts in Excel to automatically fill formulas when inserting rows

    Steps:

    • Select a row. We selected row 8.

    • Press ALT + I.
    • Press R.
    • Excel inserts a new row above the selected row.

    • Select D8 and press CTRL+D.
    • You will see that Excel has an auto-fill formula.

    • Complete the row.

    Method 3 – Use option to auto-fill formula when inserting rows

    Steps:

    • Go to File tab.

    • Select More, and then select Options.

    • Select the Advanced tab.

    • Check the Swap data range formats and formulas box.
    • Click OK.

    • Insert a new row as in Method 1 or Method 2.
    • Excel automatically calculates the result by applying the corresponding formula.

    • Complete the row.

    I hope these suggestions have been helpful to you!

    Feel free to let me know if you have any other questions or need any further help.

    Best regards

    Adrian.C-MSFT | Microsoft Community Support Specialist

    0 comments