Sort muna Excel. Kushanda mu Excel. Excel mienzaniso

Microsoft Excel Software hunokosha kushanda nhamba uye pamatafura. Kunoitawo kuti nyore kuita Masvomhu yakaoma, swedera calculators nemachati. Kushanda tafura dzine mazita maonero, Microsoft Excel unokubvumira kusarudza zvinodiwa tsika uye wofunga mbiru. The Data anogona arongwe mu vachikwira kana nokuburuka kuti maererano netsika dziri mu masero. The chete bata zvinogona kuitwa pamwe chinyorwa zvinhu, zvingatemwa riri mukuzarurirwa earufabheti kana zvisizvo earufabheti. Sort muna Excel zvinodiwa nechokwadi chokuti mashoko zvaivapo maonero uye nyore kuverenga.

Kuunza kworudzii padzoro yenyu

Dzimwe nguva mamiriro ezvinhu akadaro panomuka kana uchifanira kugadzirisa humboo ari kuti yakasiyana munazvo. Muchiitiko chino, unogona kusika rako padzoro, iyo inodiwa kuti uwane basa.

Kuti vagadzire tsika kuti, unofanira kuenda Tab "Tools" uye zvadaro sarudza "Options." Pane menu "bar", apo akasiya kurutivi hwindo yaiva yaivapo mazita zvinoshandiswa kufambira. "Zvakarongwa New", sarudza kusarudza kuumba yenyu padzoro. Vose "List zvinhu" tsika zvakakodzera uye parameters anofanira kuisa mumunda.

Chiyamuro tsika vanoparadzaniswa kushandisa "Pindai" kiyi. Kupinda ose mashoko rwaunoda kuti, maererano iyo remangwana zvichabviswa arongwe pasi. Kana tsika ose wakaiswa, achizviendesa bhatani "Wedzerai". Kupinza Nyora kuti kare vataipa pamusoro pakombiyuta, unofanira kushandisa nzira "Import pakarongwa pamakamuri," akadaro mumwe muchitokisi kero. Asi zvinogona kuitwa chete kana aripo ndandanda rine zvinhu zviri muhurongwa, iyo inodiwa mamwe kufambira tsika. Panopera unofanira tinya "Import."

Zvino zviri nyore kuronga mashoko, kuti kunoshanda Excel akanga hwomutambarakede. Kuti aite izvi, enda kune "Data" Muterere uye wasarudza Tab "Sorting". Mu "Sort ne ..." chinofanira chaizvo parameters, achizviendesa runoenzanirana bhatani. On chidzitiro rinowanika hwindo "Sort Options", apo iwe kutaridzwa zvemarudzi hurongwa mashoko.

Pashure paizvozvo unofanira kusarudza kworudzii padzoro wako uye musimbise pakusarudza nokutsikirira OK.

Kuti chinetso muna Excel yave ichiitwa, unofanira kuisa cursor neimwe muchitokisi, uye tinya mabhatani chaienzanirana chorudzii vachikwira kana nokuburuka hurongwa. Vari iri Toolbar.

Ronga nezita uye muhoro

Kazhinji panguva emakambani pane mamiriro ezvinhu kana unofanira kugadzirisa humboo maererano okupedzisira mazita vashandi. Izvi zviri nyore kuti mashoko chokuita imwe mushandi, zvichava imwe yokufunga.

Kuti zvijeke, mashoko ari arongwe kwete chete nezita, asi zvichienderana uwandu muhoro. Muchiitiko chino, dzimwe zvemarudzi mabhatani kuita. Kana uchida kuti mashoko kworudzi urwu, Excel rinopa zvinotevera goho:

• Unofanira Activate murayiro "Data" uye zvadaro "Sorting".
• Pahwindo akazarura "Range Sorting" unofanira sarudza "Sort ne ..." uye tsanangurai imwe mbiru. Ipapo iwe unofanira kuita kuti Pointer kuti aida chinzvimbo: huchikwira kana nokudzika runyararo.

Nokuti chechipiri munda rinoitwa analogously kuti kufambira. The chirongwa kuchaita reumwe mazita vashandi chete vaya vane mari.

Kana mashoko ari guru kwazvo, unogona kusika yako mazita kuronga mashoko ako. Izvi zvichakubatsira kudzivisa zvikanganiso kana tichishanda acho, kunze zvichava nyore kubata.

Sort alphabetically

Kugadzirisa mashoko ari earufabheti, unofanira kuenda "Data" Muterere. Pre-vanofanira kusarudza mbiru uko mashandiro ari kuiswa. The Data vachava arongwe nokutsikirira icon "A kuti Z", kana vakutarisire. Pashure paizvozvo, chidzitiro anoratidza hwindo rine mubvunzo: "? Ndinofanira kuwedzera kuwanda Data kwaita" Zvakakodzera kugamuchira uye muchisviniro "Save". Vose Gwaro havazotadzi zvarinoreva, uye navamwe date mbiru dzinoenderana kuchinja.

Sort muna Excel anogona kuitwa neimwe nzira. Pakusarudza zvikuru muchitokisi, unofanira tinya icon. Asi ichi kana mubvunzo kuti kuwedzera kuwanda hariwaniki, izvozvo anowedzera kwaita.

Multi-chechetere Sorting

Kana kushanda magwaro, uye kungada munhu multi-pamwero kufambira muna Excel. Kushandisa chikamu ichi, unofanira kusarudza kamuri ari pamazita uye tinya kusarudza "Sort" pasi payo. Imwe yakati ane kuva, uye zvinokwanisika kusarudza mumwe, zvakadai deti. Kuti aite izvi, tinya "Wedzerai rukoko". Nokuti zvivanakire kukwanisa kuita kwevari pamazita arongwe muzvikamu.

Kana zvakakodzera, kuti siyana vari kutamira kukwira kana pasi, iyo anochinja kuisa. Kuti aite izvi, sarudza padanho uye tinya museve kuvake. Uyewo, nhanho nyore kutevedzerwa kana dzadzimwa.

Zvokuimba Microsoft Excel

Zvokuimba Excel ndivo mashoko kutanga "akaenzana" chiratidzo, rinoumbwa kusanganiswa tsika, sero kero, mazita kana mabasa. Vose vari chokuita zviratidzo svomhu kwacho: chokuwanziridza, nokupesana, kubvisa, kana Exponentiation.

Mashandiro ari nzira yakakamurwa maererano pokutanga:

• The okuti mune mumabhuraketi uye Exponentiation.
• Division uye chokuwanziridza.
• Kubvisa uye kuwedzera.

Sero anoratidza chete mugumisiro, asi nzira pachayo iri mune nzira kubhawa. Kana kushandura kuguma mugumisiro dzinoshandurwa kwaita.

How kuchinja iri nzira?

Kana pane vanoda kuchinja nzira, unofanira tinya iri nzira nomuzariro kana achizviendesa bhatani F2. Mushure zvose kuchinja kusamuendesa «Kupinda» kana chiyamuro Icon Napamusara. Kuchinja kungashandiswawo zvakananga muchitokisi. Kuti izvi zvidaro, nzvimbo vakasarudzwa zvinofanira tinya kaviri.

Cell magwaro uye kwebasa Masvomhu

Kudzidza Excel, ari mienzaniso, unogona kazhinji kuona Links. Kushandisa Links anobvumira kushandisa umboo ari kutaura kuti vari munzvimbo dzakasiyana-siyana pamusoro jira. Possible kushandisa sero magwaro, riri dzimwe Workbook kana mafomu.

Tapinda sero wayo payakavakirwa anogona kuchinjwa kana zvakakopwa kune imwe nzvimbo. Muchitokisi ichi, yaiva nzira anova akasununguka. Kuchinja chete hama Links uye mhedziso anoramba achitsungirira.

Chokuendesa yemaitiro, uise cursor panguva pakona sero kuratidza museve kaviri madziro. Batisisa pasi negonzo bhatani, unogona dzikwekweredzere kuna achida nzvimbo.