Mukati
Mukushanda neExcel magwaro, vashandisi vanogara vasingadi kuisa maseru chete, asiwo kuadzima. Iyo nzira pachayo iri nyore, asi kune dzimwe nzira dzekushandisa iyi nzira inogona kukurumidzira uye kurerutsa. Muchikamu chino, tichaongorora zvakadzama nzira dzese dzekubvisa maseru kubva mugwaro.
Maitiro ekudzima maseru
Izvo zvinotariswa zvinhu zvetafura zvinogona kuva e2 marudzi: ayo ane ruzivo uye asina chinhu. Uine izvi mupfungwa, maitiro ekuzvidzima achasiyana, sezvo chirongwa pachacho chinopa sarudzo ye automating maitiro ekusarudza uye kuwedzera kudzima zvisingakoshi maseru.
Inofanirawo kutaurwa pano kuti mukubvisa chimwe kana zvimwe zvinhu zvetafura, ruzivo rwuri mukati mavo runogona kuchinja chimiro chayo, sezvo semugumisiro wematanho akatorwa, zvimwe zvikamu zvetafura zvinogona kubviswa. Panyaya iyi, usati wadzima masero asina kufanira, zvinodikanwa kufunga nezvemhedzisiro yakaipa uye, kuitira kuchengetedza, ita kopi yekuchengetedza yegwaro iri.
Zvinokosha! Mukuita kwekudzima maseru kana akati wandei, uye kwete mitsara yese nemakoramu, ruzivo rwuri mukati meExcel tafura inochinjika. Nokudaro, kushandiswa kwemaitiro ari mubvunzo kunofanira kunyatsotariswa.
Kutanga, iwe unofanirwa kufunga nezve kuitwa kwemaitiro ari mubvunzo kuburikidza nemenu yemukati. Iyi nzira ndeimwe yeakajairika. Inogona kushandiswa kune akazadzwa maseru uye kune isina chinhu tafura zvinhu.
- Izvo zvinodikanwa kusarudza 1 sero kana akati wandei zvinhu kuti zvibviswe. Kudzvanya pane zvakasarudzwa nebhatani rekurudyi rembeva. Tevere, iwe unofanirwa kuvhura iyo mamiriro menyu. Mariri, unofanira kusarudza "Delete ..." checkbox.
1 - Iwindo rine 4 mabasa richaratidzwa pane monitor. Sezvo isu tichida kubvisa maseru zvakananga, uye kwete mitsara yese kana makoramu, ipapo 1 ye2 zviito zvinosarudzwa - kubvisa zvinhu zvine offset kuruboshwe kana nekugadzirisa kumusoro. Sarudzo yechiito inofanira kunge yakavakirwa pamabasa chaiwo anotarisana nemushandisi. Zvadaro, kana imwe sarudzo yasarudzwa, chiito chacho chinosimbiswa nekudhinda "OK" kiyi.
2 - Sezvakarongwa, zvese zvakamisikidzwa zvinobviswa mugwaro. Yechipiri sarudzo (shift up) yakasarudzwa, nekuti boka remaseru riri pasi penzvimbo yakamaka rakasimudzwa nemitsara yakawanda seyaive pamukaha wakasarudzwa.
3 - Kana ukasarudza yekutanga sarudzo (chinja kuruboshwe), sero rega rega riri kurudyi kwevakadzimwa richaendeswa kuruboshwe. Iyi sarudzo yaizove yakakwana mumamiriro edu ezvinhu, sezvo pakanga paine zvinhu zvisina chinhu kurudyi rweiyo yakatarwa. Tichifunga nezveizvi, kunze zvinoita sekuti ruzivo rwenguva yakacherechedzwa rwakangocheneswa pachiri kuchengetedza kuvimbika kwechimiro chegwaro. Kunyangwe, muchokwadi, mhedzisiro yakafanana inowanikwa zvakananga nekuda kwekuti zvinhu zvetafura zvakatsiva yekutanga hazvina data mazviri.
4
Nzira 2: Ribhoni Zvishandiso
Iwe unogona zvakare kudzima maseru mumatafura eExcel uchishandisa maturusi akapihwa paribhoni.
- Pakutanga, iwe unofanirwa kumaka neimwe nzira chinhu chaunoda kudzima. Ipapo iwe unofanirwa kushandura kune iyo huru tebhu uye tinya "Delete" (iri mu "Masero" menyu).
5 - Zvino iwe unogona kuona kuti sero rakatariswa rabviswa patafura, uye zvinhu zviri pazasi payo zvasimuka. Mukuwedzera, inofanira kusimbiswa kuti nzira iyi haizokubvumiri kuti uone nzira iyo zvinhu zvichabviswa mushure mekubviswa pachako.
6
Kana zvave kudikanwa kubvisa boka rakachinjika remasero uchishandisa nzira iyi, zvakakosha kucherechedza zvinotevera zvinokurudzira:
- Rudzi rwemasero akachinjika anosarudzwa. Dzvanya "Delete" pane "Home" tab.
7 - Sezvakaitika kare, zvinhu zvakatsanangurwa zvinobviswa nekukwira kumusoro.
8
Kana boka rakamira remasero rabviswa, shanduko inoitika kune rimwe divi:
- Boka remaelementi akatwasuka rinoratidzwa. Dzvanya pa "Delete" pane ribhoni.
9 - Iwe unogona kuona kuti pakupera kwemaitiro aya, zvinhu zvakamisikidzwa zvinodzimwa nekuchinja kuruboshwe.
10
Iye zvino izvo zvakakosha mashandiro akafukidzwa, zvinogoneka kushandisa nzira inoshanduka yekubvisa zvinhu. Zvinosanganisira kushanda nematafura uye mitsara yemasero akachinjika uye akatwasuka:
- Iyo inodiwa data nguva inosimbiswa uye bhatani rekudzima riri paribhoni rinodzvanywa.
- Rondedzero yakasarudzwa inobviswa uye maseru ari pedyo anochinjirwa kuruboshwe.
Zvinokosha! Kushandisa kiyi yeDelete inowanikwa pane ribhoni rekushandisa kuchave kushoma kushanda pane kudzima kuburikidza nemenu yemamiriro ezvinhu, sezvo isingatenderi mushandisi kugadzirisa sero offset.
Uchishandisa maturusi ari paribhoni, zvinokwanisika kubvisa zvinhu nepreselecting the direction of the shift. Iwe unofanirwa kudzidza kuti izvi zvinoitwa sei:
- Rutivi ruchadzimwa rwakaratidzwa. Zvisinei, ikozvino mu "Masero" tab, haisi "Delete" bhatani rinodzvanywa, asi katatu, iyo iri kurudyi rwekiyi. Mune iyo pop-up menyu, tinya "Delete Masero ...".
11 - Iye zvino iwe unogona kuona hwindo rave kutoonekwa nesarudzo dzekudzima nekuchinja. Iyo inoenderana nezvinangwa zvakasarudzwa inosarudzwa, uye kiyi ye "OK" inodzvanywa kuti uwane mhinduro yekupedzisira. Semuenzaniso, ichava shanduko yekumusoro.
12 - Nzira yekubvisa yakabudirira, uye kuchinja kwakaitika zvakananga kumusoro.
13
Nzira 3: kushandisa hotkeys
Izvo zvakare zvinogoneka kuita maitiro ari mubvunzo uchishandisa seti yehotkey musanganiswa:
- Sarudza huwandu huri patafura hwaunoda kudzima. Ipapo iwe unofanirwa kudzvanya musanganiswa wemabhatani "Ctrl" + "-" pane keyboard.
14 - Ipapo iwe unofanirwa kuvhura iyo yagara yakajairika hwindo rekudzima maseru mutafura. Iyo yaunoda offset nzira inosarudzwa uye bhatani rekuti OK rinodzvanywa.
15 - Nekuda kweizvozvo, iwe unogona kuona kuti maseru akasarudzwa anodzimwa neiyo offset nzira yakataurwa mundima yekupedzisira.
16
Nzira 4: Kubvisa zvinhu zvakasiyana
Pane mamiriro ezvinhu apo iwe unoda kudzima akawanda marengeti asingaonekwe seanopindirana, ari munzvimbo dzakasiyana mugwaro. Vanogona kubviswa vachishandisa imwe yenzira dziri pamusoro, nekugadzirisa sero rimwe nerimwe rakaparadzana. Zvisinei, izvi kazhinji zvinotora nguva yakawanda. Pane sarudzo yekubvisa zvinhu zvakapararira kubva patafura, iyo inobatsira kubata nebasa nekukurumidza. Zvisinei, nokuda kwechinangwa ichi, vanofanira kutanga vazivikanwa.
- Sero rekutanga rinosarudzwa nenzira yakajairwa, kubata pasi bhatani rekuruboshwe uye kuritenderedza necursor. Tevere, iwe unofanirwa kubata pasi "Ctrl" kiyi uye wodzvanya pane zvakasara zvakapararira zvinhu kana kutenderedza mitsara uchishandisa chitubu neruboshwe bhatani rakadzvanywa.
- Zvadaro, kana masero anodiwa asarudzwa, zvinokwanisika kuita kubviswa neimwe yenzira dziri pamusoro apa. Mushure maizvozvi, masero ose anodiwa achabviswa.
17
Nzira 5: Kudzima Masero Asina
Kana mushandisi achida kudzima maseru asina chinhu mugwaro, zvinogoneka kuita otomatiki maitiro ari mubvunzo uye kwete kusarudza chimwe nechimwe chezvinhu zvacho. Pane zvakawanda zvingasarudzwa zvekugadzirisa dambudziko, asi nzira iri nyore yekuita izvi ndeyekushandisa sarudzo.
- Tafura kana humwe huwandu pane pepa hunosarudzwa panodiwa kudzima. Mushure meizvozvo, kiyi yebasa "F5" inodzvanywa pane keyboard.
18 - Iwindo rekushandura rakabatidzwa. Mariri, unofanirwa kudzvanya bhatani rekuti "Sarudza ...", riri pazasi kuruboshwe.
19 - Ipapo hwindo rekusarudza mapoka ezvinyorwa richavhurwa. Muhwindo pacharo, switch inoiswa kune "Empty Cells" chinzvimbo, uye ipapo bhatani rekuti "OK" rinodzvanywa pazasi kurudyi.
20 - Mushure meizvozvo, iwe unogona kuona kuti mushure mekuita kwekupedzisira, maseru asina chinhu mune yakamaka renji anozoratidzwa.
21 - Ikozvino mushandisi anozongoita kubviswa kwemaseru ari mubvunzo nechero sarudzo dzakaratidzwa pamusoro.
Nzira 1. Yakashata uye inokurumidza
Kudzima masero asina basa muExcel tafura nenzira yakafanana, tevera matanho aya:
- Sarudza rudzi rwaunoda.
- Zvadaro bhatani rinoshanda "F5" rinomanikidzwa, mushure me "Sarudza (Special)" kiyi. Mune menyu inooneka, sarudza "Blanks" uye tinya "OK". Zvadaro zvinhu zvose zvisina chinhu muhutano zvinofanira kusarudzwa.
22 - Mushure meizvozvo, iyo menyu inopa murairo wekudzima zvinhu zvakatsanangurwa patafura yeRMB - "Delete Cells (Delete Cells) nekuchinja kumusoro".
Nzira 2: Array Formula
Kurerutsa maitiro ekudzima maseru asina basa patafura, unofanirwa kupa mazita kune anodiwa masanji ekushanda uchishandisa "Name Manager" pane "Formulas" tab, kana - muExcel 2003 uye vakuru - "Isa hwindo" - "Zita" - "Kupa".
Semuenzaniso, huwandu hweB3: B10 huchava nezita rokuti "IsEmpty", rudzi rweD3: D10 - "NoEmpty". Iwo maburi anofanirwa kunge aine saizi yakafanana, uye inogona kuwanikwa chero kupi.
Mushure mekuita mashandiro, chinhu chekutanga chechipiri chepakati (D3) chinosarudzwa uye inotevera fomula inoiswa: =KANA(ROW()-ROW(NoEmpty)+1>NOTROWS(YesEmpty)-COUNTBLLANK(YesEmpty);”«;INDIRECT(ADDRESS(ROWEST((IF(Empty<>“«;ROW(PaneEmpty);ROW() + mitsara (Kune Chisina))); MUTSARA ()-MUROW (Hapana Chisina) + 1); Koramu (Pane Chisina); 4))).
Inopinzwa seyakarongwa fomula, mushure mekuisa, unofanirwa kudzvanya "Ctrl + Shift + Enter". Mushure meizvozvo, iyo fomula iri mubvunzo inogona kuteedzerwa pasi uchishandisa otomatiki kuzadza (chitema plus chiratidzo chinotambanudzira muzasi pekona yekona yechinhu) - mushure meizvi, iyo yekutanga huwandu huchawanikwa, asi pasina zvinhu zvisina chinhu.
Nzira 3. Tsika basa muVBA
Kana mushandisi achifanira kugara achidzokorora kuvhiya kuri mubvunzo kuti abvise maseru asina kufanira kubva patafura, zvinokurudzirwa kuwedzera basa rakadaro kune rakaiswa kamwe chete uye rishandise mune imwe neimwe inotevera kesi. Nechinangwa ichi, iyo Visual Basic Mharidzo inovhurwa, nyowani isina chinhu module inoiswa, uye iwo mameseji ebasa anokopwa.
Izvo zvakakosha kuti usakanganwa kuchengetedza faira uye kudzoka kubva kuVisual Basic Mharidzo kuenda kuExcel. Kushandisa basa riri mubvunzo mune chaiyo muenzaniso:
- Huwandu hunodiwa hwezvinhu zvisina chinhu hunosimbiswa, semuenzaniso F3: F10.
- Vhura iyo "Insert" tab, uye "Basa", kana kudzvanya bhatani re "Insert Function" muchikamu che "Formulas" mushanduro itsva yemupepeti. MuMushandisi Akatsanangurwa modhi, NoBlanks inosarudzwa.
- Senharo yebasa, tsanangura danho rekutanga rine nzvimbo (B3: B10) uye dzvanya "Ctrl + Shift + Enter", izvi zvinokutendera kuti upinde basa seyakarongwa fomula.
mhedziso
Zvichienderana nechinyorwa, nhamba yakati wandei yenzira dzinozivikanwa, uchishandisa izvo zvinokwanisika kudzima masero asina kufanira mumatafura eExcel. Zvinofanira kucherechedzwa kuti kuitwa kwevakawanda vavo kwakafanana, uye mune mamwe mamiriro maitiro acho akafanana. Naizvozvo, vashandisi vanogona kusarudza nzira inovagonesa kugadzirisa rimwe dambudziko nekukurumidza uye zvinobudirira. Mukuwedzera, mupepeti akananga kubasa rekudzima tafura zvinhu zvinopa "mabhatani anopisa" anokubvumira kuchengetedza nguva pakushanda kuri mubvunzo. Mukuwedzera, kana gwaro rine masero asina chinhu, hapana chikonzero chekusarudza imwe neimwe yakasiyana kuti iwedzere kubviswa. Nezvinangwa izvi, zvinogoneka kushandisa chishandiso cheboka, icho chinozvisarudzira otomatiki zvinhu zvisina data. Mushure meizvozvo, mushandisi anongoda kudzidzima neimwe yenzira dziri pamusoro apa.