Ungayilungisa kanjani ikhanda letafula ku-Excel. Ukukhiya umugqa ongenhla, cap eyindilinga

Lapho usebenza ngamatafula amade angenakubekwa esikrinini ngokuqondile futhi unenombolo enkulu yamakholomu, isidingo sokuskrolela isikrini ukuze ukhiphe umugqa ophezulu nezihloko ezizokwenzeka ngezikhathi ezithile. Ukuze kube lula ohlelweni lwe-Excel, kungenzeka ukulungisa izigqoko zetafula phezulu kwesikrini ngaso sonke isikhathi kuze kufike ifayela. Ngezansi kunezinketho zokukuthola lokhu.

Kuyadingeka ukuvikela intambo eyodwa ephezulu.

Ukulandelana kwezenzo ukuvikela intambo

1. Esikhathini esiphezulu sohlelo, udinga ukuya kuthebhu ethi "View".
2. Esigabeni esithi "Iwindi" (amagama ahlukanisayo afakwe kuhlu olungaphansi lwetheyiphu) ukuthola into "qinisa indawo" bese uqhafaza kunxantathu engxenyeni yayo efanele.
3. Uhlu oluvula, khetha u- "Vikela intambo ephezulu" ngokucindezela inkinobho yegundane kwesobunxele. Umphumela uzoba khona unomphela esikrinini sesihloko setafula, osindisiwe nangemva kokuvala ifayela.

Ukulungisa izigqoko emigqeni eminingana

Uma kudingeka imigqa eminingi, khona-ke isenzo sehlukile:

1. Kwikholamu yangakwesobunxele ngokweqile kwetafula, chofoza esitokisini sentambo yokuqala engeyona ingxenye ye-cap. Kulokhu, leli yiseli le-A3.

2. Iya kuthebhu ethi "Buka", chofoza ku- "Lungisa indawo" nakuhlu lokuyeka khetha into ebonakalayo ku- ". Ngenxa yalokhu, yonke imigqa etholakala ngaphezulu kwaleyo engumnikazi weseli elikhethiwe iqoshwe ngaphezulu kwesikrini.

"Ithebula elihlakaniphile" - enye inketho yokubopha isigqoko

Lowo ojwayelene namatafula ahlakaniphile angasizakala ngenye indlela ewusizo yokuhlanganiswa. Kuliqiniso, le nketho isebenza kuphela esigabeni somugqa owodwa.

Izenzo zokwakha "itafula elihlakaniphile"

1. Kuthebhu ribbon "ekhaya" Qokomisa lonke itafula.
2. Esigabeni "Styles" (emugqeni ongezansi wetheyipu), chofoza into "yefomethi njengento" yetafula ". Iwindi livula ngesethi yezitayela zetafula. Idinga ukuchofoza okukhethwa kukho okufanele kakhulu.

3. Iwindows "yokufometha" isuka lapho imingcele yethebula lesikhathi esizayo ikhonjiswa, kanye nebhokisi lokuhlola "Ithebula elinamakhanda" litholakala. Kufanele uqiniseke ukuthi eyokugcina iyinkimbinkimbi.
4. Vala iwindi ngokucindezela inkinobho ethi "Kulungile".

Dala itafula elihlakaniphile ngenye indlela:

1. Ngemuva kokukhetha indawo oyifunayo, iya ku-Insert Ribbon Tab bese uqhafaza entweni ethi "Ithebula".
2. Ohlwini lwe-pop-up, chofoza iphuzu "yetafula".
3. Ngemuva kokuvela kwewindi le- "Creating Table" livela ngokuqukethwe okufanayo newindows "yokufometha etafuleni", udinga ukwenza izenzo ezifanayo nesichaziwe esele ngenhla. Ekugcineni, "itafula elihlakaniphile" lizovela nge-cap elungiswe phezulu.

Ungayiphrinta kanjani itafula elinesikebhe ekhasini ngalinye

Lapho unyathelisa itafula elisebenzisa amakhasi ambalwa, kuyasiza ukuba nenhlokweni yalo ekhasini ngalinye. Lokhu kukuvumela ukuthi usebenze nganoma iyiphi ikhasi ephrintiwe ngokwahlukana. Ohlelweni lwe-Excel, lesi sici sinikezwa futhi sisetshenziswe kanjena.

1. Iya kuthebhu yethebhu ye-Ribbon yoMarkup wekhasi futhi ekhasini "Izilungiselelo zekhasi" (kulayini wenduku ongezansi) Chofoza efasiteleni ngomcibisholo ongakwesokudla kwesokudla komcibisholo.

2. Efasiteleni "ekhasini" elivula, liye kuthebhu "Yeshidi".
3. Chofoza ewindini le- "Thrink Lines" (kwesibili ngenhla).
4. Buyela etafuleni futhi, uhambisa isikhombisi esithathe umbono ngomcibisholo omnyama oqondiswe kwesokudla, emgqeni ngezinombolo zomugqa, cabanga ngentambo isigqoko setafula.

5. Kulezi zenzo zonke ziyaqedwa, noma kunjalo, umphumela wazo awukhonjiswa esikrinini.

Bheka ukubuka kwewindows kwedokhumenti ephrintiwe - ikhasi 1 nge-cap

Lapha ngokucindezela onxantathu emgqeni ongezansi wefasitela noma ukuklebhula isondo legundane, lapho isikhombisi esifakiwe ekhasini lethebula, ungabuka wonke amakhasi ukubheka izigqoko kulowo nalowo kubo.

Ukubuka kuqala iwindi ngaphambi kwedokhumenti yokuphrinta - ikhasi 2 ngesigqoko

iziphetho

Ku-Excel, kunezindlela ezimbili zokubonisa njalo kumakhambo etafula letafula. Enye yazo ifaka ukusetshenziswa kokuqina kwesifunda, okwesibili ukuguqula itafula libe "smart" lisebenzisa ukufometha kwendawo ekhethiwe yokufaka okufakiwe kuyo. Zombili izindlela zivunyelwe ukulungisa umugqa owodwa, kepha okokuqala kuphela okuvumela ukuthi kwenziwe nge-cap equkethe imigqa eminingi. I-Excel inokusebenziseka kalula - amandla okuphrinta idokhumenti nge-cap ekhasini ngalinye, okuyikho, okukhona, okukhulisa ukusebenza kahle kokusebenza nalo.

Umlayezo wokuthi ungalungisa kanjani ikhanda letafula ku-Excel. Ukulungisa umugqa ongaphezulu, isigqoko esiyinkimbinkimbi savela kuqala kubuchwepheshe bolwazi.