Indlela yokongeza kunye nokucima iifolo kunye neikholomu kwi-Excel

Njengakwiinkqubo zonke zeMicrosoft, kukho indlela engaphezulu kweyodwa yokufeza umsebenzi. Le miyalelo ihlanganisa iindlela ezimbini zokungeza nokucima imigqa kunye neikholomu kwiphepha lokusebenzela lase Excel:

Yongeza Iifolo kwi-Excel Worksheet

Yongeza iiRows kwi-Excel Worksheet usebenzisa Imenyu Yemixholo. © Ted French

Xa iikholomu kunye nemigca equlethe idatha isusiwe, idatha isusiwe kanye. Ezi lahleko ziyakuchukumisa amafomula kunye neetshathi ezibhekiselele kwingcaciso kwiimikholomu ezisusiweyo kunye nemigqa.

Ukuba ususa ngephutha iikholomu okanye imigqa equlethe idatha, sebenzisa isici sokurhoxisa kwi-ribbon okanye le nqakrazo yebhobhodi ukuze ufumane idatha yakho.

Yongeza iiRows usebenzisa i-Shortcut Keys

Inhlanganisela ebalulekileyo yebhobhobhodi yokongeza imigqa kwiphepha lokusebenzela yile:

Ctrl + Shift + "+" (kunye nomqondiso)

Qaphela : Ukuba unayo ikhibhodi enePlay Pad ukuya ngasekunene kwekhibhodi eqhelekileyo, ungasebenzisa uphawu + apho ngaphandle kwesihluthulelo seShift. Intsebenziswano ebalulekileyo iya kuba nje:

Ctrl + "+" (kunye nomqondiso) Shift + Spacebar

I-Excel iya kufaka umqolo omtsha ngaphaya komqolo okhethiweyo.

Ukongeza Idibaniso elilodwa usebenzisa i-Keyboard Shortcut

  1. Cofa kwiseli kumqolo apho ufuna uluhlu olutsha lufakwe khona.
  2. Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhulula ikhiye yeShift .
  4. Umqolo wonke kufuneka ukhethwe.
  5. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
  6. Cinezela kwaye ukhulule "+" ukhiye ngaphandle kokukhulula iifayile zeCtrl kunye neShift .
  7. Umqolo omtsha kufuneka udibaniswe ngaphezu komqolo okhethiweyo.

Ukongeza iiRandi eziNinzi zeeNdawo usebenzisa i-Keyboard Shortcut

Utshela i-Excel ukuba uninzi kangakanani imigqa emitsha esondeleyo ofuna ukuyongeza kwiphepha lokusebenzela ngokukhetha inombolo efanayo yemigca ekhoyo.

Ukuba ufuna ukufaka imigqa emibini emitsha, khetha iimilo ezimbini ezikhoyo apho ufuna ukuba ezitsha zibe khona. Ukuba ufuna imigangatho emithathu, khetha ezintathu ezikhoyo.

Ukongeza iMigangatho emithathu kwiNcwadana yokuSebenza

  1. Cofa kwiseli kumqolo apho ufuna imigca emitsha yongezwa.
  2. Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhulula ikhiye yeShift .
  4. Umqolo wonke kufuneka ukhethwe.
  5. Qhubeka ubambe iqhosha leShift .
  6. Cinezela kwaye ukhulule ukhiye ophezulu ophezulu ukukhetha imigangatho emibini eyongezelelweyo.
  7. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
  8. Cinezela kwaye ukhulule "+" ukhiye ngaphandle kokukhulula iifayile zeCtrl kunye neShift.
  9. Imiqolo emithathu kufuneka idibene ngaphezu kweendlela ezikhethiweyo.

Yongeza iirelo usebenzisa Imenyu Yemixholo

Ikhetho kwimenyu yenkalo - okanye imenyu yokunqakraza kwesokudla - eya kusetyenziselwa ukongeza imigqa kwiphepha lokusebenzela lifake.

Njengokuba kukho indlela yebhobhodi ngasentla, ngaphambi kokungeza umgca, utshela i-Excel apho ufuna ukuba entsha ifakwe ngokukhetha ummelwane wayo.

Indlela elula yokongeza imigqa usebenzisa imenyu yomongo kukuba ukhethe umgca opheleleyo ngokuchofoza kwinqununu yomqolo .

Ukongeza Igalelo elilodwa kwiphepha lokusebenzela

  1. Cofa kwi-header yomgca womqolo apho ufuna ukuba umqolo omtsha unyule ukukhetha umqolo wonke.
  2. Nqakraza ngakwesokudla kumqolo okhethiweyo ukuvula imenyu yomongo.
  3. Khetha Faka kwimenyu.
  4. Umqolo omtsha kufuneka udibaniswe ngaphezu komqolo okhethiweyo.

Ukongeza iiRows eziNinzi zeeNdawo

Kwakhona, utshela i-Excel ukuba imitha emitsha ofuna ukuyongeza kwiphepha lokusebenzela ngokukhetha inombolo efanayo yemigca ekhoyo.

Ukongeza iMigangatho emithathu kwiNcwadana yokuSebenza

  1. Kwisihloko esisezantsi, nqakraza kwaye udibanise ne-pointer ye mouse ukugqamisa imiqolo emithathu apho ufuna ukuba imigqa emitsha ifakwe.
  2. Chofoza ngokuchanekileyo kwimigca ekhethiweyo.
  3. Khetha Faka kwimenyu.
  4. Imiqolo emithathu kufuneka idibene ngaphezu kweendlela ezikhethiweyo.

Cima iifolo kwi-Excel Worksheet

Susa iiRhafu eziBodwa kwi-Excel Worksheet. © Ted French

Inhlanganisela ebalulekileyo yebhobhobhodi yokususa imigca esuka kwiphepha lokusebenzela yile:

Ctrl + "-" (minus uphawu)

Indlela elula yokucima umqolo kukuba ukhethe umqolo wonke ukuba ususwe. Oku kunokwenziwa kwakhona usebenzisa i-shortcut keyboard:

Shift + Spacebar

Ukucima iLowula elilodwa usebenzisa i-Keyboard Shortcut

  1. Cofa kwiseli kumqolo ukuze ususwe.
  2. Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhulula ikhiye yeShift .
  4. Umqolo wonke kufuneka ukhethwe.
  5. Ukukhupha ikhiye yeShift .
  6. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  7. Cinezela kwaye ukhulule " - " ukhiye ngaphandle kokukhulula ikhiye ye Ctrl .
  8. Umqolo okhethiweyo kufuneka ususwe.

Ukucima iiRows eziNje ngokusebenzisa iCodeboard Shortcut

Ukukhetha imigqa ecaleni kwiphepha lokusebenzela liya kukuvumela ukuba uzicime zonke ngokukhawuleza. Ukukhetha imigqa ecaleni kunokukwenziwa usebenzisa izitshixo zitshixo kwikhibhodi emva komqolo wokuqala.

Ukususa iifolo ezintathu kwiShishini lokuSebenza

  1. Cofa kwiseli kumqolo kumgca wezantsi weqela lemiqolo ekufuneka isuswe.
  2. Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhipha ikhiye yeShift .
  4. Umqolo wonke kufuneka ukhethwe.
  5. Qhubeka ubambe iqhosha leShift .
  6. Cinezela kwaye ukhulule ukhiye ophezulu ophezulu ukukhetha imigangatho emibini eyongezelelweyo.
  7. Ukukhupha ikhiye yeShift .
  8. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  9. Cinezela kwaye ukhulule " - " ukhiye ngaphandle kokukhulula ikhiye ye Ctrl .
  10. Le miqolo emithathu ekhethiweyo kufuneka isuswe.

Cima Iifolo usebenzisa Imenyu Yemixholo

Inketho kwimenyu yenkalo - okanye imenyu yokunqakraza imenyu - eya kusetyenziswa ukususa imigqa esuka kwiphepha lokusebenzela iCime.

Indlela elula yokucima imigqa usebenzisa imenyu yomongo kukuba ukhethe umgca opheleleyo ngokuchofoza kwi-header yomqolo.

Ukucima umda omnye kwiShishini lokuSebenza

  1. Cofa kwi-header yomqolo woluhlu ukuze ususwe.
  2. Ukucofa ngakwesokudla kumqolo okhethiweyo ukuvula imenyu yomongo.
  3. Khetha Khetha ukususa kwimenyu.
  4. Umqolo okhethiweyo kufuneka ususwe.

Ukucima iiRows eziManyeneyo

Kwakhona, iimilo ezininzi ezikufutshane zingasuswa ngexesha elifanayo ukuba zonke zikhethiweyo

Ukususa iifolo ezintathu kwiShishini lokuSebenza

Kwisihloko esisezantsi, nqakraza kwaye udibanise nge-pointer ye mouse ukugqamisa imiqolo emithathu ecaleni

  1. Chofoza ngakwesokudla kwimigca ekhethiweyo.
  2. Khetha Khetha ukususa kwimenyu.
  3. Le miqolo emithathu ekhethiweyo kufuneka isuswe.

Ukususa iirhafu ezahlukileyo

Njengoko kuboniswe kumfanekiso ongentla, ukwahlukana, okanye imigca engasondelene nayo ingasuswa ngexesha elifanayo ngokukhetha okokuqala ngeCtrl iqhosha kunye nemouse.

Ukukhetha iirhafu ezahlukileyo

  1. Cofa kwi-header yomqolo woluhlu lokuqala ukuze ususwe.
  2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  3. Cofa kwimigca eyongezelelweyo kwinqununu yomqolo ukuze ukhethe.
  4. Chofoza ngakwesokudla kwimigca ekhethiweyo.
  5. Khetha Khetha ukususa kwimenyu.
  6. Imigqa ekhethiweyo kufuneka isuswe.

Yongeza iikholomu kwi-Excel Worksheet

Yongeza iikholomu ezininzi kwi-Excel Worksheet kunye neMenyu Yemixholo. © Ted French

Inhlanganisela yentloko yebhobhodi yokongeza iikholomu kwiphepha lokusebenzela lifana nokongeza imigqa:

Ctrl + Shift + "+" (kunye nomqondiso)

Qaphela: Ukuba unayo ikhibhodi enePlay Pad ukuya ngasekunene kwekhibhodi eqhelekileyo, ungasebenzisa uphawu + apho ngaphandle kwesihluthulelo seShift. Intlangano ebalulekileyo iphela ngoCtrl + "+".

Ctrl + Ibha yendawo

I-Excel iya kufaka ikholomu entsha ngakwesobunxele kwikholam ekhethiweyo.

Ukongeza Ikholam yoLunye usebenzisa iCodeboard Shortcut

  1. Cofa kwiseli kwikholam apho ufuna ukuba ikholomu entsha ifakwe.
  2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhulula ikhiye ye Ctrl .
  4. Ikhefu lonke kufuneka likhethwe.
  5. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
  6. Cinezela kwaye ukhulule " + " ngaphandle kokukhulula iifayile zeCtrl kunye neShift .
  7. Ikholam entsha kufuneka ifakwe kwikhohlo kwikholam ekhethiweyo.

Ukongeza iiKholamu eziNinzi zeeNkcukacha usebenzisa iCodeboard Shortcut

Utshela i-Excel ukuba zininzi iikholomu ezikufutshane ofuna ukuzongeza kwiphepha lokusebenzela ngokukhetha inombolo efanayo yamakholomu akhoyo.

Ukuba ufuna ukufaka ezimbini iikholomu ezintsha, khetha iikholomu ezimbini ezikhoyo apho ufuna ukuba ezitsha zibe khona. Ukuba ufuna ezintathu iikholomu ezintsha, khetha ezintathu iikholomu ezikhoyo.

Ukongeza iikholam ezintsha ezintathu kwi-Worksheet

  1. Cofa kwiseli kwikholam apho ufuna khona iikholomu ezintsha.
  2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhulula ikhiye ye Ctrl .
  4. Ikhefu lonke kufuneka likhethwe.
  5. Ukukhulula ikhiye ye Ctrl .
  6. Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
  7. Cinezela kwaye ukhulule ukhiye wokunene lwesibini ukukhetha iikholomu ezimbini ezongezelelweyo.
  8. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
  9. Cinezela kwaye ukhulule " + " ngaphandle kokukhulula iifayile zeCtrl kunye neShift .
  10. Iikholam ezintsha ezintathu kufuneka zongezwe kwicala lasekhohlo ezikhethiweyo.

Yongeza iikholomu usebenzisa Imenyu Yemixholo

Ikhetho kwimenyu yenkalo - okanye imenyu yokunqakraza kwesokudla - eya kusetyenziselwa ukongeza iikholomu kwiphepha lokusebenzela lifake.

Njengokuba kukho indlela yebhobhodi ngasentla, ngaphambi kokungeza ikholomu, uxelela i-Excel apho ufuna ukuba entsha ifakwe ngokukhetha ummelwane wayo.

Indlela elula yokongeza iikholomu usebenzisa imenyu yomongo kukuba ukhethe lonke ikholomu ngokuchofoza kwintloko yekholomu.

Ukongeza Ikholam yoLwazi kwiShishini lokuSebenza

  1. Cofa kwi-header yekholomu yekholomu apho ufuna ukuba ikholomu entsha yongezwe ukukhetha yonke ikholomu.
  2. Nqakraza ngakwesokudla kwikholam ekhethiweyo ukuvula imenyu yomongo.
  3. Khetha Faka kwimenyu.
  4. Ikholamu entsha kufuneka ifakwe kwikholam ekhethiweyo.

Ukongeza iikholomu ezininzi ezisezantsi

Kwakhona njengemigca, uxelela i-Excel ukuba zininzi iikholomu ofuna ukuzongeza kwiphepha lokusebenzela ngokukhetha inombolo efanayo yamakholomu akhoyo.

Ukongeza iikholam ezintsha ezintathu kwi-Worksheet

  1. Kwi-header yomhlathi, nqakraza kwaye uhudule kunye nekhompi ye mouse ukugqamisa iikholomu ezintathu apho ufuna khona iikholomu ezintsha.
  2. Cofa iqhosha kwiikholamu ezikhethiweyo.
  3. Khetha Faka kwimenyu.
  4. Iikholam ezintsha ezintathu kufuneka zongezwe kwicala lasekhohlo leikholamu ezikhethiweyo.

Cima iikholomu kwi-Excel Worksheet

Cima iikholomu zomntu ngamnye kwi-Excel Worksheet. © Ted French

Inhlanganisela yentloko yebhobhokhi yokususa iikholomu kwiphepha lokusebenzela yile:

Ctrl + "-" (minus uphawu)

Indlela elula yokucima ikholomu kukuba ukhethe yonke ikholomu ukuba isuswe. Oku kunokwenziwa kwakhona usebenzisa i-shortcut keyboard:

Ctrl + Ibha yendawo

Ukususa Ikholam eYodwa usebenzisa iCodeboard Shortcut

  1. Cofa kwiseli kwikholam ukuba isuswe.
  2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhulula ikhiye yeShift .
  4. Ikhefu lonke kufuneka likhethwe.
  5. Qhubeka ubamba iqhosha le Ctrl kwikhibhodi.
  6. Cinezela kwaye ukhulule " - " ukhiye ngaphandle kokukhulula ikhiye ye Ctrl .
  7. Ikholam ekhethiweyo kufuneka isuswe.

Ukususa iikholam eziqhelekileyo usebenzisa i-Keyboard Shortcut

Ukukhetha iikholam ezikufutshane kwiphepha lokusebenzela liya kukuvumela ukuba uzicime zonke ngokukhawuleza. Ukukhetha iikholam ezikufutshane kunokwenziwa usebenzisa izitshixo zitshixo kwikhibhodi emva kokuba ikholomu yokuqala ikhethiweyo.

Ukususa iikholam ezintathu ukusuka kwiWebhu lokusebenzela

  1. Cofa kwiseli kwikholam ekupheleni kwezantsi kweqela leikholomu ukuze lisuswe.
  2. Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
  3. Cinezela kwaye ukhulule ibha yendawo ngaphandle kokukhipha ikhiye yeShift .
  4. Ikhefu lonke kufuneka likhethwe.
  5. Qhubeka ubambe iqhosha leShift .
  6. Cinezela kwaye ukhulule ikhibhodi ye- Up arrow kabini ukukhetha iikholomu ezimbini ezongezelelweyo.
  7. Ukukhupha ikhiye yeShift .
  8. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  9. Cinezela kwaye ukhulule " - " ukhiye ngaphandle kokukhulula ikhiye ye Ctrl .
  10. Iikholamu ezintathu ezikhethiweyo kufuneka zisuswe.

Cima iikholomu usebenzisa Imenyu Yemixholo

Inketho kwimenyu yenkalo - okanye imenyu yokunqakraza imenyu - eya kusetyenziswa ukususa iikholomu kwiphepha lokusebenzela lisusa.

Indlela elula yokucima iikholomu usebenzisa imenyu yomongo kukuba ukhethe lonke ikholomu ngokuchofoza kwisihloko sekholomu.

Ukususa iHolomu elilodwa kwiShishini lokuSebenza

  1. Cofa kwintloko yekholomu yekholomu ukuba isuswe.
  2. Nqakraza ngakwesokudla kwikholam ekhethiweyo ukuvula imenyu yomongo.
  3. Khetha Khetha ukususa kwimenyu.
  4. Ikholam ekhethiweyo kufuneka isuswe.

Ukususa iikholomu ezininzi eziqhelekileyo

Kwakhona, iikholomu ezikufutshane zingasuswa ngexesha elifanayo ukuba zonke zikhethiweyo.

Ukususa iikholam ezintathu ukusuka kwiWebhu lokusebenzela

  1. Kwisihloko somqolo, nqakraza kwaye udibanise nge-mouse pointer ukugqamisa iintsika ezintathu ezikufutshane.
  2. Cofa iqhosha kwiikholamu ezikhethiweyo.
  3. Khetha Khetha ukususa kwimenyu.
  4. Iikholamu ezintathu ezikhethiweyo kufuneka zisuswe.

Ukususa iikholomu ezahlukileyo

Njengoko kuboniswe kumfanekiso ongentla, ukwahlula, okanye kumakholomu angasondlwanga kungasuswa ngexesha elifanayo ngokukhetha kuqala ngocwangciso lweCtrl kunye ne mouse.

Ukukhetha iikholam ehlukileyo

  1. Cofa kwintloko yekholomu yekholomu yokuqala ukuba isuswe.
  2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
  3. Cofa kwimigca eyongeziweyo kwintloko yekholomu ukuyikhetha.
  4. Chofoza ngakwesokudla kwiikholomu ezikhethiweyo.
  5. Khetha Khetha ukususa kwimenyu.
  6. Iikholomu ezikhethiweyo kufuneka zisuswe.