EXCEL TIP INSERT BLANK COLUMNS AFTER EVERY DATA COLUMN IN EXCEL

Learn how to quickly insert blank columns in between data columns in Excel. No macros, no formulas, here is a really quick way to insert blank columns into your Excel data set.

SUBSCRIBE TO THE EXCEL AT EXCEL NEWSLETTER - 3 FREE Excel Tips First Wednesday of EVERY month. Join US! Click the link below

Be Social & Let's Connect

[DMH_]

This is the most brilliant trick I've ever heard! So simple and solved my problem perfectly! I love when the researching and fixing the problem takes less time than the alternative!

[BEDIANSPINS]

OMG! Please ask someone whose nearby to give u a Hug for this!!!

[natasmart]

OMG, you've just saved me HOURS of work! Thank you so much for this tip! Love it! <3

[dipeshpoudel]

Just the thing I was looking for! Thank you millions :D

[leroyguillot]

Heck Yeah!!! I love it! I can't tell you how many time I have tried to figure something out for this scenario. Thanks a Bunch

[laghmanee]

You are a life and time saver!!! thank you so much for this tip. I was working on 400 columns and needed to add three additional column between those columns LOL. I copied and pasted the numbers for each column three times and did the sort and that did.

[laghmanee]

The only question I have is that what is the quickest way to paste data into those columns, such as formulas?

[algo]

Oh Lord, what a simple amazing trick that saved me hours of work. Thank you. Subscribed.

[ApnaSchool]

Thanks!
I was thinking all tech things to solve this!!!

It's damm simple

[LeszekTor]

Wow. great. So simple but so useful. Thank you.

[ravalikak]

Thank you so much it is really help ful

[loki]

You are a GENIUS and a GOD! Wow. Thanks for sharing.

[sreedharkurakula]

Wonderful. Saved my time. Thanks for the education :)

[adriaansmit]

Thank you very much, Barbara. You helped me solve my very specific problem.

[sdpl-nka]

THANKU VERY MUCH FOR SUCH SIMPLE TRICK

[xndmrrh]

I subscribed after watching this tip and am coming back here today because I forgot how to do it haha. Thanks!

[janelleg]

If only Columns appear in your Sort menu, select Options, then Left to Right. You then should be able to sort by row.


THANK YOU

[oidevictor]

I don't know how u managed to know this. This is wao. Thanks a million.

[chirpy]

How simple it is but until I watched this video I hated to repeatedly inserting columns or rows manually. Thank you for showing it.

[liveinvrindavan]

I followed same steps but nothing happened.