Adding Columns

[Paul Sheppard]

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?

[Bob Phillips]

You can do it two steps

Select every other column, Ctrl-click every other column
Insert>Columns
Then Ctl-select every third column
Insert>Columns

--

HTH

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


"Paul Sheppard" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Bob Phillips]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Paul Sheppard]

Thanks Bob