Excel waa mid ka mid ah codsiyada ku jira qolka xafiiska^(Office) ee si siman waxtar ugu leh goobta shaqada iyo xafiiska guriga ama guriga. Excel waxa uu awood u leeyahay in uu kaydiyo xog badan; Mararka qaarkood macluumaadkaasi wuxuu noqdaa mid aan la isticmaali karin sida isticmaalka xogta ku kaydsan xaashida shaqada ee Excel waxay noqotaa mid aad iyo aad u badan oo dhib ah waqti ka dib marka faylka uu kordho.

Inta badan loo isticmaalo goobaha ganacsiga, dadka isticmaala guryuhu inta badan ma oga in aad kooxayn karto oo aad dumin karto labada saf iyo tiirarka xaashida shaqada ee Excel si aad u qariso macluumaadka ilaa inta loo baahan yahay. Tani waxay si gaar ah faa'iido u leedahay markaad isticmaasho qaacidooyinka xaashida faafinta si aad u soo koobto macluumaadka oo aad xiisaynayso oo kaliya koobabyadaas inta badan.

Isku - ururinta Safafka^(Rows) iyo Tiirarka^(Columns) ee xaashida shaqada ee Excel^{(Excel Worksheet)}

Ka soo qaad in^(Suppose) aad haysato warqad shaqo oo Excel ah oo u eeg sawirka hoose. Ogow^(Notice) in ay jiraan tiro unugyo ah oo xog ku jira iyo in xog kasta lagu soo koobay unug gaar ah (B6, B13 , iyo B20 ).

Dhibaatada ku haysa waa in xogta ku jirta unugyada (B1 ilaa B5, B8 ilaa B12 , iyo B15 ilaa B19 ) aanay si joogto ah kuu anfacayn; kaliya waxaad danaysaa wadarta, celceliska, iyo qiimayaasha ugu badan ee xog kasta siday u kala horreeyaan.

Adigoo isticmaalaya kooxda^(Group) Excel , waxaad si gooni gooni ah u kooxaysan kartaan xogtan oo aad u dumin kartaa aragti la'aan. Markaad u baahato inaad aragto ama aad wax ka beddesho xogta, waxaad kordhin kartaa kooxaha oo aad la shaqayn kartaa mar labaad.

Tusaale ahaan, aynu wada ururino safafka 8 ilaa 12, aynu dumino, oo aynu ka tagno kaliya Celceliska^(Average) safka 13aad. Ku bilow adigoo dooranaya safafka 8 ilaa 12 jiirkaaga. Guji^(Click) bogga Xogta^(Data) ee ku taal Ribbon oo hel qayb ka mid ah Ribbon -ka ku calaamadsan Tilmaamaha^(Outline) . Guji badhanka ku calaamadsan Kooxda^(Group) oo ka dooro koox^(Group) ka menu-ka.

Isla markiiba waxaad ogaan doontaa isbeddel ku yimid xaashida shaqada ee Excel oo laga yaabo inaadan waligaa hore u arkin. Ku xiga safafka 8 ilaa 12, waxaa jira xariiq isku xiraya safan dhanka bidix waxaana jira calaamad laga jaray oo ku xigta safka 13. Tani waxay muujineysaa in unugyada 8 ilaa 12 ay ka mid yihiin koox hadda la ballaariyay.

Haddii aad gujiso calaamadda laga jaro ee ku xigta safka 13, safafka 8 illaa 12aad way dumi doonaan calaamadda laga jarayna waxay isu beddeshaa calaamad dheeri ah. Tani waxay sidoo kale muujinaysaa in safafka 8 ilaa 12 ay qayb ka yihiin koox iyo in kooxdu ay hadda burburtay.

Gujista calaamadda dheeriga ah waxay balaadhin doontaa kooxda mar kale. Sidoo kale, ogow in marka la burburiyo, safafka xaashida shaqadu ay toos uga socdaan safka 7 ilaa safka 13, waa calaamad hubaal ah in qaar ka mid ah safafka xaashida shaqada la ururiyay oo ay hadda burbureen.

Haddii aan sidaas oo kale ku sameyno safafka 1 ilaa 5 iyo 15 ilaa 19, waxaan aragnaa in marka safafkan la isku daro oo la burburiyo, xogta asalka ah ayaa qarsoon iyada oo aan aragno taas oo ka dhigaysa unugyada muhiimka ah si sahlan loo heli karo. U fiirso^(Notice) in saddexda calamadaha lagu daray ee ku yaala maroodiga gacanta bidix ee xaashida shaqada ay tilmaamayaan inay hadda jiraan saddex kooxood oo saf ah oo burburay.

Kooxaynta iyo burburinta unugyada Excel kuma koobna safafka; Waxaad sidoo kale koox kartaa oo dumin kartaa tiirarka. Xitaa waa suurtogal in la abuuro kooxo kooxo dhexdooda ah si ay si fiican u abaabulaan xogta ay ku adkaatay in ay ku shaqeeyaan xaashida shaqada ee Excel .

Group Rows and Columns in an Excel Worksheet

Excel is one оf the applications in the Office suite that is equally uѕeful in the workplаce and in a home or home office. Excel is capable of storing great amounts of information; sometimes thаt infоrmation becomes too unwieldy ѕuch that using the data stоred in an Exсel worksheet becomes more and more of a hassle over time as thе file grows.

Used more often in commercial settings, home users are often unaware that you can group and collapse both rows and columns in an Excel worksheet to hide information until it is needed. This is especially useful when you use formulas in a spreadsheet to summarize information and you are only interested in those summaries most of the time.

Grouping Rows and Columns in an Excel Worksheet

Suppose you have an Excel worksheet that looks like the one pictured below. Notice that there are a number of cells that contain data and that each set of data is summarized in a separate cell (B6, B13, and B20).

The trouble you are having is that the data in the cells (B1 to B5, B8 to B12, and B15 to B19) are not useful to you on a regular basis; you only care about the total, average, and maximum values for each set of data respectively.

Using Excel’s Group function, you can group these data together separately and collapse them out of view. When you need to view or edit the data, you can expand the groups and work with them again.

As an example, let’s group rows 8 through 12 together, collapse them, and leave only the Average in row 13 visible. Begin by selecting rows 8 through 12 with your mouse. Click on the Data tab on the Ribbon and locate a section of the Ribbon labeled Outline. Click on the button labeled Group and select Group from the menu.

You’ll immediately notice a change to the Excel worksheet that you may never have seen before. Next to rows 8 through 12, there is a line connecting these rows to the left and there is a minus sign next to row 13. This signifies that cells 8 through 12 are part of a group that is currently expanded.

If you click the minus sign next to row 13, rows 8 through 12 will collapse and the minus sign turns into a plus sign. This also signifies that rows 8 through 12 are part of a group and that the group is currently collapsed.

Clicking on the plus sign will expand the group again. Also, notice that when collapsed, the rows in the worksheet go right from row 7 to row 13, a sure sign that some of the rows in the worksheet have been grouped and are currently collapsed.

If we do the same for rows 1 through 5 and rows 15 through 19, we see that when these rows are grouped and collapsed, the original data is hidden from view making the important cells more easily found. Notice that the three plus signs in the left hand gutter of the worksheet indicate that there are currently three collapsed groups of rows.

Grouping and collapsing cells in Excel is not limited to rows; you can group and collapse columns as well. It is even possible to create groups within groups to better organize data that has become difficult with which to work in a bloated Excel worksheet.

Related posts

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Sida loo Furo Word iyo Excel si Badbaado ah

• Waa maxay VBA Array ee Excel iyo Sida loo Barnaamijyo Mid

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• Sida loo sameeyo shaxda Pie ee Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

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

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Goorta la Isticmaalayo Tusaha-Match Bedelkii VLOOKUP ee Excel

• Sida loo xarfo xarfaha Excel

• Sida Taariikh ahaan loogu kala saaro Excel

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Geli xaashida shaqada ee Excel Word Doc

• Sida Loo Sameeyo Liisaska Hoos-u-dhaca ee Isku Xirka Badan ee Excel