2020, Google ayaa ku dartay mid ka mid ah sifooyinka ugu faa'iidada badan Google Sheets ; kartida lagu kala saaro ama lagu shaandheeyo midabka.

Tani waa wax ay isticmaalayaashu awoodeen inay ku sameeyaan Microsoft Excel in muddo ah. In laga heli karo Google Sheets waxay la macno tahay inay xitaa fududahay in xaashida Excel loo haajiro xaashida internetka.

Haddii aad la yaabban tahay sababta aad waligaa u rabto inaad u kala soocdo ama u shaandhayso midab, ka fiirso muuqaalka meesha aad dejisay qaabaynta xaalad ku salaysan. U kala soocida habkan waxay kuu ogolaanaysaa inaad samayso waxyaalaha ay ka midka yihiin kala soocida alaarmiga ama qiimaynta qayb ama mudnaanta halkii aad ku salayn lahayd lambarada gaarka ah.

Ku kala sooc Midabka Google Sheets

Aynu eegno xaashida xaashida oo leh liis ay ku jiraan darajooyin arday oo ka kooban noocyo kala duwan. Xaashidan faafinta ah waxaan ku habeynay qaabeynta xaalad ku saleysan si aan ugu meeleyno koodka midabka habboon ee kala duwanaansho kasta.

Xaashiyaha qaabkan loo qaabeeyey^{(formatted in this way)} , haddii aad u habayso tiirka B waxaad arki doontaa darajooyinka laga soocay A ilaa B, laakiin si cad uma arki doontid baloogyada darajooyinka ay ka kooban yihiin koox kasta oo xaraf ah.

Sida ugu fiican ee tan loo sameeyo waa kala soocida midabka. 

Si tan loo sameeyo:

1. Ka dooro xogta^(Data) liiska, dooro Filter views , ka dibna dooro Create new filter view . 

2. Si aad u kala soocdo liiska dhammaan buundooyinka "A" ee ugu sarreeya, waxaad u habayn kartaa Cagaaran^(Green) . Dooro astaanta shaandhada ee ku taal xagga sare ee tiirka, dooro Midab ku kala sooc^{(Sort by color)} , dooro Buuxi Midabka^{(Fill Color)} , ka dibna dooro midabka aad rabto inaad ku kala soocdo. Xaaladdan, dooro cagaar khafiif ah.

3. Midabka aad doorato ayaa la kooxeeyaa waxaana lagu kala saarayaa liiska ugu sarreeya.

Waxaa laga yaabaa inaad dareento inaadan ku kala saari karin dhammaan midabada, taasina waxay macno samaynaysaa, sababtoo ah midabadu ma laha amar ay ku kala soocaan.

Si kastaba ha ahaatee, haddii aad u kala soocdo tiirka tirooyin, midabada sidoo kale waxaa loo habayn doonaa iyadoo loo eegayo kala duwanaanshahooda tirada. Qodobka ugu muhiimsan ee midabaynta ee xaashida Google^{(Google Sheets)} waa in si dhakhso ah loo garto hal koox oo shay ah oo ku jira liis weyn si waafaqsan qaabaynta unugga (taas oo inta badan ku salaysan qaabaynta shuruudaha^{(conditional formatting)} ).

Ku Shaandhee Midabka Google-ka

Habka kale ee lagu kooxeeyo walxaha midabkooda ayaa ah isticmaalka sifada shaandhaynta. Xaashiyaha ^(Sheets)Google hadda wuxuu kuu ogolaanayaa inaad sifayso dhammaan midabada kale marka laga reebo midka aad xiisaynayso.

Liisaska waaweyn, tani aad bay faa'iido ugu leedahay ururinta dhammaan walxaha aad xiisaynayso iyadoo meesha laga saarayo dhammaan xogta kale.

Si aad tan u samayso, dooro summada filter-ka ee ku taal xagga sare ee tiirka, dooro Midab ahaan kala saar^{(Filter by color)} , dooro Buuxi Midabka^{(Fill Color)} , ka dibna dooro midabka aad rabto inaad ku shaandhayso. Xaaladdan oo kale cagaar khafiif ah.

Marka aad ku shaandhayso hal midab, waxaad arki doontaa dhammaan safafka halka tiirka aad shaandhaysay uu yahay midabka aad dooratay. Dhammaan safafka kale ee leh midabyo kale ayaa laga sifeynayaa aragtida.

Tani waa hab faa'iido leh oo diiradda lagu saaro kooxaha xogta, ka saara wax kasta oo kale oo laga yaabo inay caqabad ku noqdaan falanqayntaada.

Ku kala-soocidda ama shaandhaynta midab ee xaashida Google^{(Google Sheets)} - ka waa hab ka yar kala-soocidda tirooyinka, laakiin marmarka qaarkood xogta qaybaha ama kooxaha sidan oo kale ah ayaa ka qiimo badan.

Ku kala sooc midabka qoraalka ee xaashiyaha Google

Si la mid ah waxaad u kala sooci kartaa ama u shaandhayn kartaa midabada unugyada Google Sheets , waxaad samayn kartaa isla sidaas oo ku saleysan midabka qoraalka^{(text color)} . Tani waxay faa'iido u leedahay dhammaan sababaha kor ku xusan, laakiin waxaad abuurtay habayn shuruudaysan midabka qoraalka halkii aad ka ahaan lahayd midabka unugga.

Si lagu kala saaro midabka qoraalka:

1. Ka dooro xogta^(Data) liiska, dooro Filter views , ka dibna dooro Create new filter view . 

2. Si aad u habayso liiska dhammaan buundooyinka "A" ee ugu sarreeya, waxaad ku habayn kartaa qoraalka cagaaran. Dooro astaanta shaandhada ee ku taal xagga sare ee tiirka, dooro Midab ku kala sooc^{(Sort by color)} , dooro Midabka qoraalka^{(Text Color)} , ka dibna dooro midabka aad rabto inaad ku kala soocdo. Xaaladdan oo kale cagaar madow.

3. Midabka aad doorato ayaa la kooxeeyaa waxaana lagu kala saarayaa liiska ugu sarreeya.

Sida buuxintu u kala sooci doonto, midabka qoraalka aad dooratay ayaa kooxayn doona dhammaan walxaha midabka qoraalka ah ee liiska ugu sarreeya. Dhammaan alaabta hoos timaada kooxdaas ayaa ah kuwo aan la kala soocin.

Mar labaad, waa hab wanaagsan oo diiradda lagu saaro kooxo gaar ah ama qaybaha xogta. Laakiin haddii aad dhab ahaantii rabto inaad u kala soocdo siday u kala horreeyaan waxaad u baahan doontaa inaad u kala soocdo waxa ku jira unugga (lambarada) sida aad caadiyan u samayn lahayd.

Ku Shaandhee Midabka Qoraalka^{(Text Color)} ee Xaashiyaha Google

Waxa kale oo aad sifayn kartaa diiwaannadaas midabada kale ah, adigoo ka tagaya kaliya kooxda midabka aad rabto. Mar labaad^(Again) , tani waa mid faa'iido leh oo leh liisas aad u dheer oo aad rabto inaad ka saarto dhammaan qiyamka kale ee aan ku jirin xadka ama qaybta aad raadineyso. 

Si loogu shaandheeyo midabka qoraalka:

1. Ka dooro xogta^(Data) liiska, dooro Filter views , ka dibna dooro Create new filter view . 

2. Si aad u shaandhayso liiska si buundooyinka "A" kaliya loogu taxay xagga sare, waxaad ku shaandhayn kartaa qoraalka cagaaran. Dooro astaanta shaandhada ee ku taal xagga sare ee tiirka, ka dooro midab ahaan^{(Filter by color)} , dooro Midabka qoraalka^{(Text Color)} , ka dibna dooro midabka aad rabto inaad ku kala soocdo. Xaaladdan oo kale, dooro cagaar madow.

3. Midabka aad doorato ayaa la kooxaysan doonaa oo lagu qori doonaa xagga sare iyada oo aan midab kale oo qoraal ah la soo bandhigin.

Tani waxay si gaar ah faa'iido u leedahay liisaska aadka u dheer ee aad u baahan tahay si aad u shaandhayso "qeylada" (dhammaan xogta kale), si aad diiradda u saarto oo keliya xogta aad daryeesho.

Ku kala sooc ama ku Shaandhee Midabka ^(Color)Google - ka

Isticmaalka nooca ama shaqada shaandhaynta ee xaashiyaha Google^{(Google Sheets)} ee ku salaysan midabka ayaa kuu ogolaanaya inaad kooxaysiiso oo aad habayso xogta. Ma aha sida caadiga ah kala-soocidda ama shaandhaynta sababtoo ah kuma habayso xogta saf kasta, laakiin taa beddelkeeda iyada oo loo marayo blocks of saf. Waa hab fiican oo lagu kala saaro laguna habeeyo macluumaadka blocks.

Waxay leedahay adeegsigeeda haddii aad si habboon u isticmaasho mar kasta oo aad hayso xog shuruudaysan.

How to Sort or Filter by Color in Google Sheets

In 2020, Google added one of the most useful features to Google Sheets; the ability to sort or filter by color.

This is something users have been able to do in Microsoft Excel for some time. Having it available in Google Sheets means it’s even easier to migrate Excel sheets to an online spreadsheet.

If you’re wondering why you may ever want to sort or filter by color, consider the scenario where you’ve set up condition-based formatting. Sorting in this way lets you do things like sort alarms or rankings by category or priority rather than based on individual numbers.

Sort by Color in Google Sheets

Let’s look at a spreadsheet with a list of student grades that cover various ranges. In this spreadsheet we’ve configured condition-based formatting to assign the appropriate color code for each grade range.

With a sheet that’s formatted in this way, if you sort by column B you’ll see the grades sorted from A to B, but you won’t clearly see which blocks of grades make up each letter grade group.

The best way to do this is sorting by color. 

To do this:

1. Select Data from the menu, select Filter views, then select Create new filter view. 

2. To sort the list with all of the “A” grades at the top, you can sort by Green. Select the filter icon at the top of the column, select Sort by color, select Fill Color, and then select the color you want to sort by. In this case, choose light green.

3. The color you select will be grouped and sorted at the top of the list.

You might notice that you can’t sort by all colors, and this makes sense, because colors have no order to sort by.

However, if you sort the column by numbers, the colors will also be organized according to their numeric ranges. The main point of sorting by color in Google Sheets is to quickly identify a single group of items in a large list according to cell formatting (which is usually based on conditional formatting).

Filter by Color in Google Sheets

Another approach to grouping items by their color is using the filtering feature. Google Sheets now lets you filter out all other colors except the one you’re interested in.

In larger lists, this is very useful for grouping all of the items you’re interested in while removing the clutter of all of the other data.

To do this, select the filter icon at the top of the column, select Filter by color, select Fill Color, and then select the color you want to filter by. In this case light green.

Once you’ve filtered by one color, you’ll see all rows where the column you’ve filtered is the color you selected displayed. All the other rows with other colors will be filtered out of the view.

This is a useful way to focus on groups of data, removing everything else that may get in the way of your analysis.

Sorting or filtering by color in Google Sheets is a less granular approach than sorting by numbers alone, but sometimes visualizing data in categories or groups like this is more valuable.

Sort by Text Color in Google Sheets

In the same way you can sort or filter cell colors in Google Sheets, you can do the same based on text color. This is useful for all of the reasons above, but you’ve created conditional formatting for text color rather than cell color.

To sort by text color:

1. Select Data from the menu, select Filter views, then select Create new filter view. 

2. To sort the list with all of the “A” grades at the top, you can sort by Green text. Select the filter icon at the top of the column, select Sort by color, select Text Color, and then select the color you want to sort by. In this case dark green.

3. The color you select will be grouped and sorted at the top of the list.

Just like will the fill sort, the text color you selected will group all items with that text color at the top of the list. All items underneath that group remain unsorted.

Again, it’s a good way to focus on specific groups or categories of data. But if you actually want to sort in numerical order you’ll need to sort by cell content (numbers) as you normally would.

Filter by Text Color in Google Sheets

You can also filter out those records that are other colors, leaving only the group that’s the color you want. Again, this is useful with very long lists where you want to filter out all of the other values that aren’t in the range or category you’re looking for. 

To filter by text color:

1. Select Data from the menu, select Filter views, then select Create new filter view. 

2. To filter the list so only the “A” grades are listed at the top, you can filter by Green text. Select the filter icon at the top of the column, select Filter by color, select Text Color, and then select the color you want to sort by. In this case, choose dark green.

3. The color you select will be grouped and listed at the top without any other text colors displayed.

This is especially useful for very long lists where you need to filter out the “noise” (all the other data), so you can focus on only the data you care about.

Sort or Filter by Color in Google Sheets

Using the sort or filter function in Google Sheets based on color lets you group and organize data. It’s not like normally sorting or filtering because it doesn’t organize data by each row, but instead by blocks of rows. It’s a great way to categorize and organize information in blocks.

It has its uses if you use it properly whenever you have conditionally formatted data.

Related posts

• Sida loo Shaandheeyo Google Sheets

• Sida Loo Isticmaalo Liisaska Hoos U Dhaca Google Sheets

• 9 Qodob oo Qarsoon oo ku jira Khariidadaha Google waa inaad hubisaa

• Waa maxay Google App-ka & Sida Loo Isticmaalo

• Sida Loo Geliyo Saxiixa Google Docs

• Sida Loo Isticmaalo Joogsiyo Badan Khariidadaha Google-ka

• Waa maxay Qalabka Wariyaha Software-ka ee Chrome iyo sida loo joojiyo

• Sidee buu u shaqeeyaa Algorithm-ka YouTube?

• Sida Looga Sameeyo Shirqoolkii Kala firdhiyey ee Google-ka

• Sida Loo Sameeyo Fariimaha Codka Google Voice

• Sida Loo Isticmaalo Kalandarka Qoyska Google si aad qoyskaaga ugu ilaaliso wakhtiga

• Sida loo Beddelo Koontada Google-ka ee Default

• Sida loo galo Inbox Zero gudaha Gmail

• Google Search Bar Widget ma maqan yahay? Sida loo Soo Celiyo on Android

• 7-da ugu Fiican ee lagu daro Gmail

• Sida uu u shaqeeyo Google Drive Launcher Application

• Sida loo hagaajiyo Gmail-ka marka aanu helin iimaylada

• 20ka ugu Fiican ee lagu daro Gmailka iyo Kordhinta Isticmaalayaasha Awooda Iimaylka

• Waa maxay ilaalinta la xoojiyey ee Google Chrome ka iyo sida loo suurtogeliyo

• Sida loo Hagaajiyo Khaladaadka Shahaadada Amniga SSL ee Chrome