You can automate the process of autofitting entered data in Excel worksheets using one line of code. For more details visit: www.exceltrainingvideos.com/a...
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
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. :)
Another and whole lot easier way to AutoFit column width is as follows: Select one, several, or all columns on the sheet, go to the Home tab -> Cells, and click Format -> AutoFit Column Width. For 'Row Height' it's the same process, but then instead, obviously, just choose 'AutoFit Row Height'.
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
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?
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?
This gives me hope, so thank you. But can this technique be adapted to resize only columns only as they are expanded (revealed) when interacting with a pivot table? Currently, every time you click a "+" or "-" within a pivot table, the columns of interest do not adjust in width to reveal the data (i.e., you must manually widen the column you just "revealed" in order so see the data). This behavior is an extraordinary waste of time. Is there a solution?
If you wish to change the columns width in a pivot table, you need to check the pivottable.TableRange.Columns property. Example: pivottable.TableRange1.Columns.AutoFit
Use the RANGE, CELLS or cells property with the range property: www.exceltrainingvideos.com/select-activate-excel-cells-vba/ www.exceltrainingvideos.com/cells-property-in-vba/ www.exceltrainingvideos.com/copy-paste-multiple-rows-of-data-from-one-workbook-to-another-using-excel-vba/
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!
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))))
This tutorial in Excel will guide: www.exceltrainingvideos.com/how-to-extract-specific-words-from-excel-database/ You can also search my website: www.exceltrainingvideos.com
Thanks.Sir you have solved my long awaited problem as i was trying many times but error was the result.since i amfrom other field .will you pl. let me know for every sheet we have to go as such or is there any permanent solution. waiting for your reply. smsharma
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'
@@Exceltrainingvideos The same happens to me, and you can clearly see it happens on your video, just watch the Undo arrow turns grey when you enter new value (2:55 and 3:10). Good tutorial though, shame we have to sacrifice such an important function
I want this code to work on every screen or active cell In our sense we have text in A1 Very long , the code will display column width according to A1 But if you went down to the cell A100 With a text of 4 characters, for example I want the width of the column to be according to these four letters
you do not need to have VBA for this. Because every .xls you can't convert to .xlm for VBA. Just right click the cell where you want to have your figures for auto width of Colum > right click> format cell>Numbers > select coma separate check box. That's all. now check it
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
I didn't know if there was such a "thing". Searched youtube and found you. Works great. Thanks! I subscribed.
what kind of monster would thumbs down this video, this was perfect
A huge thanks for you
Appreciate your feedback.
Thank you for this great information, your work is much appreciated!
Great!!! Thank you very much! Like Dustin says... you are the Man!!!
What a helpful tutorial! Thank you Dinesh!
Thank you! It helped me with the row height!
amazing
it's also possible to do it for Rows(). or to combine both rows and columns ;-)
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. :)
Thanks a lot! Really useful.
Glad it was helpful!
Very helpful - thanks!
Thank you very helpful :)
Was quite useful, thank you
Really nice tutorial. Thank you for sharing it.
Thanks Dinesh, this was helpful.
Eye opening!
Sweet! You da man!
thank you!
Thanks it helpful information.
i'm trying to do the same thing with rows but it's not working. Any solutions? Thank you
Thank you very much....! :D
What do I do if I have auto fit two or more row and each row not exceeding the "I" column (for print purposes)
Another and whole lot easier way to AutoFit column width is as follows: Select one, several, or all columns on the sheet, go to the Home tab -> Cells, and click Format -> AutoFit Column Width.
For 'Row Height' it's the same process, but then instead, obviously, just choose 'AutoFit Row Height'.
Why not?
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
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
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?
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?
Amazing
Thank you! Cheers!
This gives me hope, so thank you. But can this technique be adapted to resize only columns only as they are expanded (revealed) when interacting with a pivot table? Currently, every time you click a "+" or "-" within a pivot table, the columns of interest do not adjust in width to reveal the data (i.e., you must manually widen the column you just "revealed" in order so see the data). This behavior is an extraordinary waste of time. Is there a solution?
If you wish to change the columns width in a pivot table, you need to check the pivottable.TableRange.Columns property.
Example: pivottable.TableRange1.Columns.AutoFit
is there any option to do it auto height other than autofit
You can specify height and width for a range.
Hi, nice tutorial. What about if I only want "some cells" to auto-adjust?
Use the RANGE, CELLS or cells property with the range property:
www.exceltrainingvideos.com/select-activate-excel-cells-vba/
www.exceltrainingvideos.com/cells-property-in-vba/
www.exceltrainingvideos.com/copy-paste-multiple-rows-of-data-from-one-workbook-to-another-using-excel-vba/
Thank you Doctor!
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!
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))))
Can we have fixed width for name and surname in a cell.
Like
Name surname
Deepak Patwa
Catherine. Washington
Sebastian. Richardson
This tutorial in Excel will guide: www.exceltrainingvideos.com/how-to-extract-specific-words-from-excel-database/
You can also search my website: www.exceltrainingvideos.com
Thanks.Sir you have solved my long awaited problem as i was trying many times but error was the result.since i amfrom other field .will you pl. let me know for every sheet we have to go as such or is there any permanent solution.
waiting for your reply.
smsharma
This solution in Excel works for all worksheets in a workbook.
How do I accomplish this in Excel for Mac Office 365?
This link will help find a solution: www.rondebruin.nl/mac.htm
If we want to remove this excel VBA, how this can be done?
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'
Mr. Dinesh I have a question. After doing this, my Ctrl+Z function stopped functioning. Can you tell me why please?
Thank you so much,
Jorge
Did you use the Ctrl+Z as a shortcut for your macro?
@@Exceltrainingvideos The same happens to me, and you can clearly see it happens on your video, just watch the Undo arrow turns grey when you enter new value (2:55 and 3:10). Good tutorial though, shame we have to sacrifice such an important function
I want this code to work on every screen or active cell
In our sense we have text in
A1
Very long , the code will display column width according to
A1
But if you went down to the cell
A100
With a text of 4 characters, for example
I want the width of the column to be according to these four letters
This link will help: www.exceltrainingvideos.com/autofit-data-automatically-in-columns-in-ms-excel/
Or search www.exceltrainingvideos.com
you do not need to have VBA for this. Because every .xls you can't convert to .xlm for VBA. Just right click the cell where you want to have your figures for auto width of Colum > right click> format cell>Numbers > select coma separate check box. That's all. now check it
We are learning how to automate processes in Excel. Of course, most of know how to autofit data in Excel using standard procedures.
No developer option
This link will help: www.exceltrainingvideos.com/how-to-display-developer-tab-in-microsoft-excel-2010/