Qulqulka qoraalka^{(Text overflow)} ayaa jebin kara muuqaalka xaashida iyadoo laga yaabo inay u ekaato mid dhib badan qoraallo buuxdhaafay oo ka soo baxaya unug. Haddii aad haysato xaashi faafin dhibaatadan leh, waxaad hagaajin kartaa arrinta qulqulka qoraalka ee Microsoft Excel si ay ugu muuqato mid ka sii fiican oo nadiif ah.

Waa maxay qulqulka qoraalka ee Microsoft Excel

Sida magacu u qeexo, haddii qoraalku ka baxayo unug ka baxsan, waxa loo yaqaan qoraal-soo-bax. Balaadhka caadiga ah ee unugga waxa laga yaabaa inaanu had iyo jeer u hoggaansanayn ballaca qoraalka oo dhan. Balaadhka caadiga ah ee unugga Excel waa 8.43mm, taas oo ah mid aad u yar, dadka intiisa badanna waxay la kulmaan dhibaatooyin. Waqtigaas oo kale, qoraalka ayaa lagu qariyaa unugga dhinaca midig, mana la heli karo wax akhrinta marka aad dhammayso tafatirka.

Nooc kasta^(Whichever) oo Microsoft Office ah oo aad isticmaalayso, waxaad ka heli kartaa isla arrin la mid ah xaashi kasta oo Excel ah . Sidoo kale, waxay ku dhacdaa Excel Online sidoo kale. Waxaa jira dhowr siyaabood oo arrintan wax looga qabanayo. Si kastaba ha ahaatee, waa inaad ogaataa in hab kasta uu kuu ogolaanayaa inaad kordhiso ballaca tiirka oo dhan hal mar. Haddii ay jiraan toban unug oo tiir ah oo aad isku daydo inaad kordhiso ballaca unugga koowaad, isla sidaas ayaa lagu dabaqi doonaa tiirka oo dhan - ma aha hal unug oo keliya.

Sida loo joojiyo ama loo qariyo qoraalka qulqulka^{(Text Overflow)} ee Excel

Si loo xaliyo dhibaatada qulqulka qoraalka ee Microsoft Excel , raac talooyinkan-

1. Gacanta u kordhi ballaca tiirka
2. Adeegso ikhtiyaarka ballaca tiirka AutoFit
3. Beddel ballaca caadiga ah ee unugga

Si aad u ogaato tillaabooyinka si faahfaahsan, sii wad akhriska.

1 ] Gacanta^{(] Manually)} u kordhi ballaca tiirka

Waxay u badan tahay inay tahay sida ugu fudud ee dhibaatadan looga takhalusi karo. Inkasta oo ay tahay hab-dugsi hore, si fiican ayey u shaqeysaa. Dhib malaha haddii ballaca unuggu uu noqdo 10mm ama 100mm, waxaad ku beddeli kartaa gacanta adigoon aqoon khabiir ah lahayn. Marka hore, fur xaashida, oo ku dul rog jiirkaaga xariiqda kala qaybisay laba tiir. Waa inaad aragto falaar laba-gees ah. Markaad taas hesho, guji oo qabo jiirkaaga oo u jiid dhinaca midigta.

2] Adeegso^(Use) ikhtiyaarka ballaca tiirka AutoFit^{(AutoFit Column Width)}

Waa doorasho waxtar leh oo kuu ogolaanaysa inaad si toos ah u dejiso ballaca tiirka. Waxay ogaanaysaa ballaca ugu badan ee unugga waxayna ku dabaqdaa tiirka oo dhan. Uma baahnid inaad isticmaasho habka jiirka jiidista. Faa'iidada khiyaamadani waa in aad hal mar kordhin karto ballaca tiirarka oo dhan. Si aad u bilowdo, dooro dhammaan tiirarka u baahan in la beddelo, oo guji Format menu, kaas oo ka muuqan doona tabka Guriga . ^{(Home )}Taas ka dib, dhagsii ikhtiyaarka balaadhka Column AutoFit^{(AutoFit Column Width)} .

Ballaca waa in isla markiiba la beddelaa.

3] Beddel^(Change) ballaca caadiga ah ee unugga/ tixda

Haddii aad hore u ogaatay inta ballac ee aad u baahan tahay si sax ah, waxaad bedeli kartaa ballaca caadiga ah ee tiirka. Taas awgeed, ka fur liiska Format ee Excel oo dooro ikhtiyaarka Width ee Default^{(Default Width )} . Hadda, waxaad u baahan tahay inaad doorato ballac.

Sida caadiga ah, waa in ay sitaa unugga millimitirka, kaas oo ah unugga caadiga ah ee Excel . Haddii ay dhacdo inaad hore u beddeshay, waxaad u baahan tahay inaad u dejiso ballaca si habboon.

Waxaan rajeynayaa in casharkan fudud uu kaa caawin doono inaad hagaajiso arrinta qulqulka qoraalka ee Microsoft Excel .

How to stop or hide Text Overflow in Excel

Text overflow can break the appearance of a spreadsheet as it might look awkward with overflowing texts coming out of a cell. If you have a spreadsheet with this problem, you can fix the text-overflow issue in Microsoft Excel so that it looks better and clean.

What is text overflow in Microsoft Excel

As the name defines, if the text is going outside of a cell, it is called text-overflow. The default width of a cell might not always be complying with the width of the whole text. The default width of an Excel cell is 8.43mm, which is minimal, and most of the people often get problems. At such a moment, the text gets hidden by the right-side cell, and it is not accessible for reading once you are done with the editing.

Whichever version of Microsoft Office you are using, you can get the same issue in every Excel spreadsheet. Also, it happens with Excel Online too. There are several ways to deal with this issue. However, you should know that every method lets you increase the width of the whole column at once. If there are ten cells in a column and you try to increase the width of the first cell, the same will be applied on the whole column – not just one cell.

How to stop or hide Text Overflow in Excel

To fix the text-overflow problem in Microsoft Excel, follow these suggestions-

1. Manually increase the width of a column
2. Use the AutoFit Column Width option
3. Change the default width of a cell

To know the steps in detail, keep reading.

1] Manually increase the width of a column

It is probably the easiest way to get rid of this problem. Although it is an old-school method, it works perfectly. No matter if the width of a cell should be 10mm or 100mm, you can change it manually without any expert knowledge. At first, open the spreadsheet, and hover your mouse over the line that divided two columns. You should see a two-way arrow. Once you get that, click and hold your mouse and drag towards the right side.

2] Use the AutoFit Column Width option

It is a handy option that lets you set the width of a column automatically. It detects the maximum width of a cell and applies that to the whole column. You do not need to use the mouse-dragging method. The advantage of this trick is that you can increase the width of all columns at once. To get started, select all the columns that need to be changed, and click the Format menu, which should be visible in the Home tab. After that, click on the AutoFit Column Width option.

The width should be changed immediately.

3] Change default width of cell/column

If you already know how much width you need precisely, you can change the default width of the column. For that, open the Format menu in Excel and select the Default Width option. Now, you need to choose a width.

By default, it should carry the millimeter unit, which is the default unit of Excel. In case you changed it earlier, you need to set the width accordingly.

I hope this simple tutorial will help you fix the text-overflow issue in Microsoft Excel.

Related posts

• Sida loo beddelo qoraalka qoraalka (TXT/CSV) faylka Excel

• U qaabee qoraalka sidii Superscript ama Subscript ahaan Word, Excel, PowerPoint

• Sida loogu daro Multiple Formating qoraalkaaga hal unug oo Excel ah

• Sida qoraalka loogu qaybiyo tiirarka ku jira Excel iyo Google Sheets

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

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

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo shaqada DISC gudaha Excel