How to quickly insert a blank column between every other column in Excel?
Managing a worksheet often requires inserting additional columns, but adding a blank column between each existing column can be a laborious task if done one by one. Is there a faster way to accomplish this without the tedium? This guide will show you efficient methods to quickly insert blank columns between every other column in your Excel spreadsheet, streamlining your data organization process.
Insert blank columns with VBA code
Quickly insert blank columns with Kutools for Excel
Insert blank columns with VBA code
Please look at the following screenshot, after each column, I want to insert a blank column to record other information, I can use a brief VBA code to finish this task.
1. Select the range in which you want to insert blank columns between the data.
2. Click Developer > Visual Basic and a new Microsoft Visual Basic for Applications window will be displayed, click Insert > Module, and input the following code into the Module:
Sub insert_column_every_other()
'Updated by Extendoffice 2024/07/15
For colx = 2 To 30 Step 2
Columns(colx).Insert Shift:=xlToRight
Next
End Sub
Quickly insert blank columns with Kutools for Excel
With the help of Kutools for Excel, you can easily insert blank columns. Please do as follows:
1. Highlight the range you would like to insert blank columns.
2. Click Kutools > Insert > Insert Blank Rows/Columns, see screenshot:
3. And an Insert Blank Rows/Columns dialog box will appear. Click the Blank columns option from Insert type. Input 2 in Interval of, input 1 in Column. See screenshot:
4. Then click OK. And you will insert a blank column with every two interval. See screenshot:
With the Insert Blank Rows/Columns function, you also can insert a specific number of blank rows with specific intervals between exiting data. Here we insert two blank rows between every second column, see screenshot:
|
 |
 |
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
