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?
@mr.dovahkiin5335
11 ай бұрын
I’m probably use the third option just because it easier to remember.
@arjunmalviya9028
11 ай бұрын
2nd and 3rd are same. 2nd is shortcut with keyboard use and no use of mouse.
@nataliameyer4947
10 ай бұрын
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
@RFVisionary
11 ай бұрын
👍🏻 Grate hint! I never saw them anywhere. The best shortcut for me is ALT+HOI resp. ALT+HOA. Really fast! Thx. ☀️
@arifuzzamansumon6865
10 ай бұрын
Thank you very much. Very very good tutorial. I am from Bangladesh.
@kathleenbabb7023
11 ай бұрын
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).
@emeek91
11 ай бұрын
Awesome. I like the second way the best.😊
@margievanhandel259
11 ай бұрын
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
@ericpeterson914
2 ай бұрын
When I do this is it doesn't save next time I open the document. ANy ideas?
@tomjackson1548
2 ай бұрын
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
10 ай бұрын
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.
@Sanna99971
11 ай бұрын
The third one. Thank you.
@Dina-uz6ur
5 ай бұрын
Thank you so much sir... It's really a big help...
Пікірлер: 23