Hello Excellers, in this blog post today lets look at insert blank column or blank columns after every data column in your Excel worksheet.
This blog post is in answer to a lot of questions from subscribers and viewers. It is based on one of my most popular YouTube Videos. In that video, I show you how to insert rows into your Excel worksheet after every row of data. Want to watch the video?. Click on the link below.
If you liked the video then don’t forget to SUBSCRIBE and give the video and THUMBS UP. I really do appreciate it.
Follow these instructions for Excel Tip if you want to insert BLANK COLUMNS into your Excel worksheet after every column of data.
In row 1 above our column headings just type 1 to 5 along the top row. You will need to insert a row above your data if you do not have already a spare row on your Excel worksheet. In this example, our columns have been numbered from 1 to 5.
After you have Select the numbered cells hit copy. You need to then paste them after you last numbered cell, in this example, I have used, it is five as we have five columns.
- Then, select all of your columns, including the ones that you have created in the step above.
- Select Home Tab | Editing Group | Custom Sort
- Select sort by Row 1 | Options | Orientation | Sort Left To Right
- Hit Ok twice
You now have a blank column after every data column on your Excel worksheet.
Do You Want To Watch The Video?
If you want more Excel and VBA tips then sign up for my Monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.