Inserted rows and missing formulas (Excel 2000 SR-1)

Topic

New Reply

There have been times when I have inserted a row in the middle of a sheet (e.g., a budget, for example) and the inserted row automatically copied formulas from the prior row. Other times, when I insert the row, the formulas are not copied and must be manually copied down to the cells in the new row. I have never been able to figure out what I’m doing differently, or why that happens. It’s just one of those nagging annoyances. Anyone able to give me a clue? Thanks for any suggestions.

Reply | Quote

Replies

See if XL2000: How Auto Extend List Behavior Works satisfies your curiosity.

Reply | Quote

I think it will, Hans. I’ll have to try out some of the examples given in the article. I didn’t know the correct term to search for. As always, I appreciate the quick response. Thank you.

Reply | Quote