How to insert columns manually in Excel. Inserting a column or even a few columns is easy, ... Instead, copy the code into a text editor and then paste that code into the ThisWorkbook module.