HomeОбразованиеRelated VideosMore From: Dinesh Kumar Takyar

Autofit Data in Excel Worksheets Automatically

233 ratings | 67539 views
You can automate the process of autofitting entered data in Excel worksheets using one line of code. For more details visit: http://www.familycomputerclub.com/Autofit-Data-Automatically-in-Columns-in-MS-Excel.html
Html code for embedding videos on your blog
Text Comments (35)
nazir ksa (1 month ago)
If we want to remove this excel VBA, how this can be done?
Dinesh Kumar Takyar (1 month ago)
1. Click on the Developer tab. 2. Select Visual Basic 3. In the Visual Basic Editor window that pops up, select Project Explorer 4. Click on Modules to see your module. 5. Right Click on Module1, for example and select 'Remove...' 6. In the New Window ' Do you want to export ...?', select 'No'
Mark Johnson (1 month ago)
what kind of monster would thumbs down this video, this was perfect
Sami Odeh (3 months ago)
Can I apply this developer to every sheet I automatically open as new Or I have to do it every time Please respond Thank you
Sami Odeh (3 months ago)
Thank you my friend It was really amazing Am searching now for solution of a sheet that sorts automatically the data by date in it once entered Do you have any ideas for that??? I repeat my thanks for your efforts Sami Odeh
lin xinxia (7 months ago)
Hi its works! However, if i wan use in a excel template and whenever i insert the excel template, the code will follow and automatically autofit the row n column too. However, it doesnt follow. Anyone knows how?
Manjeet Kumar Verma (8 months ago)
Thanks it helpful information.
A. B. (11 months ago)
amazing it's also possible to do it for Rows(). or to combine both rows and columns ;-)
Simon Lea (1 year ago)
Thank you very helpful :)
MEL VILL (1 year ago)
Was quite useful, thank you
Lenka Hrivnáková (1 year ago)
Thank you! It helped me with the row height!
Diva9000x (1 year ago)
I didn't know if there was such a "thing". Searched youtube and found you. Works great. Thanks! I subscribed.
Colleen Stuart (1 year ago)
Thanks for the great help.  I was able to follow your instructions step by step, pausing the instructions as needed, and it worked exactly as I wanted!   Thank you for posting this helpful instructional video. :)
bhanu pratap (1 year ago)
is there any option to do it auto height other than autofit
Dinesh Kumar Takyar (1 year ago)
You can specify height and width for a range.
Steve Cartin (1 year ago)
Very helpful - thanks!
Mollie Lindholm (1 year ago)
What a helpful tutorial! Thank you Dinesh!
Nitesh Khatri (1 year ago)
Really nice tutorial. Thank you for sharing it.
Mangalam Mallikarjunan (2 years ago)
What do I do if I have auto fit two or more row and each row not exceeding the "I" column (for print purposes)
Ryan (2 years ago)
Brother, I had been searching the bet for that exact answer!! Everyone else gives you the ridiculous answer of selecting Autofit Column Width after entering the data or select the entire sheet and double click the column heading. It was so super frustrating because the question I asked specifically stated "AUTOMATICALLY" as in immediately after I enter the data. Its like they just were not reading the question. So just a huge thanks for taking the time out of your day to make this video - sending good vibes your way
Frank Coughlin (2 years ago)
Thanks Dinesh, this was helpful.
Dadee Bee (2 years ago)
I have a formula in a cell that calculates the number of hours worked using drop downs containing tiime such as 7:00 AM, etc. On the same drop downs are "SAT, SUN, PTO, HOL. How can I make the total number of hours on the cell to show "0" if those texts are chosen. Please help Doctor. Thanks and more power!
Dinesh Kumar Takyar (2 years ago)
Let's assume your drop-down values are shown in Range C2 and you wanted to show '0' in Range F2: In Range F2 you can write the formula: IF(C2="SAT",0,IF(C2="SUN",0,IF (C2="PTO",0,IF(C2="HOLIDAY",0))))
Dadee Bee (2 years ago)
Hi, nice tutorial. What about if I only want "some cells" to auto-adjust?
Dadee Bee (2 years ago)
Thank you Doctor!
Dinesh Kumar Takyar (2 years ago)
Use the RANGE, CELLS or cells property with the range property: http://www.exceltrainingvideos.com/select-activate-excel-cells-vba/ http://www.exceltrainingvideos.com/cells-property-in-vba/ http://www.exceltrainingvideos.com/copy-paste-multiple-rows-of-data-from-one-workbook-to-another-using-excel-vba/
Phong Lan Ho (2 years ago)
thank you!
Dianne Pat-Ekeji (2 years ago)
Amazing, thank you :)
Great!!! Thank you very much! Like Dustin says... you are the Man!!!
Thành Phát Ung (2 years ago)
Thank you very much....! :D
Thank you for this great information, your work is much appreciated!
Eye opening!
Dustin Draper (4 years ago)
Sweet! You da man!
Ivan Carrillo (5 years ago)
Hello, can you please help me with something? What function or formatting do I need if I have a salesforce list that I want to automatically update its order based on sales amount also in excel? 
Mihai Ciprian Mitrea (5 years ago)
i'm trying to do the same thing with rows but it's not working. Any solutions? Thank you

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.