Insert Blank Column After Every few Columns In Excel- Excel Tip

We have 100 columns of Data.
and we need 1 blank column after every 4 data columns
This is going to use Go-To Special.
let's insert a blank column at the top and then add some texts
since we are inserting a blank column after 4 columns, we are going to use letter a, then numbers 1, 2, 3.
After that, use equal to sign and copy the cell with letter a. and drag it till the columns that you are going to use.
it will give us a blank column before a letter a.
Now, Press Control+G, then go to special.
and unselect Numbers, Logical, and Errors. press OK.
it will select only letter a.
Then Go HOME, Insert Sheet Column.
All Done!