Add multiple columns in between
This means it has to be done manually, excel doesn't tell you the column name
equivalent to the number.
"Bob I" wrote:
There are 26 letters in the alphabet. 26 would get you to AP, so add one.
NM wrote:
Thanks David,it worked.
But I want to how do we know that from column O to AO it is 27 columns? Do
we count all the way from O to AO to see if that equals 27 or is there a
easier way to know that?
Thanks!
"David Biddulph" wrote:
Select Column O
Shift and select Column AO
Insert/ Columns
--
David Biddulph
"NM" wrote in message
...
Hi,
I have coulmns A through CJ and I want to add 27 coulmns before column O.
What is the easiest way to do it?
Thanks for your help.
Nee
|