How kubvisa varara mitsetse mu "Eksele": nyore mashomanana unyanzvi

All vanoshandisa vanoshanda pamwe Spreadsheets muna Excel muhofisi mupepeti kakawanda zvakafanira kubvisa chinhu masero kuti vari mumitsara, saka havaiti nokuvhiringidza workspace yenyu. Ndiani ichakurukurwa, sapamazuva "Excel" tafura kubvisa chinhu tambo. Chinetso vachava kubatsira mumamiriro ezvinhu. Somuenzaniso, kana zvakafanana chiito pamwe mbiru kana masero nomumwe.

How kubvisa varara mitsetse mu "Eksele" nyore nzira mbiri?

Chokutanga, ngationei kuti panguva kwacho vanofanira kunyatsongwarira. Chokwadi kuti masero ingasanganisira Isimba rakadini rinogona kubudiswa payakavakirwa (Hauoneki chinyorwa). Uye Masvomhu pachavo rinogona kureva mutsetse umo mashoko vasiri kuwanikwa, asi vari chinangwa kuzozivisa mune ramangwana. masero dzakadaro mashoko chepurogiramu havasi vaiona chinhu.

Asi tarisai kuti "Eksele" bvisa varara mitsetse, kana vari zvechokwadi kudaro. Nzira iri nyore kuonekwa hwandaiva kusarudzwa pamwe negonzo apo akabata akasiya bhatani. Wakaitwa mudenga kana downwards pamusoro pamunda nendima kuruboshwe. Zvadaro, muchishandisa kurudyi-watinya, iwe anokumbira akapoteredza Muterere, sarudza apo dzadzimwa pemitsara. Asi nzira iyi chete kushanda kana masero vanosarudzirwa pamusara.

How kubvisa varara mitsetse mu "Eksele" kana minda isina rakatumbuka pamwe mashoko? Panyaya iyi, dambudziko riri kugadziriswa neimwe nzira. Kuti aite izvi, bata pasi Ctrl kiyi, uye ipapo vanorichengeta, zvinosimbisa mutsara mumwe kuti dzadzimwa. Pashure paizvozvo, sarudza yakakodzera kuvhiyiwa zvakarurama-watinya Muterere. Cherechedza kuti kana ukashandisa Del kiyi, vachaitwa chete zviri kurapwa, pane kubviswa mitsetse yose. Mune dzimwe nyaya, nokuti nyore nyaya, unogona kurishandisa.

Sezvo mu "Eksele" zvinomuomera kuikanganwa varara mitsetse achibatsirwa worudzii?

Pane nzira dzakawanda kwazvo kwacho. Imwe mhinduro yomubvunzo wokuti sei kubvisa varara mitsetse mu "Eksele" angava kushandiswa kufambira maturusi.

Kuti vaite izvi, mushure kusarudza yose tafura (Ctrl + A) ari mashoko chikamu, kusarudza worudzii Muterere, uye firita. Pano akashandisa murayiro arayira kubvira shoma kusvikira kunonyanyisa (varara mitsetse zvichava yakaderera). Pashure paizvozvo, vanogona kubviswa. Kana sezvakarayirwa pakuvaka date zvinokosha, unofanira kutanga pinza zvibereko mbiru kushandisa kuramba vaverengwa. Pashure kubviswa mechidziro zvakare zvibereko sequencing pakati vakaverengwa mbiru.

Deleting mechidziro uchishandisa firita

Kugadzirisa dambudziko sei kubvisa varara mitsetse mu "Eksele", uye iwe unogonawo nokungoti firita. It zvinoiswa ndeyokuwana wechikamu kana boka mbiru rose tafura. Uyezve, kushandisa murayiro "Filter" iri kufambira chikamu.

Zvino chete achizviendesa Sefa pacharo, kuratidza chete zvisina masero uye kuvabvisa. Asi pane hove. Kubviswa kwakadaro haigoni kushandisirwa kupfuura imwe mbiru, kana mumwe mutsara mumwechete Sero rine mashoko.

Voga hwemapoka muchitokisi

Pakupedzisira, funga mumwe nzira nokudenga. Iye anopedza dambudziko sei kuti "Excel" kubvisa varara mitsetse ari siyana uye kuti imwe nhamba kana kukosha.

Muchiitiko chino, unofanira kushandisa fora chikamu chikuru Panel ane kusarudzwa bhatani "Wana uye zvinosimbisa". mutsetse boka voga Sero anosarudzwa kubva donhwe-pasi Muterere. Uye mashoko mubhokisi riri kusashanda munhu anotaura kuti chinhu chimwe. Pashure paizvozvo, vari chikamu Operations pamwe masero vakasarudza Kudzima bhatani.

panzvimbo imwe epilogue

Ndizvo zvose nzira nyore naro unogona kuita achibvisa chinhu mitsetse chete kuchitsauko the clicks. Zvakare, zvinofanira kurangarirwa kuti makavanda ndima inogona vamwe mumasero. A masero varara pachavo vanogona kubatsirwa pamusoro nezvavo mune zvokuimba. Kana zvibereko zvavo nokubviswa, ipapo nzira hakushandi, uye chirongwa kuchaita vaunze chikanganiso dzemaitirwe kuvapo Links vasiri aripo kana kururama mashoko. Saka, mune zvinhu zvakadaro vanofanira kungwarira chaizvo kwete kuti vavhiringe kuvimbika kwemasvomhu kana mamwe mashandiro. Zvikasadaro, zvose zviri nyore. Zvichienderana zvakaguma inofanira kuwanikwa, zvinokwanisika kushandisa rimwe kana rimwe unyanzvi.