Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.
Inserting columns and rows in Microsoft Excel is a common task, and fortunately, it’s simple, as long as you’re not trying to enter too many columns (or rows) at the same time. Once your selection moves off screen, the selection process is awkward, and it’s easy to make mistakes. Try inserting 20 columns manually, and you’ll see what I mean. Now imagine inserting 100 or 500! If you need to do so even once, you’ll want to use the VBA procedure in this article instead!
SEE: 83 Excel tips every user should master (TechRepublic)
I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier versions….