Это видео недоступно.
Сожалеем об этом.

3 Right Ways to Delete Blank Columns in Excel

Поделиться
HTML-код
  • Опубликовано: 13 авг 2024
  • In this video, I will show you 3 different methods you can use to quickly delete blank columns in Excel.
    I am also going to cover one additional method that works well but needs to be used cautiously, as it can lead to issues
    00:00 Intro
    00:25 Delete Blank Columns using SORT method
    03:12 Delete Blank Columns using Find & Replace method
    05:55 Delete Blank Columns using VBA
    10:07 Delete Blank Columns using Go To Special (NOT recommended)
    ------------------------------------------------------------------------------------------------
    Below is the VBA code I used in the video:
    'Code Developed by Sumit Bansal from TrumpExcel.com
    Sub DeleteBlankColumns()
    Dim EntireColumn As Range
    On Error Resume Next
    Application.ScreenUpdating = True
    For i = Selection.Columns.Count To 1 Step -1
    Set EntireColumn = Selection.Cells(1, i).EntireColumn
    If Application.WorksheetFunction.CountA(EntireColumn) = 0 Then
    EntireColumn.Delete
    End If
    Next
    Application.ScreenUpdating = True
    End Sub
    ------------------------------------------------------------------------------------------------
    Video about Personal Macro Workbook - • Personal Macro Workboo...
    ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com...
    ✅ Free Dashboard Course - bit.ly/free-ex...
    ✅ Free VBA course - bit.ly/excel-v...
    ✅ Free Power Query Course - bit.ly/power-q...
    ✅ Best Excel Books: trumpexcel.com...
    Subscribe to get awesome Excel Tips every week: www.youtube.co...
    #Excel #ExcelTips #ExcelTutorial

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

  • @itsmesujoy9351
    @itsmesujoy9351 Год назад +9

    The most trusted channel for excel...

  • @GJK7
    @GJK7 Год назад +4

    Your videos and mails are always soooo helpful. Thanks, Sumit!

    • @trumpexcel
      @trumpexcel  Год назад

      Glad you're finding the videos useful 🙂

    • @daleanderson5258
      @daleanderson5258 Год назад

      I definitely agree! They are always relevant and helpful.

  • @timmyvawwter8898
    @timmyvawwter8898 Год назад +3

    You're an excellent Excel master!

    • @trumpexcel
      @trumpexcel  Год назад

      Thanks Timmy... Glad you're finding the videos useful!

  • @redhaal-obaidy2217
    @redhaal-obaidy2217 Год назад +1

    Thanks for posting these useful information
    I actually do them manually depending on different datasets that I need to keep the blank columns…
    But thanks, there are some keyboard shortcuts that I can certainly use in my work.

  • @bhaumikder8279
    @bhaumikder8279 7 месяцев назад +1

    Extraordinary.........
    I have watched so many videos which were repeating the same go to method but this one gave me the ultimate solution.
    Can you please provide the VBA code to delete the blank rows?

    • @trumpexcel
      @trumpexcel  6 месяцев назад

      Glad the video was helpful. You can get the VBA code to delete blank rows here - trumpexcel.com/delete-blank-rows-excel/#Remove-Blank-Rows-Using-VBA-Macro

  • @sydneychidambaram7685
    @sydneychidambaram7685 Год назад

    Thank you for these excellent videos, you explain the functions simply and we can understand it very easily. simply Awesome

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

    Very very detailed and lovely explanation

  • @ShpinTwin
    @ShpinTwin 4 месяца назад

    This video is so helpful! Thank you! Any tips for removing columns where there is a heading but the rest of the column is empty?

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

    Thanks Sumit, very handy.

  • @deepanshuwadhwa191
    @deepanshuwadhwa191 Год назад

    Very informative. Thank you so much for helping.

  • @BenDieselBasicAutomotive
    @BenDieselBasicAutomotive Год назад

    Wow!..... Thank you very much for the knowledge gained..

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

    Really useful, Sumit ji.

  • @patwaripiyush
    @patwaripiyush Год назад

    Thank you sumit you dont know you have made my life so much simpler i need your help in devoloping an if condition in power query if you can help please

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

    Thanks, this is helpful for sure.

  • @zamarshaikh3902
    @zamarshaikh3902 Год назад

    Hey Thankyou So much, That was really helpful appreciate your Good work!

  • @vivekjoshi3769
    @vivekjoshi3769 Год назад

    Could you please guide me on what tool you use for recording while speaking and zooming in for tutorials?
    I am looking to create some content and looking for ideas. Thanks & lots of love!

  • @adambomb418
    @adambomb418 4 месяца назад +1

    Thanks!

  • @huyne_info
    @huyne_info Год назад

    Thank you so much

  • @tinboy2007
    @tinboy2007 Год назад

    Hi, could you please share the code to add sensitivity label to bulk emails triggered from excel file. Would appreciate your help, thank you in advance 😊

  • @InsightfulJourney123
    @InsightfulJourney123 Год назад

    Thank you 🙏

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

    Thank you very much for your hard work. Great video 📹 👍

  • @nitishgoyal6851
    @nitishgoyal6851 Год назад

    Sir there is a Playlist for add. Topic Covered by You that's not showing up now please Help

  • @tarique1116
    @tarique1116 Год назад

    Sir I'm binge watching your Excel dashboard course nowadays but the download files you given in description is not able to download please make it available

  • @azeezsid
    @azeezsid Год назад

    Thanks 👍 Sir help me

  • @payaljain5497
    @payaljain5497 Год назад

    Hello Sumit, when are you going to upload office 365 most important excel formulas? Pleaseee make a long video with examples....i am looking forward for the same desperately... Thank u....

    • @vivekjoshi3769
      @vivekjoshi3769 Год назад

      Excel 365 is heck expensive. Are you really using it? I saw for individual it's 5000 per year or something 😢

  • @azeezsid
    @azeezsid Год назад

    Thanks 👍 Sir.... Pls Share your Bio .on RUclips

  • @NaveenKumar-tr6xo
    @NaveenKumar-tr6xo Месяц назад

    You are clicking on entire colum,and saying entire row in vedio

  • @scottwilkerson1208
    @scottwilkerson1208 11 месяцев назад

    Why would I need a 13 minute video to delete a single blank column between six columns? I could just highlight the column, right-click, delete. I'm trying to get rid of the thousands, literally INFINITE columns to the right of my data. Why can I not find a single video on how to do this, and why does Excel make it nearly impossible to do unless you are an Excel MASTER???

    • @trumpexcel
      @trumpexcel  11 месяцев назад

      Deleting a few columns can be done manually, but it's tricky when you have too many blank columns interspersed in the data. I agree, would have been better if there was an in-built way (like remove duplicates), but till we get it, these are the only ones I could figure out