Click here to Skip to main content
15,867,453 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?

Thanks.

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)".
Posted
Updated 17-Nov-22 21:50pm
v2

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