3 Ways to AutoFit all Columns and Rows in Excel

Рет қаралды 55,530

Technology for Teachers and Students

Күн бұрын

It's a constant struggle in Excel to keep columns and rows at the correct width and height in order to show all the important data in your spreadsheet. This video shows three ways to automatically fit your column widths and row heights to the data in your spreadsheet. One of the methods enables you to keep your hands on your keyboard as you work, helping you be a more efficient and effective Excel user. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here is the practice file for this video: bit.ly/excelautofit #excel #exceltutorials #microsoft365 #microsoftexcel

Пікірлер: 20

@tomjackson1548 3 күн бұрын

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😂

@nataliameyer4947 8 ай бұрын

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

@kathleenbabb7023 9 ай бұрын

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).

@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.

@RFVisionary 9 ай бұрын

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

@arifuzzamansumon6865 9 ай бұрын

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

@emeek91 9 ай бұрын

Awesome. I like the second way the best.😊

@sll99 9 ай бұрын

Thank you so much ❤

@Sanna99971 9 ай бұрын

The third one. Thank you.

@Dina-uz6ur 3 ай бұрын

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

@LiiLaGiusta 9 ай бұрын

I like last one!

@rms3365 5 ай бұрын

Thanks so much !

@dgirlsportable3196 29 күн бұрын

Definitely the second method

@66sandeep66 9 ай бұрын

Too good

@salaubiola9746 9 ай бұрын

Great

@mr.dovahkiin5335 9 ай бұрын

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

@arjunmalviya9028 9 ай бұрын

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

@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