Yekuchumana sendlela ukushintsha izinombolo Excel izinhlamvu

Namuhla sizoxoxa kanjani ukushintsha izinombolo Excel izinhlamvu. Kwezinye izimo kubalulekile. Noma kunjalo, abasebenzisi abaningi zijwayele umhleli Excel ukuthi izinombolo umugqa enzelwe ngezinombolo, esikhundleni salokho, izipikha bungabonakala izinhlamvu.

imfundo

Ukuze ukuxazulula umbuzo kanjani ukushintsha izinombolo Excel izinhlamvu, ikakhulukazi ukwenza izinguquko ezithile esimisweni isithenjwa isitayela. Ukuze wenze lokhu, hamba uye ithebula kumhleli. Ngenxa yalokho, inani amakholomu luzobuyiselwa incwadi namagama. Qaphela ukuthi ukubaluleka ukucushwa echazwe lilondolozwe ifayela kanye etafuleni, kanjalo kokuvula impahla, esikhathini esizayo thina ukulayisha wathi ipharamitha. Excel kweso ukuqaphela esenziwe ngaphambili izinguquko futhi uyolokhu ebahola ye amakholomu ngokuhambisana nezidingo umsebenzisi. Uma uvula ifayela kunencazelo ehlukile lokhu kulungiselelwa, sizobona isitayela ezahlukene ye amakholomu. Ngamanye amazwi, uma uthola itafula nge izilungiselelo engavamile, bayosala okufanayo kuzo zonke ezinye izinto.

Excel Izinketho

Thina dlulelani esinyathelweni esilandelayo nodaba Excel ukushintsha izinombolo izinhlamvu futhi embule kwimenyu main umhleli ngokuchofoza inkinobho enkulu round ekhoneni elingenhla esinxeleni sewindi. Laphaya ezansi sizobona imisebenzi emibili. Omunye wabo okuthiwa «Izinketho Excel". Chofoza kuso. Lezi zinyathelo kungaba kwenziwe ngaphandle kokusebenzisa mouse - kwimenyu enkulu evuleka uma ucindezela ikhi ALT kuqala bese "F". Ngakwelinye ihlangothi, ukufinyelela evulekile Excel nemingcele ezidingekayo asivumela uhlamvu «M».

isitayela izixhumanisi

Ukuze ukuxazulula umbuzo kanjani ukushintsha izinombolo Excel izinhlamvu, khetha into "Umthetho ofingqiwe". It is kwesokunxele ukuze uvule iwindi izilungiselelo. Ucinga ipharamitha ukuthi unesibopho ukusebenza amafomula. Kuyinto into yokuqala kule ngxenye, ebizwa ngokuthi "links isitayela", ichaza indlela izikhulumi uzobe wabonisa kuwo wonke amakhasi we umhleli. Ukuze esikhundleni isibalo izinhlamvu, susa uphawu elihambisana iphimbo kuchazwe. Manipulation lolu hlobo zingaba ngosizo negundane nekhibhodi. Kulo mBhalo, sisebenzisa inhlanganisela okhiye ALT 1. cindezela inkinobho «OK» After nke izinyathelo ezingenhla. Ngakho-ke izoqopha izinguquko izilungiselelo. Ezinguqulweni ngaphambili kwe-software ukufinyelela inkinobho yemenyu main has a ukubukeka ezahlukene. Uma usebenzisa uhlelo "2003" umhleli, sebenzisa "Izilungiselelo" imenyu. Okulandelayo, iya ku "Okujwayelekile" ithebhu, futhi ushintshe sokushona "le R1C1". Ngakho esiphethweni kanjani ukushintsha izinombolo Excel izinhlamvu.