| Home |
| Search |
| Today's Posts |
|
#9
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 |
| 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) | |||
Threaded Mode
