Indlela Yokugubungela Umbhalo kunye neFomula kwiMitha yeMitha kwi-Excel

01 ngo 01

Indlela Yokugubungela Umbhalo kunye neifomula kwi-Excel

Ukubhaliweyo Umbhalo kunye neifomula kwi-Excel. © Ted French

I-Excel yombhalo wesicatshulwa se- Excel yinto ephathekayo yokufometha evumela ukuba ulawule ukubheka kweelayibhile kunye nezihloko kwiphepha lokusebenzela.

Uninzi lwexesha lisetyenziswe njengenye indlela yokwandisa iikholomu zephepha lokusebenzela ukwenza izihloko ezide zibonakala, ukugoba umbhalo kukuvumela ukuba ufake umbhalo kwiindlela ezininzi kwiiselinye enye.

Isetyenziso sesibini sokubhaliweyo kwimbosi ukuphula iifomula ezide zihamba ngokubhekiselele kwimigca emininzi kwiseli apho ifom ekhoyo okanye kwi- formula ibha ngenjongo yokubenza kube lula ukufunda nokuhlela.

Izindlela ezifihliweyo

Njengakwiinkqubo zonke zeMicrosoft, kukho indlela engaphezulu kweyodwa yokufeza umsebenzi. Le miyalelo ihlanganisa iindlela ezimbini zokufaka isicatshulwa kwisisele enye.

Ukusebenzisa iiNqakrazo zeeNqakrazo zokuPhonsa umbhalo

Inhlanganisela yentloko yeendlela ezincinci zokubhala umbhalo kwi-Excel yinto enye eye isetyenziselwa ukufaka ikhefu lokuhlukana (ngamanye amaxesha kuthiwa yimbuyekezo elula ) kwi-Microsoft Word:

Alt + Ngena

Umzekelo: Bopha Umbhalo njengoko Uthayipha

  1. Cofa kwiseli apho ufuna ukuba umbhalo ube khona
  2. Thayipha umgca wokuqala wobhaliweyo
  3. Cinezela kwaye ubambe iqhosha lase Alt kwikhibhodi
  4. Cinezela kwaye ukhulule ukhiye wokungena kwikhibhodi ngaphandle kokukhipha ikhiye ye- Alt
  5. Ukukhululwa kwe- Alt key
  6. Inqaku lokufakela kufuneka lihambe kumgca ongaphantsi kwitheyibhile engenayo
  7. Thayipha umgca wesibini wombhalo
  8. Ukuba unqwenela ukungena kweminye imigca yesicatshulwa, qhubeka ucofa u- Alt + Enter ekupheleni komgca ngamnye
  9. Xa zonke izibhalo zifakiwe, cindezela ukhiye wokungena kwikhibhodi okanye nqakraza nge mouse ukuze uye kwenye enye iseli

Umzekelo: Fakela Umbhalo Oye Wawubhalwe Ngaphambili

  1. Cofa kwiseli equkethe isicatshulwa ukuba ihlanganiswe kumigqa emininzi
  2. Cinezela iqhosha le- F2 kwikhibhodi okanye nqakraza kabini kwiseli ukubeka i-Excel kwimodi yokuHlela .
  3. Cofa nge mouse yomnxeba okanye sebenzisa izitshixo zitshixo kwikhibhodi ukuhambisa isikhombisi kwindawo apho umgca uya kuqhekeka
  4. Cinezela kwaye ubambe iqhosha lase Alt kwikhibhodi
  5. Cinezela kwaye ukhulule ukhiye wokungena kwikhibhodi ngaphandle kokukhipha ikhiye ye- Alt
  6. Ukukhululwa kwe- Alt key
  7. Umgca wesicatshulwa kufuneka uhlukaniswe kumigca emibini kwiseli
  8. Ukuphula umgca omnye wesicatshulwa okwesihlandlo sesibini, hamba kwindawo entsha uze uphinde uphinde ufunde amanqanaba amane ukuya ku-6 ngaphezulu
  9. Xa ugqibile, cofa iqhosha lokungena kwikhibhodi okanye nqakraza kwelinye iseli ukuphuma kwimodi yokuHlela.

Ukusebenzisa iiNqamlezo zeNqamlezo zokuPhula iifomula

I- Alt + Ngenisa inqamaniso yentloko yokuncinci ingasetyenziselwa ukugoba okanye ukuphula iifomula ezinde kwiimizila ezininzi kwifom yefomula.

Amanyathelo okulandelwayo afana nalawo achazwe ngasentla - kuxhomekeke ekubeni ingaba ifom ekhoyo kwiseli yomsebenzi okanye isaphukileyo kwimigca emininzi njengoko ingenisiwe.

Ukuphula iifomula ezikhoyo kumigqa emininzi kunokwenziwa kwiseli yangoku okanye kwibha yefomula ngaphezulu kwephepha lokusebenzela.

Ukuba ibha yefom isetyenziswe, inokwandiswa ukubonisa yonke imigca kwifom njengoko kuboniswe kumfanekiso ongentla.

Ukusebenzisa i-Ribbon Option ukugoba Umbhalo

  1. Cofa kwiiseli okanye iiseli eziqulethe itekisi ukuba zifakwe kwiimizila ezininzi
  2. Cofa kwiTebhu yeKhaya .
  3. Cofa kwiComputer Inkinobho kwi-Ribbon.
  4. Iibhile eziseli selini mazibe zibonakala ngokubini ngokubhaliweyo kunye neetekisi ezigqityiweyo kumigca emibini okanye imigca ngaphandle kokuhlaselwa kwiiseli eziseduze.