CODEWITHSUNDEEP
excel
ThEvensen
ThEvensen

Reputation: 69

Continue formulas automatically

I have an excel sheet with columns A-J. Column A-F is filled manually while columns G-J is calculated based on values from A-F.

When filling rows with data in columns A-F, the cells in column G automatically fills with the correct formula while I have to manually "drag" colums H-J down to make them repeat down the rows.

Is there a way of making columns H-J behave like column G. And why is column G behaving like this?

I have the option "extend data range formats and formulas" turned ON.

Thanks!

Upvotes: 2

Views: 3389

Answers (1)

Jamie Bull
Jamie Bull

Reputation: 13539

No idea why your sheet is behaving as it is, but if you format the data as a data table then it will behave as you want.

Upvotes: 1

Related Questions