Ukongeza njani iiseli ukuze uphumelele. Iindlela ezi-3 zokongeza iiseli kwitafile ye-Exfel

Ungatsho ngokuzithemba ukuba bonke abasebenzisi bayazi indlela yokongeza iseli entsha kwitheyibhile ye-Excel, kodwa ayinguye wonke umntu owaziyo zonke izinto ezivumelekileyo zalo msebenzi. Lilonke, iindlela ezi-3 ezahlukeneyo zaziwa ngokuba yeyiphi na inokwenzeka ukuba iphumeze iseli. Rhoqo indlela yokusombulula iingxaki ixhomekeke kwindlela esetyenzisiweyo. Cinga ngeenkcukacha, ngoncedo lwendlela enokuthi yongeze iiseli kwitafile evuthumeni.

Ukongeza iiseli kwitafile

Inani elikhulu labasebenzisi bakholelwa ukuba ngexesha longezwa kweeseli, ukonyuka kwabo ngokupheleleyo, kuba into entsha ivele. Nangona kunjalo, oku akuhambelani nenyani, kuba inani labo lilonke liya kuhlala lifana. Ngapha koko, kukudluliselwa kwento ukusuka ekupheleni kwetafile ukuya kwindawo efunekayo ngokususwa kwedatha yeseli eshukumayo. Ngenxa yoku, kufanele ukuba ithole xa isuswe, kuba inokwenzeka ukuphulukana nolunye ulwazi.

Indlela yoku-1: Usebenzisa imenyu yemodeli yeeseli

Indlela ephantsi kokuqwalaselwa isetyenziswa rhoqo kunabanye, njengoko kuthathwa njengeyona nto ilula ukuyisebenzisa. Ukongeza iiseli ezinje ngeyona ndlela, kufuneka ulandele le algorithm yezenzo:

1. Sibeka isikhombisi semouse kwindawo ethile yoxwebhu apho kufuneka wongeze into. Emva kokubiza imenyu yemeko yento ekhethiweyo ngokucinezela i-PCM kunye noluhlu lwe-pop-up of Imiyalelo, khetha "Cola ...".

Ukufakwa kweseli ngemenyu yemeko

1. I-esweni iya kupapasha ifestile ngeeparameter. Ngoku kufuneka ubeke uphawu kufutshane nombhalo "weeseli". Kukho iindlela ezi-2 zokufaka-nge-shift ukuya ngasekunene okanye ezantsi. Kuya kufuneka ukhethe ukhetho olufunekayo kwimeko ethile kwaye ucofe Kulungile.
2. Emva koko, unokubona ukuba into entsha iya kuvela endaweni yokuqala, i-offtit kunye nabanye.

Indlela efanayo inokwenzeka ukongeza iiseli ezininzi:

1. Inani elifunayo leeseli libalaselisiwe. Imenyu yemeko ibizwa ngokuba kukucinezela i-PCM kuluhlu oluchaziweyo kwaye ukhethe "Cola ...".

Faka iiseli ezininzi kwimenyu yomxholo

1. Ngokhetho olunokwenzeka, khetha le iyafuneka kwaye ucofe u "Kulungile".
2. Iiseli ezintsha ziya kuvela endaweni yokuphawulwa, yatshintshelwa uye kwelinye.

Indlela 2: Usebenzisa isixhobo esikhethekileyo kwimenyu ephambili

1. Njengakwicala elidlulileyo, ekuqaleni isandi se mouse kwindawo apho kuya kwenziwa khona iseli eyongezelelweyo. Emva koko, kwimenyu, khetha ithebhu yasekhaya, emva koko kufuneka ukuvula icandelo "leseli" apho ucofe khona "Faka".

Ukufakwa kweseli ngemenyu ephambili

1. Kwindawo ephawulweyo apho kuya kongeza ngoko nangoko iseli. Kodwa ngendlela efanayo, ukufakelwa kwe-Shift kwenzeka kuphela, oko kukuthi, faka iseli nge-Shift kwicala lasekunene lendlela ephantsi koqwalaselo ayiyi kuphumelela.

Ngomfanekiso wendlela yokuqala kukho ukhetho ukongeza iiseli ezininzi:

1. Khetha inani elifunekayo leeseli kumtya (ngokuthe tyaba). Okulandelayo, cofa kumbhalo "Faka".

Faka iiseli ezininzi ngemenyu ephambili

1. Emva koko, iiseli ezongezelelweyo zongezwa ngokususwa kwezinto ezinikezelweyo kunye nezinye.

Okulandelayo, cinga ngento eyenzekayo ukuba ukhetha umgca kunye neeseli, kodwa ikholamu:

1. Kuyimfuneko ukuqaqambisa iiseli zomqolo othe nkqo kwaye ucofe u "Faka" umbhalo kwithebhu ephambili.
2. Kwimeko enjalo, iiseli ziya kongezwa kwi-Shift ukuya kuluhlu olusekunene kunye nezinto, ezazingowokuqala ukuya kuvela kuyo.

Kukwakufanelekile ukugxininisa ukuba ukongeza njani uluhlu lweeseli, ezibandakanya inani lezinto ezithe nkqo nethe nkqo:

1. Emva kokukhethwa koluhlu olufunekayo, izenzo zezenzo eziqhelekileyo ezenziweyo, oko kukuthi, kwi "Ekhaya" TAB, cofa kwi "Fink" i "Faka" i- "Fitsela" i "Faka" i "Faka" umbhalo "wokufaka".
2. Ngoku ungabona ukuba izinto ezongeziweyo zitshintshwa.

Ngexesha longezwa kwe-selk yeseli, indima echazayo idlala leliphi inani lemigca kunye neekholamu eziqulethe:

• Xa kukho uchungechunge lwamagama amaphezulu kuluhlu kunokuntshula, emva koko emva koko iiseli ezongezelelweyo ziya kutshintshwa xa zongeza.
• Xa kukho imiqolo ethe tye kwindawo ethe nkqo kunokuba nkqo, emva koko iiseli ziya kutshintshwa ngasekunene xa zongeza.

Xa ufuna ukumisela kwangaphambili ukuba ifakwe njani iseli, kufuneka yenziwe ngolu hlobo:

1. Kukho indawo apho iseli (okanye eliliqela) iya kufakwa. Emva koko kuya kufuneka ukhethe icandelo "leeseli" kwaye ucofe i-icon ye-triangle ekhuselekileyo ecaleni "Faka". Kwimenyu ye-pop-up, cofa kwi "Faka iiseli ...".
2. Okulandelayo kuvela kwifestile ngeeparameter. Ngoku kufuneka ukhethe ukhetho olufanelekileyo kwaye ucofe u "Kulungile".

Indlela 3: Ukufaka iiseli ngeendlela ezishushu

Abasebenzisi abaphambili ngakumbi beenkqubo ezahlukeneyo zenkqubo, besebenzisa indibaniselwano yezitshixo ezenzelwe le njongo. I-Excel ikwanayo nenani lemidibaniso ephambili evumela ukuba wenze inani elikhulu lokusebenza okanye usebenzise izixhobo ezahlukeneyo. Olu luhlu lubandakanya ukudityaniswa kwamaqhosha okufaka iiseli ezongezelelweyo.

1. Ekuqaleni kubalulekile ukuba uye kwindawo apho icwangciswe khona iselfowuni (Uluhlu). Emva koko, i "Ctrl + Shift + =" amaqhosha acinezelwa kwangoko.

Ukufakela iselfowuni kunye nezitshixo ezishushu

1. Iwindows eqhelekileyo ivela kunye nokufaka. Okulandelayo, kufuneka ukhethe ukhetho olufunayo. Emva koko, iya kusala kuphela ukuba ucofe u "Kulungile" ukubonakala kwiiseli ezongezelelweyo.

Ukuqukumbela

Inqaku lahlalutya zonke iintlobo zokufaka iindlela zokufaka iiseli ezongezelelweyo kwitafile ye-Excel. Ngamnye wabadwelisiweyo uyafana nakwabanye ngendlela yokubamba kwaye isiphumo sifezekisiwe, kodwa zeziphi iindlela zokusebenzisa kufuneka zigqibe kwelokuba kuthathwe isigqibo malunga neemeko. Eyona ndlela ilula yelona libonelela ngokusetyenziswa kwezitshixo ezenzelwe ukufaka, kodwa enyanisweni, uninzi lwabasebenzisi bahlala besebenzisa imenyu yemeko.

Umyalezo Wongeza njani iiseli ukuze uphumelele. Iindlela ezi-3 zokongeza iiseli kwitafile ye-Excel zibonakale kuqala kwitekhnoloji yolwazi.