IMicrosoft ivavanya ukuphumeza into entsha Excel. Ukuqanjwa kubizwa ngokuba Iseli yokuGqalisela yenziwe ukuqaqambisa umqolo kunye nomhlathi weseli xa ikhethiwe. Kule posi siza kukuxelela yonke into esiyaziyo ukuza kuthi ga ngoku malunga nalo msebenzi: indlela yokusebenzisa iFocus Cell ukujonga iiseli kwi-Excel ngempumelelo.
Olu phawu luza kuncedo lwe abo basebenzisi banyanzelwa ukuba bajongane ne-spreadsheets ezibanzi, kunye nemigca emide kakhulu kunye neekholamu kunye nedatha engapheliyo. Ngokucacileyo, kwimisebenzi elula eneebhodi ezincinci, iFocus Cell ayizukubonelela nantoni na ekhethekileyo.
Kungabonakala ngathi yinto encinci, kodwa inyaniso kukuba umqolo kunye nekholomu zigxininiswe xa ukhetha iseli yenza umsebenzi wokulandela imigca kunye neekholamu xa ufunda idatha ithwaleke ngakumbi. Kusithintela ekugxininiseni amehlo ethu, kunye nokubonakala kokukhathala kunye nokungabikho kokugxila xa sihleli phambi kwesikrini ixesha elithile.
Ukuza kuthi ga ngoku, abasebenzisi be-Excel basebenzise indlela engaqhelekanga "yokujolisa" kumqolo kunye nekholamu yeseli enikiweyo. Iqhinga yayikukusebenzisa indibaniselwano engundoqo Shift+Ngena ukuhamba phakathi kweeseli ezikhethiweyo.
Enye indlela yokwenza kukuba "bamisa" imiqolo yokuqala kunye neekholamu isuka e "Jonga" ithebhu kwiribhoni yesixhobo. Oku kusivumela ukuba sizilungise kwaye singazilahleki, nokuba sihamba sisiya kulo naliphi na icala sisebenzisa ikhesa okanye iintolo kwikhibhodi (jonga umfanekiso ongentla).
Excel Focus Cell Function
Ixesha Jolise Inokuguqulelwa ngokuthi "lungisa", "center" okanye "concentrate". Ngokwenyani, leyo yinjongo kanye yalo msebenzi omtsha weMicrosoft Excel. Ngokucofa kwiseli ethile, ngokuzenzekelayo umqolo wayo kunye nekholamu iya kuphawulwa ngombala okhethwe ngumsebenzisi ngaphambili. Isiphumo siboniswa ngolu hlobo:
Ingaba olu phawu lwenziwa lusebenze njani? Konke ekufuneka siyenzile kukuya kwiribhoni yesixhobo, phezulu kwesikrini kwaye ucofe i "Jonga" ithebhu. Emva koko kufuneka ukhethe ifayile “Bonisa” iqela kwaye apho nqakraza kukhetho "Iseli yokuGqalisela", ezakukuvumela ukuba ukhethe umbala esifuna ukuqaqambisa ngawo imiqolo kunye nemigca ehambelana neseli.
Iqhinga elihle lokufikelela kumyalelo ngokulula kwaye ngokukhawuleza ayongeze kwibar yofikelelo olukhawulezayo, apho siya kuhlala sikhona ngokucofa kanye. Xa sele silapho, sinokuvula kwaye sivale umsebenzi weFocus Cell ngokulula ngokukhetha i icon ehambelanayo, ekwikona ephezulu ngasekhohlo yefestile ye-Excel.
Kufuneka ikhankanywe ukuba Lo msebenzi uya kwenziwa ngokuzenzekelayo xa sisebenzisa iFumana (Ctrl+F) kunye noBuyisela (Ctrl+H) izixhobo. Oku kuyakwenza kube lula kumsebenzisi ukubeka iliso nokulawula iseli esebenzayo ngelixa ubrawuza iziphumo ezahlukeneyo zophendlo.
Kunoko, umsebenzi Ayinakwenziwa isebenze ukuba sikhethiles i "Iiphaneli zokuMkhenkcela" okanye "Iiphaneli zokwahlula" izixhobo ngaphakathi kwi-spreadsheet. Yenye yeentsilelo ezincinci ezichongwe ngabasebenzisi abakwaziyo ukuvavanya iSeli ekuJoliswe kuyo kwinkqubo yovavanyo kwaye, ngokucacileyo, iMicrosoft sele isebenza kuyo. Okufanelekileyo kuya kuba kukwazi ukusebenzisa yonke le misebenzi ngaxeshanye. Ngale ndlela, ulawulo olukhulu ngakumbi lokufundwa komsebenzisi kwedatha luya kufezekiswa.
Iya kufumaneka nini?
Okwangoku Umsebenzi we-Excel's Focus Cell unokuvavanywa kuphela ngamalungu ayinxalenye yenkqubo yeMicrosoft Insiders. Ngokukodwa ngakumbi, kuphela abo basebenzisa inguqulo 2410 (Yakha 18118.20000) okanye kamva kwisitishi seBeta.
Nje ukuba inqanaba lovavanyo ligqitywe kwaye iinkcukacha zokugqibela zenziwe, iMicrosoft iceba ukukhupha inqaku kubathengi bayo beWindows PC kwaye, kamva, nakwabo bafikelela kwi-Excel ngeMac okanye kwinguqulelo yasimahla ye-Intanethi. Awukwazi ukuthetha ngenye umhla othile, kodwa sinokucinga ukuba ngumbandela weenyanga. Mhlawumbi iiveki.
Ezinye iimpawu zeExcel eziluncedo
Okokugqibela, ukuba sithetha ngokulawula iiseli ze-Excel (ezona zinto zisisiseko sespredishithi), inkqubo isinika yona imisebenzi emininzi ebalulekileyo, ngaphaya kweFocus Cell. Ezi zezinye zezona zibalulekileyo ekufuneka nawuphi na umsebenzisi afunde ukuzisebenzisa ukuze afumane okuninzi kwisicelo:
- Uzibala njani iiseli ezinombhalo kwi-Excel
- Uzahlula njani iiseli kwi-Excel: isikhokelo senyathelo nenyathelo
- Indlela yokudibanisa iiseli ezimbini okanye ngaphezulu kwi-Excel
- Lawula ukutshixa iiseli kwi-Excel kwaye ugcine umsebenzi wakho ukhuselekile
Kwaye ukuba usafuna ukufunda ukusebenzisa i-Excel ngcono kakhulu, siyakukhuthaza ukuba uqhubeke ufunda izithuba malunga nendlela esebenza ngayo le nkqubo esiyipapasha kwiiNdaba zeWindows.