Adding columns without changing letters

[mdazuk]

Hi I need help.
I have a work book that contains several sheets that include formals.
These formals use data from the different sheets within the workbook.

What I’m trying to do is in one sheet insert 3 new columns without it changing the column letters eg insert the 3 new columns after column A so the could read A,A1,A2,A3,B,C etc.
So they would not effect the formulas within the rest of the Work book.
Is this possible?
Thanks

 

[alansidman]

When you insert new columns, it rearranges the letters of the columns. ie. if you insert 3 columns between A and B, then the B column becomes column E and the inserted columns would be B, C and D.

 

[mdazuk]

Hi
Thanks for replying. I understand that, but I was wondering if there was a way to stop them being rearranged.

Thanks

 

[alansidman]

Not as far as I know, it will do as I indicated.