Delete Hidden Rows and Columns in Excel (Quick and Easy)

Поделиться
HTML-код
  • Опубликовано: 25 окт 2024

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

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

    If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.

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

      You all probably dont care at all but does any of you know of a way to log back into an Instagram account?
      I somehow lost the password. I would appreciate any assistance you can give me!

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

      @Wilson Edward Instablaster =)

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

      @Julius Jeremy Thanks for your reply. I found the site thru google and im trying it out now.
      I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.

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

      @Julius Jeremy it did the trick and I now got access to my account again. Im so happy!
      Thanks so much you really help me out!

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

      @Wilson Edward no problem xD

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

    Thank you! The VBA code works perfectly!

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

    Always come with excel magic tricks, awesome.

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

    God bless u within 2 mins I sent my report also
    Yes I subscribed also ,😁👍🏼

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

    I watched a lot of videos on this and you presented the easiest formate. Thank You.

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

    Thank you for the tip on how to delete hidden rows and columns using document inspect which gave an info about worksheet as well.

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

    You are literally the only person I've found in over an hour of searching who actually addresses this issue. Everyone else I've found, over dozens of forums / articles, simply tell you to use the "Right Click + Delete" option, and afterwards the Deleted columns are simply replaced by more columns. Fucking infuriating. Thanks so much for your video!!!

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

    Hi Sumit. Great tips. Thanks for the video. Thumbs up!!

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

    Thank you for the detailed explanation!

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

    Thank you, neat little trick with that Document Inspector.

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

    Yes, its definitely new one. Suggest for an alternate way of doing it with 'Select visible cells' function too, to ease more for Users...

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

    Finally you are comeback! Please sir regularlly upload 1 or 2 videos per week because your excel videos are very helpful we get some new knowledge.

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

      I am guilty of not being consistent. I will try my best to publish at least once a week

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

    Hi Sumit, very productive and useful info

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

    thanks for very informative video👍

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

    Thank you, it is help a lot.

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

    very very useful video

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

    Thanks

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

    Can you Tell How to use named tablet on protected Excel sheets and use a Button to reset ALL filters with Just a simples click

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

    Can you assist in how to make a vendor data base

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

    Hi. Is there any way that converts basic formulas in into equation? eg. Say A1 is 5 n A2 is 3 and formula is A1+A2 which gives 8 , I want to convert it into equation which gives actual numbers for that cell i.e 5+3

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

      I want to convert cell reference into actual numbers like mathematical equation. Please do reply 🙏

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

    👍

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

    Hi.

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

    But... 🤔 why would I want to delete hidden rows and columns?

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

      I often do it when I download data from databases and hide rows/columns that I don't need immediately. Many times, I just end up deleting those. This can speed up the process.

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

      My use case was I had a filtered spreadsheet i was trying to only copy the rows displaying. Maybe there was another way to do this, but a straight copy & paste still copied all the data. So this allowed me to copy the entire data set and then remove what was filtered form a new sheet.

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

    Thanks

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

    Thanks