Click here to Skip to main content
15,665,718 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I don't understand how can I autofill a formula that is on a cell to a new column added on the left. Let's make an example:

I have on cell "B2" a date that is "=(B1+180)", when I add a new column on the left of "B2", the new "B2" does not contain the formula. How can it autofill the formula when adding new column on the left?


What I have tried:

I'm expecting that when I add a new column on the left of "B2", the new B2 will autofill the formula "=(B1+180)".
Updated 17-Nov-22 21:50pm

1 solution

This is not an Excel support site: we are about software development, not software usage for major companies.

Start here: excel support - Google Search[^] and see what you can find.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900