Ungayifaka njani ikholamu kwi-Excel

Ukusebenza kwi-Microsoft Excel, eyona nto iphambili kukufunda ukufaka imitya kunye neekholamu etafileni. Ngaphandle kobu buchule, phantse akunakwenzeka ukusebenza ngedatha ye-tabuster. Masihlangabene nendlela yokongeza ikholamu kwi-dexle.

Isifundo: Njani ukongeza ikholamu kwitafile yeMicrosoft Word

Faka ikholamu

E-Excel, zininzi iindlela zokufaka ikholamu kwiphepha. Uninzi lwazo lulula, kodwa umsebenzisi we-novice usenokungakwazi ukujongana nayo yonke into. Ukongeza, kukho inketho yokulongeza ngokuzenzekelayo imitya yokuhamba kwetafile.

Indlela yoku-1: Faka ngepaneli yokulungelelanisa

Enye yeendlela ezilula zokufakwa okuphezulu kukwenza umsebenzi ngepaneli ye-Excel ye-Excel.

Ukucofa kwiphaneli enamagama athe tyaba ngamagama eekholamu ngokwecandelo, ngasekhohlo apho kufuneka ufake iikholamu. Kule meko, ikholamu yabelwe ngokupheleleyo. Cofa iqhosha lemouse lasekunene. Kwimenyu ebonakalayo, khetha into "ye-paste".

Ukongeza ikholamu ngephaneli yokulungelelanisa kwiMicrosoft Excel

Emva koko, ikholamu entsha yongezwa kwangoko ngasekhohlo kwendawo ekhethiweyo.

Ikholamu yongezwa kwiphaneli yokulungelelanisa kwiMicrosoft Excel

Indlela 2: Ukongeza iseli kwimenyu yemeko

Unokwenza lo msebenzi kwaye ngokwahlukileyo, oko kukuthi ngemenyu yemeko yeseli.

Cofa kulo naliphi na iseli esekwe kwikholamu ngasekunene kwekholam ekucetywe ukongeza. Cofa kule nqaku iqhosha lemouse lasekunene. Kwimenyu yokujonga, khetha "Cola ...".

Faka ikholamu ngemenyu yomxholo kwi-Microsoft Excel

Ngeli xesha ukongeza akuphume ngokuzenzekelayo. Ifestile encinci ivula, apho ufuna ukucacisa ukuba ngumsebenzisi oza kufaka:
- Ikholam;
- Umqolo;
- Iseli nge-shift;
- Iseli kunye ne-Shift ngasekunene.
Siphinde silungelelanise i-switch kwi "kholam" kwaye ucofe iqhosha "Kulungile".

Ukukhetha uhlobo longeze iiseli kwiMicrosoft Excel

Emva kwezi zenzo, kuya kongezwa ikholamu.

Ikholamu yongezwa kwimenyu yenguqu kwiMicrosoft Excel

Indlela 3: Iqhosha kwiRibbon

Ukufakwa kweekholamu kunokwenziwa kusetyenziswa iqhosha elikhethekileyo kwiteyiphu.

Khetha iseli ngasekhohlo ekucetywe ukongeza ikholamu. Ukuba "kwikhaya" ithebhu, cofa kwi icon kwifom ye-unxantathu engenayo, ekufuphi "Isixhobo se" seseli "kwi-thepe. Kwimenyu evula, khetha i "Faka iikholamu kwiPhepha" Into.

Faka ikholamu ngeqhosha kwi-ribbon kwi-Microsoft Excel

Emva koko, ikholamu iya kongezwa ngasekhohlo kwento ekhethiweyo.

Indlela yesi-4: Ukufaka amaqhosha ashushu

Kwakhona, ikholamu entsha inokongezwa kunye nezitshixo ezishushu. Kwaye zimbini iindlela zokwenza

Enye yazo ifana nendlela yokuqala yokufaka. Kuya kufuneka ucofe kwicandelo kwiphaneli elungelelanisiweyo ethe tyaba esekunene yendawo yokufakelwa icetywayo kwaye ucofe i-CTRL ++ iqhosha lesitshixo+.

Icandelo elisekhenteki kwiPaneli yokuLungelelanisa kwiMicrosoft Excel

Sebenzisa ukhetho lwesibini, kufuneka wenze i-cofa kuyo nayiphi na iseli kwikholamu ngasekunene kwendawo yokufakela. Emva koko ucofe kwikhibhodi ye-CTRL ++. Emva koko, ke iwindow encinci ngokukhetha ukufaka, eyathi ichazwe kwiNdlela yesibini yokwenza umsebenzi. Ezinye zezenzo zifana ngokuchanekileyo: khetha igatya "ikholam" kwaye ucofe iqhosha "Kulungile".

Isifundo: Izitshixo ezishushu kwi-Excele

Indlela 5: Ukufaka iikholamu ezininzi

Ukuba ufuna ukupaka ngoko nangoko iikholamu ezininzi, emva koko i-Prisle akuyimfuneko ukwenza umsebenzi ohlukileyo kwinto nganye, kuba le nkqubo inokudityaniswa kwisenzo esinye.

Kuya kufuneka kuqala ukhethe iiseli ezininzi kuluhlu oluhombisayo okanye amacandelo kwiphaneli yokulungelelanisa, zingaphi iikholamu ekufuneka zongezwe.

Ukukhetha iiseli ezininzi kwiMicrosoft Excel

Emva koko sebenzisa enye yezenzo ngemenyu yomxholo okanye ngamaqhosha ashushu achazwe kwiindlela zangaphambili. Inani elihambelanayo leekholamu liya kongezwa kwi-Ekhohlo lendawo ekhethiweyo.

Indlela yesi-6: Yongeza ikholamu ekupheleni kwetafile

Zonke ezi ndlela zilapha ngasentla zilungele ukongeza izithethi ekuqaleni nakwizimbindi zetafile. Banokusetyenziselwa ukufaka iikholamu ekupheleni kwetafile, kodwa kule meko kuya kufuneka wenze ifomathi efanelekileyo. Kodwa kukho iindlela zokudibanisa ikholamu ukuya esiphelweni setafile ukuze ibonwe kwangoko yinkqubo yokwaphula kwangoko. Ukwenza oku, kufuneka wenze, itafile ebizwa ngokuba "smart".

Sibonisa uluhlu lwetafile esifuna ukuguqukela kwitafile "ye-Smart".

Ukuba kwithebhu yasekhaya, cofa kwi "fomothi njengeTheyibhile" iqhosha, elikwisixhobo se "Stayles" kwi-tepi. Kuluhlu lwekhitshi, khetha uluhlu olukhulu lwezitayile zoyilo zetafile ngokokubona kwakho.

Ukwenza itafile ye-smart kwi-Microsoft Excel

Emva koko, iwindow ivula, ebonisa ukulungelelaniswa kwendawo ekhethiweyo. Ukuba uyiqaphele into engalunganga, uya kuhlela kanye apha. Eyona nto iphambili kukuba kufuneka wenze kweli nyathelo kukujonga ukuba ibhokisi yokutshekisha ifakiwe kufutshane ne- "Tebhu eneentloko". Ukuba itafile yakho inesigqoko (kwaye uninzi lweemeko), kodwa akukho phawula le nto, kuya kufuneka uyifake. Ukuba zonke iisetingi zisetwe ngokuchanekileyo, nqakraza kwiqhosha "Kulungile".

Ukufomatha Ukulungelelaniswa kweMicrosoft Excel

Emva kwezi zenzo, uluhlu olunikezelweyo lwalufotwe njengetafile.

Ngoku ukuze senze ikholam entsha kule theyibhile, kwanele ukugcwalisa naliphi na iseli ekunene kwayo. Ikholamu apho iseli khona iya kuba yi-tabuster ngoko nangoko.

Ikholamu yongezwa kwiTheyibhile ye-Smart kwiMicrosoft Excel

Njengoko ubona, zininzi iindlela zokudibanisa iikholamu ezintsha kwiphepha eliphezulu phakathi kwetafile nakwimihla ebekiweyo. Ukongeza kweyona ilula kwaye ilula, kungcono ukuyila, ebizwa ngokuba yitafile "smart". Kule meko, xa uyongeza idatha kuluhlu ngasekunene kwetafile, iya kubandakanywa kwikholamu entsha.