Excel keys eshushu (ubeko)

shortcuts Keyboard ukunceda abasebenzisi ukuba lula nokukhawulezisa nomsebenzi wayo ngokubuyisela i ezinye izenzo omnye. Oku kubaluleke nangakumbi ukuba iinkqubo ofisi Microsoft Excel, nto leyo eyenzelwe ukuba kube lula umntu ukuba asebenze zonke iintlobo data. Cinga ethandwa ezimfutshane yezitshixo, esebenzayo iinguqulelo ezininzi lesi sicelo (ukusuka Excel 2003 ukuya Excel 2013). Kwaye Excel 2003 Akukho imixube ukusebenza oneribhoni - panel unikezelo olukhawulezayo, ekubeni eli thuba kwafika kuphela Excel 2007 kwaye iyafumaneka kwiinguqulelo kamva. Ezinye zezi ukuhlanganiswa ukuba ukusebenza kunye neenguqulelo localized phantsi izicelo ingqalelo.

Uninzi Excel keys ethandwayo ashushu

Ngokucinezela ezi imidibaniso yamaqhosha ukwenza imisebenzi esisiseko ye-nkqubo. Xa echaza ezimfutshane yezitshixo "+" phawu kusetyenziswa ukubonisa akhuphe, emi ekunene nasekhohlo uphawu i "+". imidibaniso yamaqhosha ziboniswe kwindawo yegama, ukuze icinezelwe ngexesha elinye, amaqhosha omnye, ababini, abathathu okanye abane kwi yezitshixo. Ngokuqhelekileyo, enye, ezimbini okanye ezintathu kuzo inkonzo ezingundoqo - Ctrl, Shift okanye Alt. Kumele press yokuqala uze ubambe phantsi karhulumente, cinezela omnye (yesithathu okanye eyesine) evuthayo udityaniso-maqhosha.

kuyimfuneko ukwenza ifayile entsha, cinezela (Ctrl + N). Ukuya kwi menu, okanye ukuvula ifayile - (Ctrl + O), ugcine ifayile - (Ctrl + S), «Gcina njenge» - (F12), Print - (Ctrl + P). Vala ifayile - (Ctrl + F4). Ezisebenzayo: rhoxisa - (Ctrl + Z), phinda - (Ctrl + Y). Qala ukudala formula - (=). Vala ifayile - (Alt + F4). Yongeza Column - (Ctrl + Shift + plus key). Faka sheet entsha - (Shift + F11). Challenge indalo itafile yababini - (Ctrl + L). Fihla okubhaliweyo kwi iseli - (Alt + Faka).

imisebenzi navigation

Ukuze enze inguquko inikezela izitshixo ashushu ezilandelayo Excel. Tsalela window "Hamba» - (Ctrl + G). Tsiba: ukuba iseli ekunene - (Tab); ukuba iseli ngasekhohlo - (Shift + Tab); omnye screen - (PageUp); phantsi enye screen - (PageDown); gqabi elandelayo - (Ctrl + PageDown); kwimakhishithi elidlulileyo - (Ctrl + PageUp); kule ndawo data: kwiseli lokuqala - (Ctrl + Home); ngokuba lokunithumelela le iseli - (Ctrl + End); kwicala utolo yeseli lokuqala - (Ctrl + Arrow). Ukuhamba phakathi amaphepha encwadi evulekileyo - (Ctrl + F6).

ufomato lombhalo kunye kwiseli

Ukuze Ukufometha okubhaliweyo kwi iseli (indawo) ekhethiweyo wasebenzisa Excel izitshixo ashushu zidweliswe ngezantsi. Kwezi iindibaniso sebenzisa iqhosha Ctrl kunye nezinye izitshixo acaciswe kweli candelwana, kwindawo yegama.

Font: ngqindilili - (B), i-umgca ngaphantsi - (U), akekeleyo - (3), krwela - (5). Imenyu: Utshintsho Font - (Shift + F), ubungakanani bomgca - (Shift + P). Faka imida mark - (Shift + 7). Susa yonke imida - (Shift + umgca).

Tsalela up menu: ufomato lweseli - (1), ukhetho lwamagama - (Shift + F), khetha ubungakanani befonti - (Shift + P). Cwangcisa i fomati: inzala - (Shift + 5), ngamafuphi - (Shift + 1), ixesha - (Alt + 2), umhla - (Alt + 3), imali - (Alt + 4), kwanaleyo - (Shift + 4) , eqhelekileyo (ukususa ukufomathwa) - (Shift + #).

IUkhetho, ukuhlela umbhalo

Kukuphuhlisa: lonke iphepha - (Ctrl + A), umgca ngokupheleleyo - (Shift + ungenanto), yonke kwikholam - (Ctrl + Space), iseli uluhlu kwicala iintolo - (Shift + notolo) iseli uluhlu eziquka igqabi incwadi data - (Ctrl + Shift + 8).

umbhalo ziphawuliwe: cut (buffer endaweni yokuyidibanisa) - (Ctrl + X), Khuphela (eqhotyoshwayo) - (Ctrl + C). Cola - (+ V Ctrl). Ukucima umlinganiswa enye isalathisi: Ekhohlo (Cima), ekhohlo - (Backspace). Ukutshintsha yeseli esebenzayo - (F2). Cima ixabiso obukhoyo ngoku nathi sitshintshe iseli esebenzayo - (engenanto).

Okunye hot keys Excel

Tsalela Ukufuna ibhokisi yeteksti - (Ctrl + F), endaweni okubhaliweyo - (Ctrl + H), khetha isimbo - (Alt + '). ukudala ngokuzenzekelayo itshati kuxwebhu omtsha (F11). Tshintsha izimvo esiseleni - (Shift + F2). Calculation ezenzekelayo ekhethiweyo iiseli kwikholam - (Alt + =); ixabiso le mali lufakwa kwikholam yeseli kumqolo olandelayo ngezantsi ukhetho. Faka iseli ezikhethiweyo lwangoku: Umhla - (Ctrl + Shift +4), lo gama - (Ctrl + Shift +6). Yokuhlola - (F7).

Okulandelayo, makhe sithethe ukuzimanyanisa indlela iiseli in Excel. Hotkey, kulo mzekelo, ngelishwa, hayi umncedisi. Nangona kunjalo, kukho ezinye amaqhinga ezinokukunceda ukuphelisa le ngxaki.

i algorithm

Ukuba ufuna ukudibanisa iiseli ku Excel, kukho ezinye iingxaki. Emva lo msebenzi ubandakanya ukulahleka data kuzo zonke iiseli yahlanganiswa indawo, ngaphandle ephezulu ekhohlo. Okokuqala kufuneka ukhethe indawo iiseli eya kuhlanganiswa, cinezela iqhosha lemouse ekunene kwi ariya yokhetho, khetha umba "Iiseli Format ..." drop-down menu. "Format Iiseli" window ivela iyodwa, khetha oko kwi tab "Ukulungelelaniswa" ze uphawule "iiseli Ukuhlanganisa." Ukuze afeze intsebenziswano mbuzo jikelele ibonelelwe Excel zebhodi yezitshixo.

Hlanganisa iiseli lula ukuba enze nge iqhosha olukhethekileyo "Hlanganisa & Centre", nto leyo ifumaneka kwi menu "Ekhaya". Ukuba awunalo ukubeka data kwi ziko, nqakraza kwi ileyibhile ukuya ekunene iqhosha, kwaye yotsalo-phantsi imenu, khetha into efanelekileyo. Ngendlela, ukuba usoloko usebenzisa lo msebenzi, kungcono ukubeka iqhosha iThulbha yoFikelelo. Ukuze ugcine idata esuka kwezinye iiseli sidibanisa kummandla ngaphandle ephezulu ekhohlo, kufuneka ukutshintshela imixholo kwenye indawo okanye ukubongeza iseli esebenzisa boko kukopa (okanye ukusika) nocolo.

Ezinye iindlela kunokwenzeka ukudibanisa iiseli, ngaphandle nakuphina ukulahleka kwengcaciso enxulumene nokusetyenziswa imacros zesikocan enokufunyanwa, umzekelo, ukuba asebenze kumaqonga Excel. Le yokusebenza Umgaqo we-macro iyafana ngesandla, kodwa ngokukhawuleza kwaye lula kumsebenzisi.

Indlela ukufaka umqolo nge hotkey

Kudla kukho imfuneko kwi Excel lokusebenza ufake umqolo. keys Hot esetyenzisiweyo kulo msebenzi - Ctrl + uphawu lokudibanisa. Kufuneka bonisa umqolo apho kuyimfuneko ukufaka entsha. Le ukhetho nga kwenziwa izitshixo eshushu (Shift + Space) okanye ngokunqakraza i ekhohlo iqhosha le mouse kwi amanani kumqolo ahambelanayo ngasekhohlo, xa isalathisi utshintsho ukuba imilo notolo. Ukuba umgca asikhethwanga, lo hotkey (Ctrl + uphawu lokudibanisa) kukhokelela inkangeleko "Le Ukongeza iiseli" le menu ahambelanayo enikeza ukukhetha ukuba kuzakulungisa: iiseli shift phantsi okanye ekunene, umqolo okanye umhlathi.

Excel hotkey "Cima umgca» - (Ctrl uphawu + thabatha). Ukucima umqolo kuyimfuneko kukukhetha kunye nokwenza cofa eli udityaniso-maqhosha.

Xa ucofa ucinezela iqhosha Alt kwi bar yesicelo menu ebonisa ezinomnyinyivane izitshixo ashushu esilingana izinto menu. Oku icaciswe kulo mzobo. Ukuze iinguqulelo yenkqubo eqalela Excel 2007.

Ncamathelisa ekhethekileyo Excel

Idla kuyimfuneko ukufaka kulo iseli amanani kuphela, okanye ifomula kuphela. Ukuze wenze oku, kukho ukhetho Excel - Cola eziZodwa. Hotkey kule - (Ctrl + Alt + V).

"Cola Special" ibhokisi yencoko yababini ivula xa ucinezela ezi izitshixo. Ifumaneka ukuba nje phambi kokuba oku kwenziwe njengokukhuphela okanye ukusika into, imixholo yeseli, okubhaliweyo kwi zekhasi okanye kwenye program. Kwi window, ukhethe indawo yakho; ifomula, iifomati ixabiso, inqaku okanye enye yeenketho ecetywayo.

Ngenxa yoko, ukufunda okubhalwe kule nqaku, oyifundileyo, yintoni na le izitshixo ezishushu Excel kwaye uwasebenzisa njani. Kakade ke, eli nqaku ayichazi zonke ezihamba ezikhoyo. Ukuze isifundo epheleleyo ngakumbi nesihloko kufuneka uthathe ithuba uncwadi ekhethekileyo.