Indlela Yokugoqa Umbhalo Namafomula Emigqeni Eminye E-Excel

01 ka 01

Indlela Yokugoqa Umbhalo Namafomula ku-Excel

Isici sombhalo we-Excel isici esenziwe kahle sokufometha esikuvumela ukuba ulawule ukubukeka kwamalebula nokufakwa kwekhasi lokusebenzela.

Isikhathi esiningi sisetshenzisiwe njengendlela ehlukile yokwandisa amakholomu wephepha lokusebenzela ukwenza izihloko ezinde zibonakale, ukugoqa umbhalo kukuvumela ukuthi ufake umbhalo emigqeni eminingi ngaphakathi kweseli elilodwa.

Ukusetshenziswa kokubili kokubhaliwe ukugubha amafomula ama-long colonial kuya emigqeni eminingi esitokisini lapho ifomula itholakala khona noma kubhalwa ifomula ngenhloso yokwenza kube lula ukufunda nokuhlela.

Izindlela Ezihlanganisiwe

Njengasezinhlelo zonke ze-Microsoft, kunendlela engaphezu kweyodwa yokufeza umsebenzi. Lezi ziqondiso zihlanganisa izindlela ezimbili zokugoqa umbhalo kuseli elilodwa:

• usebenzisa isinqamuleli sekhibhodi ukugoqa umbhalo nokugoqa amafomula
• besebenzisa i- Wrap Text inketho kuthebhu yaseKhaya yebhebhoni

Ukusebenzisa Izinqamuleli Zezinqamuleli Ukumboza Umbhalo

Inhlanganisela yokhiye wokunciphisa wokubhala umbhalo ku-Excel iyona efanayo esetshenziselwa ukufaka ukuhlukana kwelayini (ngezinye izikhathi kuthiwa ukubuyiselwa okulula ) ku-Microsoft Word:

Isibonelo: Ukugoqa Umbhalo Njengoba Uthayipha

1. Chofoza kuseli lapho ufuna khona ukuthi umbhalo utholakale
2. Thayipha umugqa wokuqala wombhalo
3. Cindezela bese ubamba ikhi Alt ekhibhodi
4. Cindezela bese ukhulula ukhiye wokungena kwikhibhodi ngaphandle kokukhipha ukhiye we- Alt
5. Khipha ukhiye we- Alt
6. Iphoyinti lokufaka kufanele lihambise emgqeni ngezansi umbhalo ovele wangena
7. Thayipha umugqa wesibili wombhalo
8. Uma ufisa ukungena imigqa engaphezu kwemibili yombhalo, qhubeka ucindezela i- Alt + Enter ekupheleni komugqa ngamunye
9. Uma wonke umbhalo usungenwe, cindezela ukhiye we- Enter ekhibhodi noma uchofoze ngegundane ukuze uye kwenye iseli

Isibonelo: Umbhalo Wokugoqa Osuvele Usubhalisiwe

1. Chofoza kuseli eliqukethe umbhalo ozofakwa emigqeni eminingi
2. Cindezela ukhiye we- F2 ekhibhodi noma chofoza kabili kuseli ukuze ubeke i-Excel ku- Hlela imodi .
3. Chofoza nge-pointer yegundane noma sebenzisa izinkinobho zemicibisholo ekhibhodi ukuhambisa isikhombisi endaweni lapho umugqa uzophulwa khona
4. Cindezela bese ubamba ikhi Alt ekhibhodi
5. Cindezela bese ukhulula ukhiye wokungena kwikhibhodi ngaphandle kokukhipha ukhiye we- Alt
6. Khipha ukhiye we- Alt
7. Umugqa wombhalo kufanele uhlukaniswe emigqeni emibili kuseli
8. Ukuphula umugqa ofanayo wombhalo okwesibili, hamba endaweni entsha bese uphinda izinyathelo 4 ukuya ku-6 ngenhla
9. Uma usuqedile, cindezela ukhiye we- Enter kwikhibhodi noma chofoza kwesinye iseli ukuphuma kwimodi Hlela.

Ukusebenzisa Izinqamuleli Zezinqamuleli Ukugoqa Amafomula

Inhlanganisela yekhibhodi ye-Alt + Faka ungasetshenziselwa ukugoqa noma ukuphula amafomula amade emigqeni eminingi emgqeni wefomula.

Izinyathelo okumele zilandelwe zifana nalabo okukhulunywe ngenhla - kuye ngokuthi ngabe ifomu selivele selikhona kuseli lomsebenzi noma liphulwa emigqeni eminingi njengoba ingenisiwe.

Ukuphula amafomu ekhona emigqeni eminingi kungenziwa esitokisini samanje noma kubha yefomula ngaphezu kwephepha lokusebenzela.

Uma ibha yefomula isetshenzisiwe, ingasulwa ukuze ibonise yonke imigqa kwifomula njengoba kuboniswe esithombeni ngenhla.

Ukusebenzisa I-Ribbon Option Ukugoqa Umbhalo

1. Chofoza kuseli noma amangqamuzana aqukethe umbhalo ukuthi uboshwe emigqeni eminingi
2. Chofoza kuthebhu yasekhaya .
3. Chofoza inkinobho Yombhalo Wombhalo ku-Ribbon.
4. Amalebuli esitokisini (ama) kufanele manje avele kokubili abonakale ngokugcwele ngombhalo ophulwe emigqeni emibili noma imigqa engenawo u-spill ngaphezu kwamaseli aseduze.