Adding Columns
 

I have a spreadsheet with many columns, I need to add a new column
between each of the current columns, is there a quick way to do this or
have i got to insert each new column individually?


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390859

You can do it two steps

Select every other column, Ctrl-click every other column
InsertColumns
Then Ctl-select every third column
InsertColumns

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul Sheppard"
wrote in message
news:Paul.Sheppard.1sve6b_1122537917.148@excelforu m-nospam.com...

I have a spreadsheet with many columns, I need to add a new column
between each of the current columns, is there a quick way to do this or
have i got to insert each new column individually?


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390859

Wow! Just found that if you Ctrl_select each column individually, then
Insert Columns it does it in one step!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul Sheppard"
wrote in message
news:Paul.Sheppard.1sve6b_1122537917.148@excelforu m-nospam.com...

I have a spreadsheet with many columns, I need to add a new column
between each of the current columns, is there a quick way to do this or
have i got to insert each new column individually?


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390859

Thanks Bob


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390859