while Inserting new columns, formulas should remain intact

Occasional Visitor


I have an excel sheet where formulas are applied from left to right. My boss wants that whenever he inserts a new column on the right side and mentions numbers,  automatically formulas take that values in columns, and automatically new relevant columns should insert on the left side also.

Please help.


1 Reply


With your permission, if I may recommend, add a file (without sensitive data) and use this file to describe your problem step by step, or add photos with the appropriate description.  

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).


Don't forget no one in this forum can see what you see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!


Thank you for your understanding and patience



I know I don't know anything (Socrates)