3 Ways to AutoFit all Columns and Rows in Excel

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

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

  • @nataliameyer4947
    @nataliameyer4947 9 месяцев назад +2

    To me the easiest way to fit the cell will be the double clicking in beteween row/ collums . Thank you for your great tutorials . I watch them ( even when I do not need any refreshers ) that is how much I love them

  • @lamdubitrus
    @lamdubitrus 3 дня назад

    Thanks a lot bro

  • @kathleenbabb7023
    @kathleenbabb7023 9 месяцев назад +1

    Thank you for sharing your knowledge. It is so hard to decided on which one but I could see myself using either the first option (just to be familiar with the process) or the third option (it is easy to follow).

  • @RFVisionary
    @RFVisionary 9 месяцев назад +1

    👍🏻 Grate hint! I never saw them anywhere. The best shortcut for me is ALT+HOI resp. ALT+HOA. Really fast! Thx. ☀️

  • @tomjackson1548
    @tomjackson1548 22 дня назад

    Auto fit row height was the one thing I struggled with, and all of these are great tips. But that is the one that I will use the most. At least I think so; but I will probably use all of them lol😂

  • @SkromnitsaKrasotka
    @SkromnitsaKrasotka 9 месяцев назад

    Thank you so much for sharing every little trick with us, things that might be simple for you and so useful and new for others like myself. I love the idea that your videos are so short, anyone can find 5 mins to keep learning and feel good about it 🙂 I`ll try the 2nd method tomorrow.

  • @arifuzzamansumon6865
    @arifuzzamansumon6865 9 месяцев назад +1

    Thank you very much. Very very good tutorial. I am from Bangladesh.

  • @emeek91
    @emeek91 9 месяцев назад +1

    Awesome. I like the second way the best.😊

  • @LiiLaGiusta
    @LiiLaGiusta 9 месяцев назад +1

    I like last one!

  • @Sanna99971
    @Sanna99971 9 месяцев назад +1

    The third one. Thank you.

  • @mr.dovahkiin5335
    @mr.dovahkiin5335 9 месяцев назад +2

    I’m probably use the third option just because it easier to remember.

    • @arjunmalviya9028
      @arjunmalviya9028 9 месяцев назад +1

      2nd and 3rd are same.
      2nd is shortcut with keyboard use and no use of mouse.

  • @sll99
    @sll99 9 месяцев назад +1

    Thank you so much ❤

  • @Dina-uz6ur
    @Dina-uz6ur 3 месяца назад

    Thank you so much sir... It's really a big help...

  • @dgirlsportable3196
    @dgirlsportable3196 Месяц назад

    Definitely the second method

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

    Thanks so much !

  • @salaubiola9746
    @salaubiola9746 9 месяцев назад +1

    Great

  • @66sandeep66
    @66sandeep66 9 месяцев назад +1

    Too good

  • @ericpeterson914
    @ericpeterson914 Месяц назад

    When I do this is it doesn't save next time I open the document. ANy ideas?

  • @ShrillB
    @ShrillB 5 дней назад

    Do you happen to know of a way one can enable excel to automatically and permanently autofit row heights and column widths?
    I have referred my question to Microsoft representatives, stack overflow.
    I have been told my inquiry will probably be conducted through macros. I have reached a point where a particular macro does indeed work; however, functions such as the undo function (control + z) does not work.
    Unless there is a button in excel I simply have to press to enable this to happen, I have had no luck with my inquiry.
    I was told by one person on stack overflow that my inquiry is impossible to complete. Do you happen to know of a way I can complete this?

  • @margievanhandel259
    @margievanhandel259 9 месяцев назад

    Finding your tutorials very interesting, but I don't find myself usually needing to work in a spreadsheet. I've been looking for some help on YT and can't seem to locate what I'm looking for. Might you be able to advise please? When I enter a specific cell size, the worksheet doesn't print out with those measurements. Example, if I have 8 rows being 1" each, when I print it doesn't equal 8". I require this precision, and actually need to end up with this file in a photo editing program. I've saved as pdf. Converted to jpg to use as an image. In none of the file formats do I get the row height as needed. But, the width always comes out. I have to be missing something in Excel that this isn't working. Suggestions would be greatly appreciated. Thanks