| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding columns (one with a formula) | New Users to Excel | |||
| adding an horizontal scrollbar to columns | Excel Discussion (Misc queries) | |||
| adding columns | Excel Discussion (Misc queries) | |||
| Perform functions on the result of adding two columns | Excel Worksheet Functions | |||
| Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) | |||
Linear Mode
