Gacanta lagu hagaajinayo balacyada tiirarka ee Microsoft Excel ma noqon karto oo kaliya waqti-qaadasho laakiin sidoo kale waxay noqon kartaa mid adag. Nasiib wanaag, waxaa jira hannaan ku-meel-gaar ah oo kuu oggolaanaya inaad nuqul ka sameysid ballaca tiirka ee Excel^{(copy column width in Excel)} si fudud. Tixraac tillaabooyinka lagu bixiyay boostada si aad u nuqul ka sameysid ballaadhka tiirka gudaha Excel .

Sida loo koobiyeeyo Width Sarifka gudaha Excel

Qaabaynta shaxanka Excel waxa inta badan loo sameeyaa si ay u waafaqdo dhererka qoraalka. Si kastaba ha ahaatee, markaad koobiyayso oo aad ku dhejiso fayl kale oo Excel ah, midna qaabaynta asalka ah laguma hayo. Waa kan waxa ay tahay inaad sameyso!

1. Fur faylka Excel.
2. Midig ku dhufo unugyada oo dooro Koobi^(Copy) .
3. U beddel faylka cusub ee Excel
4. Guji falaarta^(Paste) hoos-u-dhaca ku dheji.
5. Dooro balacyada tiirka isha^{(Keep source column widths)}

Kadib markaad talaabooyinkan kor ku xusan si isku xigta u dhamaystirto, Microsoft Office Excel waxa uu si toos ah u cusboonaysiin doonaa ballaca tiirarka bartilmaameedka si uu u waafajiyo tiirarka isha isla markiiba!

Si aad u koobiyaysid ballaca tiirka isha ilaa tiirka bartilmaameedka ee faylka cusub ee Excel , fur isha faylka Excel .

Dooro unugyada balaca tiirkooda aad rabto inaad ku sii haysato faylka cusub.

Midig ku dhufo unugga oo dooro ikhtiyaarka nuqulka^(Copy) . Haddii kale, waxaad riixi kartaa furayaasha Ctrl+C isku mar si aad u sameyso fal isku mid ah.

Hadda, u beddel faylka cusub ee Excel kaas oo aad jeclaan lahayd inaad sii haysato ballaca tiirka faylka isha.

Tag faylka faylka^(File) oo ku yaal liiska Ribbon .

Hoostiisa, dhagsii fallaadha^{(Paste )} hoos-u-dhaca ee paste.

Intaa ka dib liiska xulashooyinka dhejiska^(Paste) ee lagu soo bandhigay, dooro Keep isha balacyada tiirarka^{(Keep source column widths )} . Marka la isticmaalo farta caadiga ah iyo cabbirka farta, ballaca ugu badan ee tiirku waa 255. Ballaca ugu yar waa eber. Haddii ballaca tiirku eber yahay, tiirku waa la qarin doonaa.

Marka la sameeyo, Excel wuxuu cusboonaysiin doonaa ballaca tiirka bartilmaameedka ee faylka cusub ee Excel si uu u dhigmo tiirarka isha faylka asalka ah.

Rajo in taasi ku caawiso!

Hadda akhri^{(Now read)} : Sida hal mar loo geli karo safafka maran ee Excel .

How to copy Column Width from source to another spreadsheet in Excel

Manually adjuѕting the column widths in Microsoft Excel can not оnlу be time-consuming bυt alsо laborious. Fortunately, there’s a workaround that lets you copy column width in Excel easily. Refer to the steps given in the post to copy column widths in Excel.

How to copy Column Width in Excel

The formatting of tables in Excel is mainly done to match the length of the text. However, when you copy and paste it into another Excel file, none of the original formattings is retained. Here’s what you must do!

1. Open the Excel file.
2. Right-click the cells and select Copy.
3. Switch to the new excel file.
4. Click Paste drop-down arrow.
5. Choose Keep source column widths

After you complete the above steps in sequence, the Microsoft Office Excel app will automatically update the target columns column width to match the source columns in an instant!

For copying the source column’s width to the target column in the new Excel file, open the source Excel file.

Select the cells whose column width you would like to retain in the new file.

Right-click a cell and choose the Copy option. Alternatively, you can press Ctrl+C keys simultaneously to perform the same action.

Now, switch to the new Excel file in which you would like to retain the column width of the source file.

Go to the File tab located on the Ribbon menu.

Under it, click the Paste drop-down arrow.

Thereafter from the list of Paste options displayed therein, select Keep source column widths option. When the default font and font size is used, the maximum width for a column is 255. The minimum width is zero. If a column width is zero, the column will be hidden.

Once done, Excel will update the target column’s column width in the new Excel file to match the source columns of the original file.

Hope that helps!

Now read: How to insert Multiple Blank Rows in Excel at once.

Related posts

• Sida loo beddelo Dhererka Safka iyo Balaadhka Tiirka gudaha Excel

• Isticmaal kiiboodhka si aad u bedesho dhererka safka iyo ballaca tiirka gudaha Excel

• Sida loo abuuro Graph Bar ama Shaxda Saxiixa ee Excel

• Balacaha Saarka AutoFit iyo Dhismayaasha Saf ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel