Share via

Inserting rows: Some formulas auto-fill, some do not

Anonymous
2016-06-03T14:26:20+00:00

I have reviewed the other threads, and do not seem to see one that addresses this specific question. I know how to auto fill formulas into my newly created rows. I have a 'proper' excel table (from the "Insert Table" tab). There are numerous formulas and list drop-downs in the sheet, and when I hit ctrl+ "+" to insert a new row, several of the formulas auto-fill. However, in some of the columns, the formulas are NOT auto-filling. I do not understand why this is? How does it understand to copy some formulas but not others? The formulas are similar in form, so I've ruled that out as a reason. I can easily drag the formulas either up or down from an adjacent row, but I cannot figure out how to get them to auto fill with all of the rest of the formulas.

Has anyone else experienced this and if so, how was it resolved?

Thank you.

Bob

Microsoft 365 and Office | Excel | For home | Windows

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

Answer accepted by question author

Anonymous
2016-06-08T16:05:37+00:00

Hello,

I actually figured out the problem. I had altered the root formula in a row that was not the top row of the table. As such, it was not 'seeing' the updated formula in any newly created rows. To solve this, I simply pasted my formula(s) to the top line, and applied them down throughout the column/table.

Now when I create a new row, either by r-click or ctrl+ "+", all desired formulas are there.

Thank you for the response!

Was this answer helpful?

7 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-06-04T08:30:44+00:00

    Hi Bob,

    Have you made any changes prior to the issue?

    Refer the articles given below to know about Auto Fill feature in Excel and check if it helps.

    https://support.microsoft.com/en-us/kb/291359

    https://support.office.com/en-us/article/Fill-data-automatically-in-worksheet-cells-71EEB2F2-D689-459B-BE7E-614F03E69012#__toc304980286

    Repair the Excel file, restart your computer and then try working with it and check if it helps.

    If it is with particular file, Refer to the following article for instructions on repairing the a corrupted file .

    https://support.office.com/en-us/article/Repair-a-corrupted-workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53

    Keep us posted on the status of the issue and I’ll be glad to assist you further.

    Thank you.

    Was this answer helpful?

    0 comments