Help need about MS Excel?

[kashifundlas]

faraz karain hamaray pass excel ki aik sheet mein work hua para hai...ab hamain osssy dosri file bana ker osss mein lay ker jana hai...jab hum ossay dosri file mein lay ker jatay hain mean copy kerky excel ki new sheet mein paste kertay hain to jo colum width hum ny pehli sheet mein adjust ki hoti hai wo sab change ho jati hai.. mean jaisay he dosri jaga paste kertay hain to coloum width kiu change ho jati hai....kia koi aysa tarika hai ky jaisay othain waisay he new sheet mein ajay.

[Khushi1]

bhai ap column ki width 2 second ma theek kr skty han.
Jahan pr column A, B, C likha hey. Ap column k right side pr mouse ly jaen ap ka mouse + k nishaan ma tabdeel ho jye ga. jb mouse + k nishaan ma tabdeel ho jye to double click kr dain ap ka column automatic value ki munasibat sy adjust ho jye ga. is tarah sab column ko adjust kr lain.

[kashifundlas]

bhai mein chahta hon ky adjust nahi kerna paray....automatically adjustment ho jay

[syar]

bhai mein chahta hon ky adjust nahi kerna paray....automatically adjustment ho jay

Sala::

As per my knowledge jese aap copy paste kar k AUTOMATIC adjustment chahte hain tu nahee ho ga, sewae aap macro use karain tu ho jae ga.
lekan agar aap sheet ka sara data dosri file m lejana chahte hain tu sheet he copy kar lain, copy paste ki zarorat nahee pare gi.

regards,

[sandhu16]

bhai ap aisa kare k jo sheet apne dosri excel book main yah sheet main copy past kerni hai sub se pahle us sheet per jaha sheet likha hota hai usper right click karen or move or copy per click karen phir woh apse poche ga k apne isi book per sheet ko copy kerna hai yah or kisi excel book per copy or move kerna hai woh apne niche creat a copy ko check laga ker move kerna hai apka kaam hogya jaise ap chahte teh ok main ne apki asani k liye screen short b attach kia hai dekh len.

[kashifundlas]

Thanks dear.............ye to sheeeeeeets ky liay ho gia.......lakin agar kuch colums ya rows ko select kerna ho to phr kia kya jaaaaaaay..............thanks again for your help