Ungeza kanjani futhi ususe imigqa namakholomu ku-Excel

Njengasezinhlelo zonke ze-Microsoft, kunendlela engaphezu kweyodwa yokufeza umsebenzi. Lezi ziqondiso zihlanganisa izindlela ezimbili zokwengeza nokususa imigqa namakholomu kwiphepha lokusebenzela le-Excel:

Engeza imigqa ku-Excel Worksheet

Engeza imigqa ku-Excel Worksheet usebenzisa iMenyu Yokuqukethwe. © Ted French

Uma amakholomu nemigqa equkethe idatha isuswa, idatha isusiwe futhi. Lokhu kulahlekelwa nakho kungathinta amafomula namashadi afaka idatha emakholomu asusiwe kanye nemigqa.

Uma ususa ngephutha amakholomu noma imigqa equkethe idatha, sebenzisa isici sokuhlehlisa ku-ribbon noma lesi shintsho sekhibhodi ukuze ubuyekeze idatha yakho.

Engeza imigqa usebenzisa ama-keycut Keys

Inhlanganisela yekhibhodi yekhibhodi yokwengeza imigqa kushidi lokusebenzela yilona:

Ctrl + Shift + "+" (plus uphawu)

Qaphela : Uma unekhibhodi enombhalo we-Number Pad ngakwesokudla kwekhibhodi evamile, ungasebenzisa isibonakaliso + lapho ngaphandle kwesihluthulelo se- Shift . Inhlanganisela eyinhloko iba nje:

Ctrl + "+" (plus uphawu) Shift + Spacebar

I-Excel izofaka umugqa omusha ngaphezu komugqa okhethiwe.

Ukwengeza umugqa owodwa usebenzisa isinqamuleli sekhibhodi

  1. Chofoza kuseli emgqeni lapho ufuna khona umugqa omusha.
  2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi
  3. Cindezela bese ukhulula isikhala sendawo ngaphandle kokukhulula ukhiye we- Shift .
  4. Wonke umugqa kufanele ukhethwe.
  5. Cindezela bese ubamba izinkinobho ze- Ctrl ne-Shift ekhibhodi.
  6. Cindezela bese ukhulula ukhiye "+" ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
  7. Umugqa omusha kufanele wengezwe ngenhla ekhethiwe.

Ukwengeza Imigqa Eyengeziwe Yomhlaba usebenzisa i-Shortcut Shortcut

Utshela i-Excel ukuthi mangaki emigqeni emisha eseduzane ofuna ukuyifaka ekhasini lokusebenzela ngokukhetha inombolo efanayo yemigqa ekhona.

Uma ufuna ukufaka imigqa emibili emisha, khetha imigqa emibili ekhona lapho ufuna khona ukuthi amasha abe khona. Uma ufuna imigqa emithathu emisha, khetha imigqa emithathu ekhona.

Ukwengeza imigqa emithathu emisha kumsebenzi wokusebenzela

  1. Chofoza kuseli emgqeni lapho ufuna khona imigqa emisha.
  2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
  3. Cindezela bese ukhulula isikhala sendawo ngaphandle kokukhulula ukhiye we- Shift .
  4. Wonke umugqa kufanele ukhethwe.
  5. Qhubeka ukubamba ukhiye we- Shift .
  6. Cindezela bese ukhulula ukhiye woMcibisholo Ophezulu kabili ukukhetha imigqa emibili eyengeziwe.
  7. Cindezela bese ubamba izinkinobho ze- Ctrl ne-Shift ekhibhodi.
  8. Cindezela bese ukhulula ukhiye "+" ngaphandle kokukhipha okhiye be-Ctrl ne-Shift.
  9. Imigqa emithathu emisha kufanele ifakwe ngaphezu kwemigqa ekhethiwe.

Engeza Imigqa usebenzisa Imenyu Yokuqukethwe

Okukhethwa kukho kwimenyu yomongo - noma imenyu yokuchofoza ngakwesokudla - okuzosetshenziselwa ukwengeza imigqa kushidi lokufaka i-Insert.

Njengendlela yekhibhodi engenhla, ngaphambi kokungeza umugqa, utshela i-Excel lapho ufuna ukuthi entsha ifakwe ngokukhetha umakhelwane wayo.

Indlela elula yokwengeza imigqa esebenzisa imenyu yokuqukethwe iwukuba ukhethe wonke umugqa ngokuchofoza i- header irowu .

Ukwengeza Umugqa Owodwa KuHlelo Lokusebenza

  1. Chofoza kusihloko segqa lomugqa lapho ufuna umugqa omusha ungeze khona ukukhetha wonke umugqa.
  2. Chofoza ngakwesokudla kumugqa okhethiwe ukuvula imenyu yesimo.
  3. Khetha Faka kusuka kwimenyu.
  4. Umugqa omusha kufanele wengezwe ngenhla ekhethiwe.

Ukwengeza Imigqa Eyengeziwe Yomhlaba

Nakulokhu, utshela i-Excel ukuthi imingcele emisha ofuna ukuyifaka kushidi lokusebenzela ngokukhetha inombolo efanayo yemigqa ekhona.

Ukwengeza imigqa emithathu emisha kumsebenzi wokusebenzela

  1. Esihlokweni somugqa, chofoza bese uhudula nge-pointer yegundane ukugqamisa imigqa emithathu lapho ufuna khona imigqa emisha.
  2. Chofoza ngakwesokudla emigqeni ekhethiwe.
  3. Khetha Faka kusuka kwimenyu.
  4. Imigqa emithathu emisha kufanele ifakwe ngaphezu kwemigqa ekhethiwe.

Susa imigqa ku-Excel Worksheet

Susa imigqa yomuntu ngamunye ku-Excel Worksheet. © Ted French

Inhlanganisela yekhibhodi yekhibhodi yokususa imigqa evela kushidi lokusebenzela yilona:

I-Ctrl + "-" (isibonakaliso esincane)

Indlela elula yokususa umugqa ukukhetha wonke umugqa ukuze ususwe. Lokhu kungenziwa futhi ngokusebenzisa isinqamuleli sekhibhodi:

Shift + Spacebar

Ukususa Igalelo Lodwa ngokusebenzisa isinqamuleli sekhibhodi

  1. Chofoza kuseli emgqeni ukuze ususwe.
  2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
  3. Cindezela bese ukhulula isikhala sendawo ngaphandle kokukhulula ukhiye we- Shift .
  4. Wonke umugqa kufanele ukhethwe.
  5. Khipha ukhiye we- Shift .
  6. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  7. Cindezela bese ukhulula " - " ukhiye ngaphandle kokukhulula ukhiye we- Ctrl .
  8. Umugqa okhethiwe kufanele ususwe.

Ukususa Izabelo Eziseduze usebenzisa Isinqamuleli Sekhibhodi

Ukukhetha imigqa eseduze ekhasini lokusebenzela kuzokuvumela ukuba ususe konke ngesikhathi esisodwa. Ukukhetha imigqa eseduze kungenziwa ngokusebenzisa okhiye bomcibisholo ekhibhodi ngemuva kokukhethwa komugqa wokuqala.

Ukususa imigqa emithathu kusuka ephepheni lokusebenzela

  1. Chofoza kuseli ngokulandelana phansi ekugcineni kweqembu lemigqa ezosuswa.
  2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
  3. Cindezela bese ukhulula ibha yesikhala ngaphandle kokukhulula ukhiye we- Shift .
  4. Wonke umugqa kufanele ukhethwe.
  5. Qhubeka ukubamba ukhiye we- Shift .
  6. Cindezela bese ukhulula ukhiye woMcibisholo Ophezulu kabili ukukhetha imigqa emibili eyengeziwe.
  7. Khipha ukhiye we- Shift .
  8. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  9. Cindezela bese ukhulula " - " ukhiye ngaphandle kokukhulula ukhiye we- Ctrl .
  10. Imigqa emithathu ekhethiwe kufanele isuswe.

Susa Imigqa Usebenzisa Imenyu Yokuqukethwe

Okukhethwa kukho kwimenyu yenkomfa - noma imenyu yokuchofoza ngakwesokudla - okuzosetshenziselwa ukususa imigqa evela ephepheni lokusebenzela i-Delete.

Indlela elula yokususa imigqa usebenzisa imenyu yesimo ukukhetha yonke umugqa ngokuchofoza i-header irowu.

Ukukhipha umugqa owodwa ku-Worksheet

  1. Chofoza kusihloko segqa lomugqa ukuze ususwe.
  2. Chofoza ngakwesokudla irowu ekhethiwe ukuvula imenyu yesimo.
  3. Khetha u- Susa kusuka kwimenyu.
  4. Umugqa okhethiwe kufanele ususwe.

Ukususa imigqa eminingi ephakeme

Futhi, imigqa eminingi eseduze ingasuswa ngesikhathi esifanayo uma konke kukhethiwe

Ukususa imigqa emithathu kusuka ephepheni lokusebenzela

Esihlokweni somugqa, chofoza bese uhudula nge-mouse yokukhomba ukugqamisa imigqa emithathu eseduzane

  1. Chofoza ngakwesokudla emigqeni ekhethiwe.
  2. Khetha u- Susa kusuka kwimenyu.
  3. Imigqa emithathu ekhethiwe kufanele isuswe.

Ukususa imigqa ehlukile

Njengoba kuboniswe esithombeni ngenhla, imigqa ehlukanisiwe, noma engekho eseduze ingasuswa ngesikhathi esifanayo ngokukhetha kuqala ukhiye we- Ctrl negundane.

Ukukhetha Imigqa Ehlukile

  1. Chofoza kusihloko segqa lomugqa wokuqala ukuze ususwe.
  2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  3. Chofoza kumigqa eyengeziwe emhlokweni wekhawu ukuze ukhethe.
  4. Chofoza ngakwesokudla emigqeni ekhethiwe.
  5. Khetha u- Susa kusuka kwimenyu.
  6. Imigqa ekhethiwe kufanele isuswe.

Engeza amakholomu ku-Excel Worksheet

Engeza ama-Columns amaningi ku-Excel Worksheet ne-Imenyu Yokuqukethwe. © Ted French

Inhlanganisela yekhibhodi yekhibhodi yokwengeza amakholomu kushidi lokusebenza kufana nokwengeza imigqa:

Ctrl + Shift + "+" (plus uphawu)

Qaphela: Uma unekhibhodi enombhalo we-Number Pad ngakwesokudla kwekhibhodi evamile, ungasebenzisa isibonakaliso + lapho ngaphandle kwesihluthulelo se-Shift. Inhlanganisela eyinhloko iba Ctrl + kuphela "+" +.

Ibha ye- Ctrl +

I-Excel izofaka ikholomu entsha ngakwesokunxele kwekholomu ekhethiwe.

Ukwengeza ikholomu eyodwa kuphela usebenzisa isinqamuleli sekhibhodi

  1. Chofoza kuseli kukholomu lapho ufuna khona ikholomu entsha.
  2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  3. Cindezela bese ukhulula ibha yendawo ngaphandle kokukhulula ukhiye we- Ctrl .
  4. Yonke ikholomu kufanele ikhethwe.
  5. Cindezela bese ubamba izinkinobho ze- Ctrl ne-Shift ekhibhodi.
  6. Cindezela bese ukhulula " + " ngaphandle kokukhipha okhiye be- Ctrl ne-Shift .
  7. Ikholomu entsha kufanele ifakwe ngakwesokunxele kwekholomu ekhethiwe.

Ukwengeza Amakholomu Akhawunti Eningi usebenzisa i-Shortcut Shortcut

Utshela i-Excel ukuthi kunamakholomu amangaki amasha oseduze ofuna ukuwafaka ekhasini lokusebenzela ngokukhetha inombolo efanayo yamakholomu akhona.

Uma ufuna ukufaka amakholomu amabili amasha, khetha amakholomu amabili akhona lapho ufuna khona amasha. Uma ufuna amakholomu amathathu amasha, khetha amakholomu amathathu akhona.

Ukwengeza Amakholomu Amasha Amasha Ku-Worksheet

  1. Chofoza kuseli kukholomu lapho ufuna khona amakholomu amasha.
  2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  3. Cindezela bese ukhulula ibha yesikhala ngaphandle kokukhulula ukhiye we- Ctrl .
  4. Yonke ikholomu kufanele ikhethwe.
  5. Khipha ukhiye we- Ctrl .
  6. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
  7. Cindezela bese ukhulula ukhiye wesigcino sokunene kabili ukuze ukhethe amakholomu amabili engeziwe.
  8. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
  9. Cindezela bese ukhulula " + " ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
  10. Amakholomu amasha amathathu kumele afakwe ngakwesobunxele amakholomu akhethiwe.

Engeza Amakholomu Usebenzisa Imenyu Yokuqukethwe

Okukhethwa kukho kwimenyu yokuqukethwe - noma imenyu yokuchofoza ngakwesokudla - okuzosetshenziselwa ukwengeza amakholomu kushidi lokufaka Faka.

Njengendlela yekhibhodi engenhla, ngaphambi kokungeza ikholomu, utshela i-Excel lapho ufuna ukuthi entsha ifakwe ngokukhetha umakhelwane wayo.

Indlela elula yokwengeza amakholomu usebenzisa imenyu yenkondlo ukukhetha yonke ikholomu ngokuchofoza esihlokweni sekholomu.

Ukwengeza ikholomu eyodwa kuHlelo lokusebenzela

  1. Chofoza kusihloko sekholomu yekholomu lapho ufuna ikholomu entsha ingeziwe ukukhetha lonke ikholomu.
  2. Chofoza ngakwesokudla kukholomu ekhethiwe ukuvula imenyu yesimo.
  3. Khetha Faka kusuka kwimenyu.
  4. Ikholomu entsha kufanele ifakwe ngaphezu kwekholomu ekhethiwe.

Ukwengeza Amakholomu Ayenye Amaningi

Futhi njengemigqa, utshela i-Excel ukuthi yikuphi amakholomu amasha ofuna ukuwafaka ekhasini lokusebenzela ngokukhetha inombolo efanayo yamakholomu akhona.

Ukwengeza Amakholomu Amasha Amasha Ku-Worksheet

  1. Esihlokweni sekholomu, chofoza bese uhudula nge-pointer yegundane ukugqamisa amakholomu amathathu lapho ufuna khona amakholomu amasha.
  2. Chofoza ngakwesokudla kumakholomu akhethiwe.
  3. Khetha Faka kusuka kwimenyu.
  4. Amakholomu amasha amathathu kumele afakwe ngakwesokunxele kwamakholomu akhethiwe.

Susa amakholomu kusuka ku-Excel Worksheet

Susa Amakholomu Omuntu Ewebusuku Lokusebenza Lwe-Excel. © Ted French

Inhlanganisela yekhibhodi yekhibhodi yokususa amakholomu kusuka kwiphepha lokusebenzela yilena:

I-Ctrl + "-" (isibonakaliso esincane)

Indlela elula yokususa ikholomu ukukhetha yonke ikholomu ukuze isuswe. Lokhu kungenziwa futhi ngokusebenzisa isinqamuleli sekhibhodi:

Ibha ye- Ctrl +

Ukukhipha ikholomu eyodwa kuphela usebenzisa isinqamuleli sekhibhodi

  1. Chofoza kuseli kukholomu ukuze ususwe.
  2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  3. Cindezela bese ukhulula isikhala sendawo ngaphandle kokukhulula ukhiye we- Shift .
  4. Yonke ikholomu kufanele ikhethwe.
  5. Qhubeka ukubamba ukhiye weCtrl kukhibhodi.
  6. Cindezela bese ukhulula " - " ukhiye ngaphandle kokukhulula ukhiye we- Ctrl .
  7. Ikholomu ekhethiwe kufanele isuswe.

Ukususa Amakholomu Ayenziwe usebenzisa isinqamuleli sekhibhodi

Ukukhetha amakholomu eseduze kukhasi lokusebenzela kuzokuvumela ukuba ususe konke ngesikhathi esisodwa. Ukukhetha amakholomu eseduze kungenziwa ngokusebenzisa okhiye bomcibisholo ekhibhodi emva kokuba ikholomu yokuqala ikhethiwe.

Ukususa Amakholomu amathathu kusuka kwiphepha lokusebenzela

  1. Chofoza kuseli kukholomu ekupheleni kwesigcawu sekholomu okufanele ususwe.
  2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
  3. Cindezela bese ukhulula ibha yesikhala ngaphandle kokukhulula ukhiye we- Shift .
  4. Yonke ikholomu kufanele ikhethwe.
  5. Qhubeka ukubamba ukhiye we- Shift .
  6. Cindezela bese ukhulula ikhibhodi ye- arrow yomcibisholo phezulu kabili ukuze ukhethe amakholomu amabili engeziwe.
  7. Khipha ukhiye we- Shift .
  8. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  9. Cindezela bese ukhulula " - " ukhiye ngaphandle kokukhulula ukhiye we- Ctrl .
  10. Amakholomu amathathu akhethiwe kufanele asuswe.

Susa Amakholomu Usebenzisa Imenyu Yokuqukethwe

Okukhethwa kukho kwimenyu yomongo - noma imenyu yokuchofoza ngakwesokudla - ezosetshenziselwa ukususa amakholomu kushidi lokusebenza i-Delete.

Indlela elula yokususa amakholomu usebenzisa imenyu yenkondlo ukukhetha lonke ikholomu ngokuchofoza unhlokweni wekholomu.

Ukususa Ikholomu Yodwa Ku-Worksheet

  1. Chofoza ku-header ikholomu yekholomu ukuze ususwe.
  2. Chofoza ngakwesokudla kukholomu ekhethiwe ukuvula imenyu yesimo.
  3. Khetha u- Susa kusuka kwimenyu.
  4. Ikholomu ekhethiwe kufanele isuswe.

Ukususa Amakholomu Ayenye Amaningi

Futhi, amakholomu amaningi athile angasuswa ngesikhathi esifanayo uma ekhethiwe.

Ukususa Amakholomu amathathu kusuka kwiphepha lokusebenzela

  1. Esihlokweni sekholomu, chofoza bese uhudula nge-pointer yegundane ukugqamisa amakholomu amathathu eduze.
  2. Chofoza ngakwesokudla kumakholomu akhethiwe.
  3. Khetha u- Susa kusuka kwimenyu.
  4. Amakholomu amathathu akhethiwe kufanele asuswe.

Ukususa Amakholomu Ahlukile

Njengoba kuboniswe esithombeni ngenhla, amakholomu ahlukene noma angahambisani nawo angasuswa ngesikhathi esifanayo ngokukhetha kuqala ukhiye we- Ctrl negundane.

Ukukhetha Amakholomu Ahlukile

  1. Chofoza kusihloko sekholomu yekholomu yokuqala ukuze ususwe.
  2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
  3. Chofoza kumigqa eyengeziwe ehlokweni yekholomu ukuze ukhethe.
  4. Chofoza ngakwesokudla kumakholomu akhethiwe.
  5. Khetha u- Susa kusuka kwimenyu.
  6. Amakholomu akhethiwe kufanele asuswe.