Ungayisusa njani iphepha kwi-Excel

Anonim

Susa iphepha kwiMicrosoft Excel

Njengoko uyazi, kwincwadi i-Excel likho ithuba lokwenza amaphepha aliqela. Ukongeza, iisetingi ezingapheliyo ziyaboniswa ukuze uxwebhu xa usenza izinto ezintathu. Kodwa, kukho iimeko apho abasebenzisi kufuneka basuse amaphepha athile ngedatha okanye engenanto ukuze bangaphazamisi nabo. Makhe sibone ukuba le nto inokwenziwa njani ngeendlela ezahlukeneyo.

Inkqubo yokukhupha

Inkqubo ye-Excel inesakhono sokususa zombini iphepha kunye neliqela. Cinga ngendlela eyenziwe ngayo.

Indlela yoku-1: Ukususwa kwimenyu yomxholo

Eyona ndlela ilula nenomdla yokuqhuba le nkqubo kukuthatha ithuba lokuba ibonelele ngemenyu yemeko. Senza iqhosha lemouse lasekunene emgceni, elingasafuneki. Kuluhlu lweemeko ezivunyiweyo, khetha "Cima" into.

Susa iphepha kwiMicrosoft Excel

Emva kwento, iphepha liyanyamalala kuluhlu lwezinto ezingentla kwebar yendawo.

Indlela 2: Ukususa izixhobo zeThemo

Kuyenzeka ukuba ususe uphawu oluyimfuneko usebenzisa izixhobo zibekwe kwiteyiphu.

  1. Yiya ephepheni esifuna ukususa.
  2. Utshintsho kuLuhlu kwiMicrosoft Excel

  3. Ngelixa "ikhaya" ithebhu, cofa kwiqhosha kwi-"Cima" i-tepi kwi "Izixhobo zeseli". Kwimenyu ebonakala, cofa kwi icon kwifom ye-triangle kufutshane ne "Cima". Kwimenyu evulekileyo, yeka ukhetho lwakho kwindawo ethi "Cima igqabi".

Susa iphepha ngeteyiphu kwiMicrosoft Excel

Iphepha elisebenzayo liya kususwa kwangoko.

Indlela 3: Ukucima izinto ezininzi

Ngokwenene, inkqubo yokucima uqobo iyafana nakwiindlela ezimbini ezichaziweyo. Kuphela kukususa amaphepha aliqela ngaphambi kokuba aqhubeke nenkqubo ethe ngqo, kuya kufuneka sibanike.

  1. Ukwabela izinto ezikweyenzelwe, zibambe iqhosha le-Shift. Emva koko nqakraza kwinto yokuqala, kwaye emva koko i-over, icinezelwe iqhosha.
  2. Ukukhetha amaphepha alandelayo kwiMicrosoft Excel

  3. Ukuba ezo zinto ufuna ukususa kunye, kodwa usasazeke, ke kule meko kufuneka ucinezele iqhosha le-CTRL. Emva koko cofa kwigama ngalinye lamashiti aya kufuneka asuswe.

Khetha iimakhishithi kwiMicrosoft Excel

Emva kokuba izinto zigxininisiwe, kuyimfuneko ukusebenzisa enye yeendlela ezimbini eziza kususwa, ezixutyushwe apha ngasentla.

Isifundo: Ukongeza iphepha kwi

Njengoko ubona, susa amaphepha angafanelekanga kwiprogram ye-Excel ulula kakhulu. Ukuba uyafuna, kunokwenzeka ukuba ususe izinto ezininzi ngexesha elinye.

Funda ngokugqithisileyo