Kodi kuchotsa mizere akusowekapo mu "Eksele": Njira ochepa, osavuta

onse ogwiritsa amene ntchito ndi spreadsheets mu kupambana ofesi mkonzi, nthawi m'pofunika kuchotsa maselo kanthu kuti ndi mizere, ndiye sangachitire zotere workspace wanu. Amene ayankhidwa, monga "kupambana" tebulo kuchotsa chingwe kanthu. Ena njira akhala akugwira zinthu zina. Mwachitsanzo, pamene kanthu ofanana ndi mizati kapena maselo payekha.

Kodi kuchotsa mizere akusowekapo mu "Eksele" njira ziwiri yosavuta?

Choyamba, tiyeni tinene kuti pamene ntchito ngati muyenera kusamala kwambiri. chakuti maselo anyamula zobisika chilinganizo (colorless lemba). Ndipo anapezazo eni angaimire mzere imene deta palibe, koma anafuna kuti atchule m'tsogolo. maselo amenewa mwa mawu a ndondomeko ndi suona kanthu.

Koma tayang'anani momwe "Eksele" kuchotsa mizere kanthu, ngati alidi choncho. Njira yosavuta akuti ndi kusankha wabwinobwino ndi mbewa pamene akugwira batani kumanzere. Linapangidwa oposa kapena downwards munda wa analipo kumanzere. Kenako, pogwiritsa ntchito bwino-pitani, inu amapembedza menyu nkhani, kusankha kumene mizere zichotsedwa. Koma njira imeneyi ntchito pokhapokha ngati maselo imakonzedwa mu mzere.

Kodi kuchotsa mizere akusowekapo mu "Eksele" ngati minda kanthu alternating ndi deta? Pankhaniyi, vutoli kuthetsedwa m'njira ina. Kuti tichite zimenezi, kukhalitsa ndi Ctrl kiyi, kenako kuligwira, tchulani mzera uliwonse kuti zichotsedwa. Pambuyo pake, kusankha ntchito yoyenera menyu dinani-kumanja. Dziwani kuti ngati inu ntchito Del kiyi, adzapatsidwa yekha kuti nkhani za mankhwala, osati kuchotsa mizere lonse. Mu nkhani zina, choncho losavuta, mukhoza kugwiritsa ntchito izo.

Monga "Eksele" kuchotsa mizere akusowekapo ndi thandizo la mtundu?

Pali njira zingapo ntchito zimenezi. njira imodzi funso mmene kuchotsa mizere akusowekapo mu "Eksele" mwina ntchito kusanja zipangizo.

Kuti tichite zimenezi, pambuyo posankha tebulo lonse (Ctrl + A) mu gawo deta kusankha mtundu menyu, ndi fyuluta. Apa ntchito lamulo inalamula kwa osachepera kuti pazipita (mizere akusowekapo adzakhala m'munsi). Pambuyo pake, iwo akhoza kuchotsedwa. Ngati dongosolo la ntchito yomanga deta n'kofunika, choyamba tiyenera kumanga ndi ndime akusowekapo ntchito ndi manambala mosalekeza. Pambuyo kuchotsa mizere kachiwiri kubala molumikiza pa danga la awerengedwa.

Kuchotsa mizere ntchito fyuluta

Pofuna kuthana ndi vuto la mmene kuchotsa mizere akusowekapo mu "Eksele" ndipo mungathe ndi fyuluta yosavuta. Iwo anapereka yopezera ndi ndime kapena gulu la mizati tebulo lonse. Komanso, ntchito lamulo "Woganiza" mu gawo kusanja.

Tsopano basi tilimbikire sefa yokha, kusonyeza okha maselo kanthu ndi kuchotsa iwo. Koma pali nsomba. kuchotsa kungatenge lingagwiritsidwe ndime zingapo, ngati wina mzere chimodzi selo lili deta.

Kutalikirana kwa magulu selo

Pomaliza, taganizirani njira ina chilengedwe. Iye zochimwazo kumathetsa vuto la momwe "kupambana" kuchotsa mizere akusowekapo mu uthunthu ndi ku nambala inayake phindu.

Pankhaniyi, muyenera ntchito kusintha gawo pa gulu lalikulu ndi kusankha batani "Pezani mfundo". mzere gulu kudzipatula selo osankhidwa menyu dontho-pansi. Ndipo mawu a bokosi ndi adamulowetsa amene anatchulapo unit kanthu. Pambuyo pake, mu Ntchito gawo ndi maselo anasankha batani Chotsani.

m'malo epilogue ndi

Ndizo zonse njira yosavuta imene mukhoza kuchotsa mizere kanthu monga angapo kudina. Kachiwiri, ayenera kukumbukira kuti lemba chobisika angakhale ena maselo. A maselo akusowekapo ndicho kukhala amadalira kutchula iwo mu kachitidwe. Ngati zokolola za kuchotsa awo, ndiye njira sizigwira ntchito, ndi pulogalamu adzakhala kupanga kulakwitsa mu mawerengedwe a pamaso limasonyeza kuti deta si sakupezeka kapena pachithunzichi. Choncho, ngati vuto ayenera kukhala osamala kwambiri kuti tisasokoneze umphumphu wa masamu kapena ena ntchito. Apo ayi, zonse ndi yosavuta. Malinga ndi zimene zotsatira ndi kupeza, n'zotheka ntchito limodzi kapena njira zina.