Ungayikhuphela njani iiseli kwi-Excel

Anonim

Ukwahlula iiseli kwi-Microsoft Excel

Enye yezinto ezinomdla neziluncedo kukukwazi ukudibanisa iiseli ezimbini okanye ngaphezulu zibe nye. Eli nqaku lingakumbi kwimfuno xa kusenziwa iintloko kunye neethebhu zetafile. Nangona, ngamanye amaxesha isetyenziswa nangaphakathi kwetafile. Kwangelo xesha, kuya kufuneka uqaphele ukuba xa kusenziwa izinto ezihlanganisiweyo, eminye imisebenzi iyayeka ukusebenza ngokuchanekileyo, umzekelo, ukuhlelwa. Kananjalo zininzi ezinye izizathu, ngenxa yomsebenzisi oza kucombulula kuwo iiseli ukwakha ubume betafile ngendlela eyahlukileyo. Simazise iindlela ezinokwenziwa.

Ukunqunyulwa kweeseli

Inkqubo yokukhokelwa iiseli kukungaguquleli kumanyano. Ke ngoko, ngamagama alula, ukuyenza, kufuneka urhoxise isenzo esenziwe xa simanyene. Eyona nto iphambili kukuqonda ukuba kuphela iseli equlethe ezinye izinto ezidityanisiweyo ngaphambili zingangeniswa.

Indlela yoku-1: Ifestile yokufomatha

Uninzi lwabasebenzisi lusetyenziselwa ukuvelisa inkqubo yokudibanisa kwifestile yokufomatha ngenguqu ukuya kwimenyu yemeko. Ke ngoko, kwaye bayacofa nabo.

  1. Khetha iseli edibeneyo. Cofa ekunene Cofa ukuze ubize imenyu yemeko. Uluhlu oluvulekileyo, khetha le ndlela "yefowuni ...". Endaweni yezi zenzo, emva kokukhetha into, unokufowuna nje ukudityaniswa kwamaqhosha kwiKhodi ye-Ctrl + 1.
  2. Inguqu kwifomathi yeselfowuni kwimenyu yomxholo kwiMicrosoft Excel

  3. Emva koko, iwindows ekufomeli yedatha isunguliwe. Yiya kwi-"yolungelelwaniso" ithebhu. Kwi-"boobing" Useto lwebhlokithi, susa ibhokisi yokujonga kwi-parameter "yokulala. Ukufaka inyathelo, cofa kwiqhosha "Kulungile" emazantsi efestile.

Ifestile yokufomatha kwiMicrosoft Excel

Emva kwale nto ilula, iseli apho kuya kwenziwa khona ukusebenza kuya kwahlulahlulwahlulwa ngokwabantu bezinto zayo. Kwangelo xesha, ukuba idatha ibigcinwe kuyo, emva koko iya kuba kwindawo ephezulu yekhohlo.

Iseli yahlulahlulwe ibe yiMicrosoft Excel

Isifundo: Iitafile zokufomatha kwi-Excel

Indlela 2: Iqhosha kwiRibbon

Kodwa ngokukhawuleza kakhulu kwaye kulula, ngokoqobo kunqakrazo olunye, unokwahlula izinto ngeqhosha kwi-ribbon.

  1. Njengakwindlela yangaphambili, okokuqala, kufuneka ubalaselisa iseli edibeneyo. Ke kwiQela lesixhobo "solungelelwaniso" kwi-tepe, sicofa kwi "Direquene kunye nendawo kwiZiko".
  2. Ukuncamathisela iiseli ngeqhosha kwi-ribbon kwi-Microsoft Excel

  3. Kule meko, ngaphandle kwegama, emva kokucinezela iqhosha, inyathelo elibuyiselweyo liza kwenzeka: izinto ziya kuncitshiswa.

Ngokwenyani, zonke iindlela zokukhetha ezikhutshiwe iiseli kwaye ziphela. Njengoko ubona, zimbini kuphela: ifestile yokufomatha kunye neqhosha kwiteyiphu. Kodwa ezi ndlela zanele ukuze kuziphendule ngokukhawuleza kwaye zilula kule nkqubo ingentla.

Funda ngokugqithisileyo