EXCEL TIP INSERT BLANK COLUMNS AFTER EVERY DATA COLUMN IN EXCEL

Поделиться
HTML-код
  • Опубликовано: 26 авг 2024
  • 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
    www.howtoexcela... and get my free Top Tips for Excel Ebook Immediately
    Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macrosmondays on the www.howtoexcela... blog.
    Be Social & Let's Connect
    ++Website www.howtoexcela...
    ++Twitter / howtoexcelatex
    ++Pinterest / howtoexcelat

Комментарии • 69

  • @dipeshpoudel2035
    @dipeshpoudel2035 8 месяцев назад +1

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

  • @DMH_701
    @DMH_701 4 года назад +5

    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
    @BEDIANSPINS 4 года назад +7

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

    • @Howtoexcelatexcel
      @Howtoexcelatexcel  4 года назад +1

      Well, I'm glad it has helped you thanks for the comment. Take Care.

  • @TheAf7850
    @TheAf7850 2 года назад +1

    You are a genius, thank you :)

  • @13ApnaSchool
    @13ApnaSchool 2 года назад +1

    Thanks!
    I was thinking all tech things to solve this!!!
    It's damm simple

  • @ravalikak5322
    @ravalikak5322 Год назад +1

    Thank you so much it is really help ful

  • @natasmart1191
    @natasmart1191 3 года назад +5

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

  • @samarths.hosamani2226
    @samarths.hosamani2226 Год назад +1

    Thanks a lot!!!! 🎉

  • @sonaoan5639
    @sonaoan5639 3 года назад +1

    Excellent, thanks you

  • @onelpecom1427
    @onelpecom1427 Год назад +1

    Thank you ❤️

  • @ganeshkamble22
    @ganeshkamble22 2 года назад +1

    Thank you So much

  • @leroyguillot481
    @leroyguillot481 5 лет назад +4

    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

  • @algo7147
    @algo7147 2 года назад +1

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

  • @laghmanee
    @laghmanee 4 года назад +2

    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.

  • @fplbenchwarmers6144
    @fplbenchwarmers6144 Год назад +1

    Thank you

  • @user-xn7dm7rr2h
    @user-xn7dm7rr2h 2 года назад +1

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

  • @sdpl-nka6854
    @sdpl-nka6854 5 лет назад +2

    THANKU VERY MUCH FOR SUCH SIMPLE TRICK

  • @loki112000
    @loki112000 2 года назад +1

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

  • @oidevictor9684
    @oidevictor9684 3 года назад +1

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

  • @laghmanee
    @laghmanee 4 года назад +2

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

  • @adriaansmit81
    @adriaansmit81 4 года назад +1

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

  • @chirpy1381
    @chirpy1381 3 года назад +1

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

  • @evanprinsloo6412
    @evanprinsloo6412 3 года назад

    Brilliant hack!!

  • @RyanCooper101
    @RyanCooper101 2 года назад +1

    This was extremely useful, thanks

  • @LeszekTor888
    @LeszekTor888 3 года назад +1

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

  • @VolMarlb
    @VolMarlb 4 года назад +1

    Fantastic trick! Thanks!

  • @user-ig6hc3mv2c
    @user-ig6hc3mv2c 3 года назад +1

    ty

  • @janelleg597
    @janelleg597 4 года назад +3

    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

  • @kunarmodi
    @kunarmodi 4 года назад +1

    thats amazing, and so simple, wow

  • @srinivasannarayanaswami5378
    @srinivasannarayanaswami5378 3 года назад +1

    Simply Awesome. Thanks a ton :-)

  • @sreedharkurakula
    @sreedharkurakula 3 года назад

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

  • @rohitvyas7352
    @rohitvyas7352 4 года назад +2

    Amazing super smart

    • @Howtoexcelatexcel
      @Howtoexcelatexcel  4 года назад

      Thanks for the comment. Happy it helped your Excel work.
      Regards

  • @campsummer6811
    @campsummer6811 6 лет назад +1

    Great video!

  • @shijumonpm
    @shijumonpm 5 лет назад +1

    good

  • @liveinvrindavan1763
    @liveinvrindavan1763 2 года назад

    I followed same steps but nothing happened.