Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
Try this idea
Sub insertcols() mc = "o" 'tested with "d" cti = 27 ' tested with 2 Columns(mc).Offset(, -cti).Resize(, cti).Insert End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
It doesn't work, its giving error!
"Don Guillett" wrote: Try this idea Sub insertcols() mc = "o" 'tested with "d" cti = 27 ' tested with 2 Columns(mc).Offset(, -cti).Resize(, cti).Insert End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
Hi,
1. Type O:AO into the Name Box and press Enter 2. Press Ctrl++ (Control Plus) Cheers, Shane Devenshire "NM" wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
Doesn't work for me!
"Shane Devenshire" wrote: Hi, 1. Type O:AO into the Name Box and press Enter 2. Press Ctrl++ (Control Plus) Cheers, Shane Devenshire "NM" wrote: 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
It would if you used R1C1 reference style instead of letters.
NM wrote: 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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add multiple columns in between
Try Alt-I-C in place of Control Plus
-- David Biddulph "NM" wrote in message ... Doesn't work for me! "Shane Devenshire" wrote: Hi, 1. Type O:AO into the Name Box and press Enter 2. Press Ctrl++ (Control Plus) Cheers, Shane Devenshire "NM" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
move multiple columns into single set of columns | Excel Discussion (Misc queries) | |||
Multiple sets of columns into one set of columns no blanks | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) |