Overclock.net › Forums › Software, Programming and Coding › Other Software › EXCEL: Select every other column
New Posts  All Forums:Forum Nav:

EXCEL: Select every other column

post #1 of 2
Thread Starter 
I have a very large spreadsheet and need to insert a column every other column. It will take a very long time to do it manually, even to select every column with CTRL held down. Is there a faster way to do this?
Current PC
(18 items)
 
  
CPUMotherboardGraphicsRAM
Intel i5 4690k Asrock z97 Pro4 MSI GTX 970 G. Skill TridentX DDR3 2400Mhz 
Hard DriveHard DriveHard DriveHard Drive
WD Caviar Black 1TB WD 640GB Hitachi 1TB Intel 128GB SSD 
Optical DriveCoolingOSMonitor
DVD-RW drive Corsair h50 Windows 7 Ultimate 64 bit 23.6 inch Asus 
KeyboardPowerCaseMouse
Corsair Vengeance k90 Corsair 750W Cooler Master Chassis CM690 Roccat Kone XTD 
Audio
Creative Xfi XtremeGamer 
  hide details  
Reply
Current PC
(18 items)
 
  
CPUMotherboardGraphicsRAM
Intel i5 4690k Asrock z97 Pro4 MSI GTX 970 G. Skill TridentX DDR3 2400Mhz 
Hard DriveHard DriveHard DriveHard Drive
WD Caviar Black 1TB WD 640GB Hitachi 1TB Intel 128GB SSD 
Optical DriveCoolingOSMonitor
DVD-RW drive Corsair h50 Windows 7 Ultimate 64 bit 23.6 inch Asus 
KeyboardPowerCaseMouse
Corsair Vengeance k90 Corsair 750W Cooler Master Chassis CM690 Roccat Kone XTD 
Audio
Creative Xfi XtremeGamer 
  hide details  
Reply
post #2 of 2
I found this online. I tried it myself and couldn't get it to work, but maybe if you are familiar with excel macros you'd be able to tamper with it and get it to work for you.

http://www.excelbanter.com/showthread.php?t=156200
Nightwing
(27 items)
 
  
CPUMotherboardGraphicsGraphics
i7 950 Asus P6X58D-E MSI 390x Gaming 8 GB  XFX Radeon HD 5870 
GraphicsRAMHard DriveHard Drive
MSI 290X Lightning G.SKILL PI Series 6GB WD Caviar Black HDD Crucial C300 SSD 
Hard DriveOptical DriveCoolingCooling
Clickfree External HDD HP BD240I Blu Ray Combo Drive Corsair H70 with GT AP-15's in Push/Pull Intake... Scythe Kama Flex SA1325FDB12H Case Fan 
OSMonitorKeyboardPower
Windows 7 64 bit Ultimate Edition Alienware Optx AW2310 Deck Legend - Ice - Linear PS/2 Interface Corsair AX750 Modular Power Supply 
CaseMouseMouse PadAudio
Enthoo Luxe Logitech MX 518 Gaming-Grade Optical Mouse SteelSeries SX Game Pad Sound Blaster X-Fi Titanium HD  
AudioAudioOtherOther
Sennheiser HD 650 Schiit Magni Headphones Amplifier Logitech C905 Webcam Blue Yeti Microphone 
OtherOtherOther
Bose QC3 Headphones Creative 2.1 Speaker System Xbox 360 Wired Controller 
  hide details  
Reply
Nightwing
(27 items)
 
  
CPUMotherboardGraphicsGraphics
i7 950 Asus P6X58D-E MSI 390x Gaming 8 GB  XFX Radeon HD 5870 
GraphicsRAMHard DriveHard Drive
MSI 290X Lightning G.SKILL PI Series 6GB WD Caviar Black HDD Crucial C300 SSD 
Hard DriveOptical DriveCoolingCooling
Clickfree External HDD HP BD240I Blu Ray Combo Drive Corsair H70 with GT AP-15's in Push/Pull Intake... Scythe Kama Flex SA1325FDB12H Case Fan 
OSMonitorKeyboardPower
Windows 7 64 bit Ultimate Edition Alienware Optx AW2310 Deck Legend - Ice - Linear PS/2 Interface Corsair AX750 Modular Power Supply 
CaseMouseMouse PadAudio
Enthoo Luxe Logitech MX 518 Gaming-Grade Optical Mouse SteelSeries SX Game Pad Sound Blaster X-Fi Titanium HD  
AudioAudioOtherOther
Sennheiser HD 650 Schiit Magni Headphones Amplifier Logitech C905 Webcam Blue Yeti Microphone 
OtherOtherOther
Bose QC3 Headphones Creative 2.1 Speaker System Xbox 360 Wired Controller 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › EXCEL: Select every other column