Google iyo alaabteeda ayaa maamula warshadaha software-ka adduunka oo dhan, iyadoo malaayiin isticmaalayaal ah ay ka kala yimaadeen dalal iyo qaarado kala duwan. Mid ka mid ah apps-ka caanka ah ee ay isticmaalaan malaayiin waa Google Sheets . Google Sheets waa app si wax ku ool ah kaaga caawinaya in aad habayso xogta qaab jadwal ah oo kuu ogolaanaya inaad samayso hawlo kala duwan oo xogta ah. Ku dhawaad ​​​​dhammaan ganacsiyada waxay isticmaalaan ^(Almost)Maareynta^(Management) xogta iyo nidaamyada xaashida xaashida ee adduunka. Xataa dugsiyada iyo machadyada waxbarashadu waxay isticmaalaan xaashiyaha xaashida si ay u ilaashadaan diiwaanadooda xogta. Marka ay timaado xaashida faafinta, Microsoft Excel iyo Google Sheetshogaaminta ganacsiga. Dad badan ayaa jecel inay isticmaalaan maadaama ay xor u tahay inay isticmaalaan, waxayna ku kaydin kartaa xaashiyahaaga internetka Google Drive kaaga . Tani waxay ka dhigaysaa in laga heli karo kumbiyuutar kasta ama Laptop kasta oo ku xidhan World Wide Web iyada oo loo marayo. Internetka^(Internet) . Waxyaabo kale oo weyn oo ku saabsan Google Sheets waa inaad ka isticmaali karto daaqada browserka ee kumbiyuutarkaaga^(Computer) gaarka ah ama Laptop -kaaga .

Markaad xogtaada u habayso qaab jadwal ah, waxa laga yaabaa inaad la kulanto dhawr dhibaato. Mid ka mid ah arrimaha caanka ah ee noocaas ah ayaa ah in unuggu uu aad ugu yar yahay xogta, ama xogtu aysan si fiican ugu habboonayn unugga, oo waxay u socotaa si siman markaad wax qorayso. Xitaa haddii ay gaadho xadka cabbirka unugga, way socon doontaa, iyada oo daboolaysa unugyada u dhow. Taasi waa, qoraalkaagu wuxuu ka soo bilaaban doonaa dhinaca bidix ee qolkaaga wuxuuna ku qulquli doonaa unugyada maran ee dhow^{( your text would start from the left side of your cell and would overflow to the nearby blank cells)} . Taas waxaad ka fahmi kartaa snip-ka hoose.

Dadka isticmaala Google Sheets si ay u bixiyaan sharraxaad faahfaahsan oo qaab qoraal ah ayaa runtii la kulmi lahaa arrintan. Haddii aad ka mid tahay iyaga, markaas waxaan dhihi lahaa inaad ku soo degtay meeshii ugu fiicnayd. Aan ku hago habab aad taas kaga badbaadi karto.

Sida looga fogaado qulqulka qoraalka Google Sheets?^{(How to avoid text-overflow in Google Sheets?)}

Si looga fogaado arrintan, macluumaadkaagu wuxuu u baahan yahay inuu si fiican u galo ballaca unugga. Haddii ay ka badato ballaca, waa in ay si toos ah uga bilaabataa wax ku qorida xariiqda xigta, sidii adigoo taabtay furaha Gelida^(Enter) . Laakiin sida loo gaaro tan? jid ma jirtaa? Haa, way jirtaa. Waad duubi kartaa qoraalkaaga si aad uga fogaato arrimahan oo kale. Ma haysaa wax fikrad ah oo ku saabsan sida loogu duubo qoraalka Google Sheets ? Taasi waa sababta aan halkan u joogno. Kaalay^(Come) , aynu si qoto dheer u baadhno hababka aad qoraalkaaga ugu duubi karto Google Sheets .

Sida qoraalka loogu duubo xaashida Google-ka?

1. Waxaad kaliya furi kartaa browserka aad jeceshahay oo aad Google Sheets ka aadi kartaa PC-gaaga ama Laptop-kaaga. Sidoo kale, waxaad taas ku samayn kartaa adigoo ku dhejinaya docs.google.com/spreadsheets .

2. Markaa waxaad furi kartaa xaashi cusub^{(New Spreadsheet)} oo aad bilaabi kartaa gelida macluumaadkaaga.

3. Kadib markaad qoraalka ku qorto unug^{(text on a cell)} , dooro unugga aad ku qortay.

4. Kadib markaad xulato unugga, guji Format menu-ka ka soo baxa guddida sare ee daaqadaada Google Sheets (ka hooseeya magaca xaashiyahaaga).

5. Dhig curcurkaaga mouse-ka xulashada ciwaankeedu yahay "Qoraalka Duubista"^{(“Text Wrapping”)} . Waxaad qiyaasi kartaa in ikhtiyaarka qulqulka badan lagu^{(Overflow )} doortay si caadi ah. Riix badhanka "Duub"^{(“Wrap” )} si aad qoraalkaaga ugu duubto xaashida Google^{(Google Sheets)} -ka .

 

6. Isla marka aad doorato ikhtiyaarka " Duub^(Wrap) ", waxaad arki doontaa wax soo saarka sida shaashadda hoose:

Duubista qoraalka ^{(Wrapping Text from the )}Google Sheets  Toolbar

Waxa kale oo aad heli kartaa marin-gaab aad ku duuduubto qoraalkaaga ku taxan daaqada Google Sheets 's toolbar. Waxaad gujin kartaa calaamadda duubista qoraalka^{(Text wrapping )} ee liiska oo guji badhanka Duubka^{(Wrap )} ee xulashooyinka.

Ku Duubista Qoraalka Gacanta ee Google Sheets^{(Wrapping Text Manually in Google Sheets)}

1. Waxa kale oo aad geli kartaa jebinta laynka gudaha unugyada si aad gacanta ugu duubto unugyadaada hadba baahidaada. Si taas loo sameeyo,

2. Dooro unugga ka kooban qoraalka si loo habeeyo (duubo)^{(Select the cell that contains the text to be formatted (wrapped))} . Laba-guji unuggaas ama taabo F2. Tani waxay ku geyn doontaa habka wax ka beddelka, halkaas oo aad ka beddeli karto waxa ku jira unugga. Dhig curcurkaaga meesha aad rabto inaad xariiqda ka jebiso. Riix furaha Gelida^{(Enter )} markaad hayso furaha ALT (ie, Riix^(Press) combo furaha – ALT + Enter ).

3. Taas, waxaad ku dari kartaa nasasho meel kasta oo aad rabto. Tani waxay awood kuu siinaysaa inaad ku duubto qoraalkaaga qaab kasta oo aad u baahan tahay.

Sidoo kale akhri: ^{(Also Read:)} Sida Sawirka ama Sawirka loogu rogo Word^{(How to Rotate a Picture or Image in Word)}

Ku duub qoraalka App Sheets Google^{(Wrap Text In Google Sheets App)}

Haddii aad ku isticmaasho codsiga Google Sheets ee casriga ah ee ^{(Google Sheets)}Android ama iOS, waxa laga yaabaa inaad ku wareerto interface-ka, waxaana laga yaabaa inaadan garanayn meesha aad ka heli karto ikhtiyaarka duubista qoraalka. Ha werwerin, raac tillaabooyinka hoose si aad qoraalka ugu duubto Google Sheets taleefankaaga:

1. Ka fur arjiga Google Sheets ee qalabkaaga casriga ah ee ^{(Google Sheets )}Android ama iOS.

2. Fur xaashi cusub ama warqad hore oo aad rabto inaad ku duubto qoraalka.

3. Si tartiib ah ugu taabo unugga^{(cell whose text)} aad rabto in aad qoraalkiisa ku duubto. Tani waxay dooranaysaa unuggaas gaarka ah.

4. Hadda ku dhufo ikhtiyaarka qaabka^{(Format )} shaashadda codsiga (oo lagu muujiyey shaashadda).

5. Waxaad ka heli doontaa xulashooyinka qaabaynta ee ku taxan laba qaybood - Qoraal^(Text) iyo Unug^(Cell) . U gudub Unugga^{(Cell )}

6. Waa inaad hoos u yara rogtaa si aad u heshid Toggle^{(Wrap )} Duubista. Hubi inaad awood u yeelatid,^{(Make sure to enable it,)} oo qoraalkaagu wuxuu ku duubi doonaa codsiga Google Sheets.^{(text would wrap in the Google Sheets application.)}

FIIRO GAAR AH:^{(NOTE: )} Haddii aad u baahan tahay inaad ku duubto dhammaan nuxurka xaashidaada, taas oo ah, dhammaan unugyada xaashida, waxaad isticmaali kartaa astaanta " Dooro dhammaan ". ^{(Select all)}Si aad tan u samayso, dhagsii sanduuqa madhan ee u dhexeeya madaxyada A iyo 1 (oo lagu iftiimiyay sawirka hoose). Inaad gujiso sanduuqan waxay dooranaysaa xaashida faafinta oo dhan. Haddii kale, waxaad isticmaali kartaa furaha combo Ctrl + A. Ka dib raac tillaabooyinka kore, oo waxay dumin doontaa dhammaan qoraalka ku jira xaashidaada.

Wax badan ka ogow ikhtiyaarrada aad qoraalkaaga ugu duubi lahayd xaashida Google-ka^{(Know more about the options to wrap your text in Google Sheets)}

Qulqulaya: ^{(Overflow: )} Qoraalkaagu waxa uu ku qulquli doonaa unugga maran ee xiga haddii uu dhaafo ballaca unuggaga hadda jira.

Dubo:^{(Wrap: )} Qoraalkaagu waxa lagu duuduubi doonaa xariiqyo dheeraad ah marka uu dhaafo ballaca unugga. Tani waxay si toos ah u beddeli doontaa dhererka safka iyadoo la eegayo booska looga baahan yahay qoraalka.

Clip: Kaliya qoraalka ku jira dhererka unugga iyo ballaca xadka ayaa la soo bandhigay. Qoraalkaagu wali wuu ku jiri lahaa qolka, laakiin qayb keliya oo ka mid ah oo ku dhacda xudduudaha unugga ayaa la muujiyay.

lagu taliyay:^{(Recommended:)}

• Sida loogu daro Kaarka Dadkaaga Google Search^{(How to Add Your People Card on Google Search)}
• Ku dir sawirka iimaylka ama fariin qoraaleed Android^{(Send Picture via Email or Text Message on Android)}

Waxaan rajeynayaa inaad hadda si dhakhso leh ugu duubi karto qoraalkaaga Google Sheets. ^{(quickly wrap your text in Google Sheets.)}Haddii aad wax su'aalo ah qabtid, isticmaal qaybta faallooyinka. Waxaan jeclaan lahaa inaan akhriyo fikradahaaga. Markaa iyagana faallooyinkaga ku rid.

How to Quickly Wrap Text in Google Sheets?

Google аnd its products rule the softwаre industry worldwide, with millions of users from variоus countrіes and continents. Оne of the notorіоus apps that are used by millions іs Google Sheets. Google Sheets is an app that effectively helps you organize data in the form of tables and lets you perform a variety of operations on the data. Almost all businesses use database Management and spreadsheet systems in the world. Even schools and educational institutions use spreadsheets to maintain their database records. When it comes to spreadsheets, Microsoft Excel and Google Sheets lead the enterprise. Many people tend to use at as it is free to use, and it can store your spreadsheets online on your Google Drive. This makes it accessible from any computer or laptop that is connected to the World Wide Web via. Internet. Another great thing about Google Sheets is that you can use it from your browser window on your Personal Computer or Laptop.

When you organize your data in the form of tables, you might encounter a few problems. One such common issue is that the cell is too small for the data, or the data would not perfectly fit into the cell, and it just moves on horizontally as you type. Even if it reaches the cell size limit, it will go on, covering the nearby cells. That is, your text would start from the left side of your cell and would overflow to the nearby blank cells. You can infer that from the below snip.

People who use Google Sheets to provide detailed descriptions in the form of text would have indeed encountered this issue. If you are one of them, then I would say that you have landed on the perfect spot. Let me guide you with some ways to avoid this.

How to avoid text-overflow in Google Sheets?

To avoid this issue, your content needs to fit into the cell’s width perfectly. If it exceeds the width, it must automatically start typing from the next line, as if you have pressed the Enter key. But how to achieve this? Is there any way? Yes, there is. You can wrap your text to avoid such issues. Do you have any idea about how to wrap text in Google Sheets? That’s precisely why we are here. Come on, let’s make a deep peep into the methods by which you can wrap your text in Google Sheets.

How to Wrap Text In Google Sheets?

1. You can just open up your favorite browser and go to Google Sheets from your PC or laptop. Also, you can do that by typing docs.google.com/spreadsheets.

2. Then you can open a New Spreadsheet and start inputting your content.

3. After typing your text on a cell, select the cell on which you have typed.

4. After selecting the cell, click on the Format menu from the panel at the top of your Google Sheets window (below the name of your spreadsheet).

5. Place your mouse cursor over the option titled “Text Wrapping”. You can infer that the Overflow option is selected by default. Make a click on the “Wrap” option to wrap your text in Google Sheets.

 

6. As soon as you select the “Wrap” option, you will see the output such as in the below screenshot:

Wrapping Text from the Google Sheets Toolbar

You can also find the shortcut to wrap your text listed in the Google Sheets window’s toolbar. You can click on the Text wrapping icon from the menu and click on the Wrap button from the options.

Wrapping Text Manually in Google Sheets

1. You can also insert line breaks within cells to wrap your cells manually according to your needs. To do that,

2. Select the cell that contains the text to be formatted (wrapped). Make a double-click on that cell or press the F2.  This would take you to the edit mode, where you can edit the contents of the cell. Place your cursor where you want to break the line. Press the Enter key while holding the ALT key (i.e., Press the key combo – ALT + Enter).

3. Through this, you can add breaks wherever you want. This enables you to wrap your text in whatever format you require.

Also Read: How to Rotate a Picture or Image in Word

Wrap Text In Google Sheets App

If you use Google Sheets application on your Android or iOS smartphone, you may be confused with the interface, and you might not know where to find the option for wrapping text. Don’t worry, follow the below steps to wrap text in Google Sheets on your phone:

1. Open the Google Sheets application on your Android or iOS smartphone device.

2. Open a new or an existing spreadsheet in which you want to wrap the text.

3. Make a gentle tap on the cell whose text you wish to wrap. This would select that particular cell.

4. Now tap on the Format option on the application screen (shown in the screenshot).

5. You will find the formatting options listed under two sections – Text and Cell. Navigate to the Cell

6. You would have to scroll down a bit to locate the Wrap Toggle. Make sure to enable it, and your text would wrap in the Google Sheets application.

NOTE: If you need to wrap the entire content of your spreadsheet, that is, all the cells in the spreadsheet, you can use the “Select all” feature. To do this, click on the empty box between the headers A and 1 (highlighted in the screenshot below). Making a click on this box would select the entire spreadsheet.  Else, you can just make use of the key combo Ctrl + A. Then follow the above steps, and it would warp all the text in your spreadsheet.

Know more about the options to wrap your text in Google Sheets

Overflow: Your text will overflow to the next blank cell if it exceeds your current cell’s width.

Wrap: Your text would be wrapped in additional lines when it exceeds the cell’s width. This would automatically alter the row height with regard to the space required for the text.

Clip: Only the text within the cell’s height and width limits are displayed. Your text would still be contained in the cell, but only a part of it that falls under the cell’s boundaries are shown.

Recommended:

• How to Add Your People Card on Google Search
• Send Picture via Email or Text Message on Android

I hope that you can now quickly wrap your text in Google Sheets. If you have any questions, make use of the comments section. I would love to read your suggestions. So drop them too in your comments.

Related posts

• Sida loo beddelo Kiiska qoraalka ee Word iyo Google Sheets

• Sida loo horumariyo qoraalka Google Docs

• Sida loo sameeyo garaaf xariiq qaloocan gudaha Excel iyo Google Sheets

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Sideen ku helaa Google Cloud? (2022)

• Isku-dar dhowr Google Drive iyo Kootooyinka Sawirrada Google

• Sida loo hubiyo aqoonsiga emailka ee ku xidhan Koontadaada Facebook

• 4 siyaabood oo loo rogo sawirka Google Docs

• Sida loo hubiyo socodka khariidadaha Google

• Si deg deg ah u samee Mareeg Shakhsiyeed adoo isticmaalaya Google-ka

• Samee qaab-dhismeedka xaashiyaha Google-ka adigoon Google-ka ku biirin goobta shaqada

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Wax-soo-saarka ugu fiican ee Google Sheets si loo horumariyo wax soo saarka

• Sida Loo Soo Saaro Xiriirada Kooxda WhatsApp (2022)

• Sida loogu xidho Google Sheets iyo Excel

• Isku-dubarid Xisaabaadka Google Drive-ka ee Badan Windows 10

• 3 siyaabood oo loo wadaago gelitaanka Wi-Fi iyada oo aan la muujin erayga sirta ah

• Sida loo geliyo WordArt xaashida Google-ka iyadoo la isticmaalayo Google Drawings

• Hagaaji Google Chrome-ka Aan Keydin Erayada sirta ah