Ungayilungisa kanjani indawo e-Excel

Lapho usebenza ngenombolo ebalulekile yedatha ephepheni le-spreadsheet, kufanele uhlole amapharamitha athile njalo. Kepha uma baningi babo, futhi indawo yabo idlula imingcele yesikrini, hambisa njalo umqulu wokuskrola awuphatheki kahle. Abathuthukisi be-Excel bavele banakekele lula abasebenzisi, bethula kulolu hlelo ukuthi kungenzeka kube khona izindawo ezihlanganisa izindawo. Ake sithole ukuthi lesi sici sisetshenziswa kanjani nokuthi singalusebenzisa kanjani uhlelo lwe-Microsoft Excel.

Ukuqinisa indawo e-Excel

Isixazululo somsebenzi wethu wanamuhla sizokhonjiswa esibonelweni sohlelo lwe-Excel oluyingxenye yephakheji ye-Microsoft Office 365, kodwa ezinguqulweni ezedlule noma ngaphezulu (2019), izinyathelo ezidingekayo zokulungisa indawo yenziwa ngokufanayo indlela.

Inketho 1: Indawo yezintambo

Imvamisa e-E-Table Excel, kuyadingeka ukulungisa indawo kusuka emigqeni eminingana ephezulu, okuyi-cap okuthiwa yi-cap. Lokhu kwenziwa ngale ndlela elandelayo:

Ukugxila ezinombolweni ezinomugqa ohlangothini (kwesobunxele) uhlelo lwephaneli, khetha inkinobho yesokunxele ngokucindezela inkinobho yegundane (LKM) ngokusho komugqa, okuzoba okulandelayo kwebanga elithile. Esibonelweni sethu, sizobopha imigqa emithathu yokuqala, okungukuthi, kuyadingeka ukwaba kuleli cala okwesine.

Ukukhetha umugqa ongezansi ukuze uvikele indawo yentambo etafuleni le-Microsoft Excel

Iya kuthebhu ethi "View" bese kubha yamathuluzi "ewindi", wandise imenyu yento "ephephile yendawo".

Ukuguqulwa ekuhlanganiseni indawo evundlile etafuleni le-Microsoft Excel

Uhlu olubonisiwe lwezinketho ezitholakalayo, khetha okuwukuphela kwenketho efanelekile ngezinhloso zethu - "Bopha indawo".

Vikela indawo kusuka emigqeni etafuleni le-Microsoft Excel

Nansi indlela ongalungisa kalula indawo evundlile equkethe imigqa eminingana, etafuleni le-elekthronikhi le-Excel.

Isibonelo sokwabiwa okuphumelelayo kwendawo yemigqa etafuleni le-Microsoft Excel

Inketho 2: Indawo yamakholomu

Kwenzeka futhi ukuthi kuyadingeka ukubopha phezulu kwetafula, kepha uhlangothi, okungukuthi, amakholomu atholakala ngakwesobunxele. I-algorithm yezenzo kuleli cala iyafana, kepha ngokuchitshiyelwa okufushane.

Qokomisa ikholomu elandela uhla lwalawo ahlela ukulungisa. Esibonelweni sethu, ikholomu ye-C, ukuthi, sizolungisa ububanzi A-B.

Ukukhetha ikholomu kulandela uhla lokuthola etafuleni le-Microsoft Excel

Vula ithebhu yokubuka bese usebenzisa into "evikelekile yendawo".

Iya ekutholeni indawo kusuka kumakholomu kuThebula Microsoft Excel

Khetha inketho yokuqala kusuka ohlwini oluphindaphinda igama lento esemqoka bese ukhulunywa ngathi engxenyeni edlule.

Vikela indawo yekholomu etafuleni le-Microsoft Excel

Kusukela kulo mzuzu, indawo eqokiwe (kwesobunxele) isifunda izolungiswa, futhi lapho isuka etafuleni endaweni evundlile, izohlala isendaweni yayo.

Umphumela wokulungiswa ngempumelelo kwamakholomu etafuleni le-Microsoft Excel

Inketho 3: Indawo yemigqa namakholomu

Kususelwa eqinisweni lokuthi imininingwane equkethwe kumaseli, okuvame kakhulu okudingeka ukuthi igcine phambi kwamehlo, ingatholakala zombili emigqeni yayo engenhla kanye namakholomu aseceleni, akumangazi ukuthi i-Freel Toolkit ikuvumela ukuthi ulungise zombili owokuqala nowesibili. Kwalokhu:

Gikomisa ngokucindezela i-LCM ukuthi iseli elitholakala ngaphansi kwemigqa kanye nelungelo lamakholomu ofuna ukukulungisa, bese uya kuthebhu ethi "View".

Isibonelo: Ukuze ulungise imigqa emibili yokuqala (12) nekholamu (A, b) , khetha iseli ngekheli C3.
.
Emkhakheni wamathuluzi wamathuluzi we- "Window", sebenzisa into "qinisa indawo"

Futhi ohlwini oluvula, khetha inketho efanayo.

Ukuqinisa indawo yemigqa namakholomu etafuleni le-Microsoft Excel

Manje, ngokubhekisisa okuqondile kwetafula, imigqa emisiwe izohlala isendaweni,

Futhi ngamakholomu ahleliwe aqondile azosala.

Indawo yamakholomu ifakwe ku-Microsoft Excel Table

Uhlobo lwesenzo olubhekwe kule ngxenye ukuhunyushwa okungokoqobo kakhulu kwegama elithi "Hlanganisa indawo". Yenza uhla lwe-static kusuka emigqeni namakholomu kungadingeka lapho ingxenye engenhla yepredishithi ye-Excel isigqoko, futhi uhlangothi luqukethe, ngokwesibonelo, izinombolo zokulandelana zabasebenzi.

Indawo yamakholomu nemigqa ivinjelwe etafuleni le-Microsoft Excel

Inketho 4: Ikholomu eyodwa noma umugqa owodwa

Uma ngaphansi kokuhlanganiswa kwesifunda, usho ukulungiswa kwento eyodwa yetafula, okungukuthi, omunye womugqa wawo noma ikholomu eyodwa, konke kwenziwa kube lula kakhulu. Uvele uqokomise ingxenye oyifunayo, bese ukhetha into ehambelana nomsebenzi wakho kunkinobho "ephephile yendawo". Ngenye indlela, awukwazi ukwabiwa nhlobo, futhi umane ukhethe enye yezinketho ezifanele - "Vikela intambo ephezulu" noma "qinisa ikholomu yokuqala", esekelwe kumuphi umsebenzi wakho. Le nqubo, kanye nama-nuances angasho lokho kungase kushiwo ukuqaliswa kwayo, kwabhekwa njenge-ETSHA EKUGCINENI, futhi sincoma ukuzijwayeza.

Ukulungisa umugqa owodwa noma ikholomu eyodwa etafuleni le-Microsoft Excel

Funda kabanzi: Ungawuvikela Kanjani umugqa owodwa noma ikholomu eyodwa

Ukulahlwa kwendawo efakwe ngaphakathi

Esimweni lapho isidingo sokuhlanganisa indawo (izintambo, amakholomu noma uhla oluxubile akunandaba) anyamalale, kuzodingeka ukuthi enze eqinisweni, njengasezimweni ezibhekwa ngenhla. Umehluko kuphela ukuthi imenyu ye- "Fix Area" kufanele ikhethe into yokuqala neyokubonakala kakhulu kulomongo ukuthi "ukhiphe izifunda ezivuthiwe".

Susa ukuqinisa imigqa namakholomu etafuleni le-Microsoft Excel

Ukugcina

Thatha izintambo, amakholomu noma ukuthuthukisa uhla lwabo ku-Microsoft Excel Spreedsheet kulula. Into esemqoka kulokhu Qonda kahle ukuthi yiluphi uhlobo lwetafula okufanele lwabelwe, futhi satshelwa ngokuningiliziwe esihlokweni sanamuhla.