automatic adjust cell column width length | excel
Вставка
- Опубліковано 5 вер 2024
- hi
i am manoj kumar
in this video we are going to learn about
excel
autofit column width in excel
microsoft excel
autofit column width excel
autofit column width
ms excel
auto fit cell column row in excel
how to adjust column width in excel
autofit in excel
excel autofit column width
autofit column width excel 2016
excel tutorial
how to autofit column width in excel
autofit
auto adjust cell in excel
excel tips
automatic adjust cell width as per data
column width in excel
automatic adjust cell column width length
by@manojkumarexcel
I’m English and don’t understand but was very clear so I could follow regardless; good job! 🤝
Mind-blowing sir
not working saying object required
After it undo gone on holiday 😂😂
Save file as vba enable
Sir ek aur tarika hai
Full worksheet ko select karke cell block Mai jakar, Format per click kar ne per,ek list open hoti hai us mai Auto fit nam ka option hota hai us per click karne per, cell auto fit ho jate hai
Thanks. Nice one
Sir bohut bohut shukrya m bohut pareshan ta space ki waja se Ur apki chand second ki video NE Dil Khush kardya love you sir m apka fan hugaya Allah pak apko Ur ulaad ko hamesha Khush rake ❤❤❤❤
Why did you redeeeem it? 😂😂 saaaaar i love you very much saaaar i want to marry israel women
there is easier way, highlight entire cel or entire project that u want then select under cell tab pick format 'autofit collum width'
Very nice information bro.
Thanks
Osm sir u r the great 🥰💗💗💗💗💗
Thanks dear achha kaam ho raha hai
Aur v aisa video bhejiye
Good 👍 thanks for this video
Badhiya sir
Wow 😲 thank you very much
Thank you bro 😊😊😊
Thanku brother ❤❤❤
Thanks A lot Sir ji
very good very very useful tip sir
Undo went on holiday after it.
Thank you sir apne meri bhut help ki 🙏🙏🙏❤️❤️❤️❤️💋
Thank sir
Full Likes 👍👍👍👍👍
If you type iPad iPhone Apple Watch in a column, the column widens. But if you apply a filter and iPad ticks the column does not shrink because it keeps the width for the word Apple Watch even if hidden.
Thank you sir 😊
Amazing
my son used in school practical it worked
excelgurumanoj@gmail.com
Thanks
Good trick... Most useful trick for all. Thank you for sharing. 💐
didn understand a single word yet I succeeded the task
very nice 👍👍
Thank you! Cheers!
Thanks sir🙏
Thank u brother
Thank you!
Welcome!
Thank You.
You're welcome
Thank you so much
Tq u sir
Welcome
Superb
Excellent thank you
Thankyou so much sir 🙏🖤💫
Very gud
Shukria❤
Nice sir❤❤❤❤❤❤❤
Thank you 👍
Thanks ji.
Thank you
Tq
Tysm
Excellent sir
thanks sir
Are waah
Thanks
This works for rows also
Thnx sir ❤
Lol not English but understood it perfectly.. lol
Sir thank FYI, but while explaining pls say slowly
The title is masking the option..... please look into.....
bro ess sy undo aur redo nhi hota yeh code apply krny k baaad.. kisi ny note nhi kiya hoga
❤❤❤❤
सर मैं इस call मे कोई छोटा Data डालू तो वह Auto Filt ना हो । जब कोई बडा डेटा डालू तो वह Auto fite हो जाए ।
0:01
How to set for row height
Select all cells press Ctrl+H+O+A
Hatane k liye shortcut key ?
Find or replace open kr rha h
Program ko delete kar digiye
Sir normally ham excel me data type karte he to to wo upar se niche ko type karte he.
But Mera question ye he ki "me chahta hoo agar Mera pehla row ka kaam khatam ho jae to wo cell automatically niche chala jae or upar ek or row create ho jae or jis row ka kaam hogaya wo niche chala jae. Agar ye possible hai to please sir mere ko thoda guide kardijiye. Kese hoga ye."
You will get details video 8:00Pm
❤❤❤
0:14
How could i use it on google sheets ❤
Everything is good until Undo redo is not working 😅
Sir Excel table me mobile no count kese kare, reapet no. Count nhi karne
=count(unique(Range:Range)),
one more way is there for that u need 3 functions, =Sum(if(frequency(Range:Range,Same Range)>0,1))
Example: =SUM(IF(FREQUENCY(G2:G17,G2:G17)>0,1))
If view code not show then how to use this trick
Development tab me ja ke vew code me ja ke sheet pe click kare
@@manojkumarexcel where can I found Development tab , pls make an vedio on it briefly.
But after that my undo option not working...
How to adjust both rows and columns
excelgurumanoj@gmail.com
Or agar yhi fulmula ek sath 20 25 sheets me lgna ho to tb kaise karege
excelgurumanoj@gmail.com
Har new sheet men bar bar krna padraha hai...alwas fit ka koi option hai kya
excelgurumanoj@gmail.com
Auto fit cells ko kaise band kare sir ye bhi bata dijiye
Aap phir se o code ko delete kar digiye
sir ak dikkat or h koi bhi number excel par likhta hu to 3.788 likha kar ata h dot kaise hataye ki number ke beech me dot na aye
Aao manu bar me ja file pe click kare phir option me jaye advance pe click kare phir automatically insert a decimal point ko un check kar de
ua-cam.com/users/shortsZ7KzMQ3g858?feature=share
After this koi bhi column hide nahi hoga, any idea how to hide them
it's saying object required
Can you try in fresh sheet
Excellent
Good 👍👍👍👍
Bro aik sheet ha us main editing ni ho rahi protection lagi hui thi password bhool gaya hon ki ap help kr sakty han
Thanks for giving this opportunity
Follow this video
ua-cam.com/video/yKytCmrWlF8/v-deo.html
This any help be free to
er.manoj101@gmail.com
Thanks sir...but undo option is not working in this sheet..
excelgurumanoj@gmail.com
when I increase the text the cell automatically increased but when I delete the text the cell size is not decreasing. Please tell me a solution.
excelgurumanoj@gmail.com
2016 me karne pe nahi ho Raha hai
Argument not optional
Hoga
More details
Contact
excelgurumanoj@gmail.com
But ms word table kaise kare auto fit
pura table select karne ke baad >Table Layout > Cell Group > Autofit> Autofit content . ab aap jo bhi likho ge wah automatic adjust karega
How can i contact you?i need your help.
Yes
Contacts me
er.manoj101@gmail.com
Entire row hoga kia
Isko remove kaise krna hoga
Sheet ke upar right click kare view code per jaye or program ko delete kar de
Dimagh use kar samjhega
Sir mere laptop pe right click nahi hota kuch bhi nahi ata plz muze bataye
excelgurumanoj@gmail.com
Code likhna ka baad kya karna ha band kr rha hu to kuch nhi hua pehla jaisa hi ha
Aap save as macro enable me save kigiye
it is saying object required
View code ka option hi nhi ata
Mere pass ye option Q nh arha...? View code wala
Kon sa version use kar rahe hai
Full vedo kitna nambr
Jta already create asey oita ki korey thik korbo?
how to remove the autofit
Delete code
Wapis pahle jaise kaise kare
Delete kar de code
how to cancel autofit cells
Right click on sheet name go to view code and delete code
Ctrl+Z not working😢 sir
Es main bad m undo ni ho raha
Not support my pc
excelgurumanoj@gmail.com
Laptop me nahi kar Raha hai kaam
Nahieho raha
Super fast cannot understand
Debug likha aara hai
Contact me
er.manoj101@gmail.com
Javascript
excelgurumanoj@gmail.com