Ungayilungisa kanjani ikholomu ekudingisweni

Anonim

Ungayilungisa kanjani ikholomu ekudingisweni

Ematafuleni anenombolo enkulu yamakholomu, akunanhlakatha impela ukuzulazula kwidokhumenti, ngoba uma kuphuma umngcele wendiza yesikrini, ukuze ubone amagama emigqa lapho imininingwane ifakiwe khona, kuzodingeka ukuthi ifakwe Skrolela ikhasi elisele, bese ubuyela ngakolunye uhlangothi. Le misebenzi izofunda isikhathi esengeziwe. Ngakho-ke, ukuze umsebenzisi asindise isikhathi sakhe namandla, uhlelo lweMicrosoft Excel lunikeza amandla okulungisa amakholomu. Ngemuva kokwenza le nqubo, ingxenye yesobunxele yetafula lapho amagama emigqa ahlala ebonakalayo. Ake sibheke ukuthi singayilungisa kanjani amakholomu kuhlelo lokusebenza lwe-Excel.

Ukuqinisa ikholomu etafuleni elikhethekile

Lapho usebenza ngetafula "elibanzi", kungadingeka ukuthi ulungise zombili amakholomu (indawo) ngasikhathi sinye. Lokhu kwenziwa ngokoqobo ngokuchofoza okuningana, kanye ne-algorithm yokwenziwa ngokushesha kuleso nalawo macala amabili ehluka ngokoqobo ngephuzu elilodwa.

Inketho 1: ikholamu eyodwa

Ukuze uvikele ikholomu yesokunxele ngokweqile, awukwazi ngisho nokubazisa ngaphambi kokuthi uhlelo uqobo luqonde, lapho kudingeka khona into ethile ukwamukela ushintsho olichaziwe.

  1. Iya kuthebhu yokubuka.
  2. Iya ekubukweni kwethebhu ukuze uhlukanise ikholomu etafuleni le-Microsoft Excel

  3. Nweba imenyu yamaphuzu wemenyu.
  4. Vula inkinobho ukuvikela indawo etafuleni le-Microsoft Excel

  5. Khetha inketho yokugcina ohlwini lwezinketho ezitholakalayo - "Vikela ikholomu yokuqala".
  6. Vikela ikholomu yokuqala etafuleni le-Microsoft Excel

    Ukusuka kuleli phuzu kuqhubeke, ngokubhekisisa okuvundlile kwetafula, ikholomu yayo yokuqala (kwesobunxele) izohlala isendaweni ehleliwe.

    Ukulungiswa okuphumelelayo kwekholomu eyodwa etafuleni le-Microsoft Excel

Inketho 2: Amakholomu amaningana (indawo)

Kwenzeka futhi ukuthi kuyadingeka ukulungisa ikholomu engaphezu kweyodwa, okungukuthi, indawo leyo injalo. Kulokhu, kufanele ucabangele i-nuance eyodwa kuphela ebalulekile - ungaqokongeli ububanzi bamakholomu.

  1. Qokomisa ikholomu eduze kwendawo ohlela ukuyivikela. Okungukuthi, uma kudingeka ukuvikela ububanzi A-C. Ukwaba kuyadingeka D..
  2. Iya kuthebhu yokubuka.
  3. Chofoza kumenyu ethi "Eafe Area Area" bese ukhetha iphuzu elifanayo kulo.
  4. Ukukhetha indawo yamakholomu nokukuthola etafuleni le-Microsoft Excel

    Manje inani lamakholomu owadingayo lihleliwe futhi lapho elonga itafula, azohlala endaweni yawo - ngakwesobunxele.

    Isibonelo sokulungiswa ngempumelelo kwendawo yekholomu etafuleni le-Microsoft Excel

    Bheka futhi: Ungayifaka kanjani indawo e-Microsoft Excel

Ukulahlwa kwendawo erekhodiwe

Uma isidingo sokubopha ikholomu noma amakholomu sanyamalala, kuyo yonke ithebhu efanayo "yokubuka" yohlelo lwe-Excel, vula imenyu ethi "Indawo ephephile" bese ukhetha inketho ethi "Susa Inketho Yesifunda". Kuzosebenza zombili ngento eyodwa kanye nebanga.

Susa ukulungiswa kwendawo yekholomu etafuleni le-Microsoft Excel

Ukugcina

Njengoba ubona, ku-Microsoft Excel Table processor, ungalungisa kuphela eyodwa kuphela, ikholomu yangakwesobunxele noma ibanga lelo (indawo). Ngaphandle kwabo, uma kudingeka isidingo esinjalo, ungaphinde futhi ngokoqobo ngokuchofoza kathathu.

Funda kabanzi