Excel okhiye esishisayo (zekhibhodi)

Ukusebenzisa ikhibhodi ukusiza abasebenzisi lula futhi ukusheshisa umsebenzi walo esikhundleni ezinye izenzo eyodwa. Lokhu kubaluleke kakhulu ngenxa izinhlelo ehhovisi njenge-Microsoft Excel, esiklanyelwe lula umuntu ukusebenza zonke izinhlobo idatha. Cabanga ethandwa izinqamuleli zekhibhodi, osebenzayo ezinguqulweni eziningi lolu hlelo (kusuka Excel 2003 kuya Excel 2013). Futhi Excel 2003 Awekho inhlanganisela ukusebenza iribhoni - esheshayo ukufinyelela iphaneli, kusukela leli thuba weza kuphela Excel 2007 itholakala izinguqulo kamuva. Ezinye zalezi inhlanganisela angeke sisebenze izinguqulo ehunyushelwe ngaphansi izicelo ukucabangela.

ethandwa Excel okhiye Iningi esishisayo

Ngokucindezela lezi inhlanganisela yokhiye ukwenza imisebenzi eyisisekelo ohlelweni. Lapho echaza zekhibhodi "+" uphawu isetshenziswa ukubonisa ukudluliselwa, emi ngakwesokudla washiya oluthi "+". inhlanganisela yokhiye akhonjiswa kubakaki, kungenzeka sicindezelwe kanyekanye, kunye, kubili, ezintathu noma ezine izinkinobho ikhibhodi. Ngokuvamile, umuntu, ababili noma abathathu babo bangabantu inkonzo ukhiye - Ctrl, Shift noma Alt. Kumelwe cindezela kuqala bese ubamba isimo, cindezela omunye (lesithathu noma lesine) inhlanganisela ashisayo ukhiye.

kubalulekile ukwakha ifayela elisha, cindezela (Ctrl N). Ukuze iya kumenyu, noma uvule ifayela - (Ctrl O), ukugcina ifayela - (Ctrl S), «Gcina njengoba» - (F12), Phrinta - (Ctrl P). Vala ifayela - (Ctrl F4). Active: khansela - (Ctrl Z), ukuphinda - (Ctrl Y). Qala ekudaleni formula - (=). Vala ifayela - (Alt F4). Engeza Ikholomu - (Ctrl + Shift + plus ukhiye). Faka ishidi elisha - (u-Shift + F11). Inselele ekudalweni ithebula lengxoxo - (Ctrl L). Fihla umbhalo kuseli - (Alt Faka).

navigation imisebenzi

Ukuze enze ukuguqulwa inikeza okhiye ezilandelayo ashisayo Excel. Call iwindi "Hamba» - (Ctrl G). Jump: kuya esitokisini ilungelo - (Tab); yeseli ngakwesokunxele - (u-Shift + Tab); up esibukweni eyodwa - (PageUp); phansi kwesikrini eyodwa - (PageDown); iqabunga elilandelayo - (Ctrl PageDown); eshidini langaphambilini - (Ctrl PageUp); endaweni idatha: kusukela cell kokuqala - (Ctrl Ikhaya); ngoba befaka iseli - (Ctrl Ukuphela); bebheke umcibisholo yeseli lokuqala - (Ctrl Umcibisholo). Ukuhamba phakathi amashidi yencwadi evulekile - (Ctrl F6).

Ukumiswa kwemibhalo kanye cell

Ukuze ukufometha umbhalo elikhethiwe cell (endaweni) esetshenziswa Excel okhiye ashisayo ukuthi tibalwe lapha ngentasi. Kulezi inhlanganisela Ukusebenzisa ukhiye ikhilokhi ye- Ctrl plus abanye okhiye elicacisiwe yalesi sigatshana, kubakaki.

Wefonti: ngokugqamile - (B), le kugcizelelwa - (U), i-ithalikhi - (3), ukuhlikihla - (5). Imenyu: ushintsho Ifonti - (u-Shift + F), usayizi wefonti - (u-Shift + P). Faka uphawu imingcele - (Shift + 7). Susa yonke imingcele - (Shift + Thalela).

Shayela i imenyu: iseli ukufomatha - (1), ukukhethwa wefonti - (u-Shift + F), ukhethe usayizi wefonti - (u-Shift + P). Setha ifomethi: isithakazelo - (u-Shift + 5), ezinombolo - (Shift + 1), isikhathi - (Alt 2), usuku - (Alt 3), ukheshi - (Alt 4), lwemali - (Shift + 4) , ezivamile (ukususa ukufomatha) - (u-Shift + #).

Ukukhetha nokuhlela umbhalo

Gqamisa: lonke ishidi - (Ctrl A), emgqeni ngokugcwele - (u-Shift + nalutho), lonke ikholomu - (Ctrl + Space), afanayo iseli kokuqondisa imicibisholo - (u-Shift + umcibisholo) cell afanayo ehlanganisa ncwadi idatha leaf - (Ctrl + Shift + 8).

Umbhalo ogqanyisiwe: cut (sesikhashana) - (Ctrl X), Kopisha (ebhodini lokunamathisela) - (Ctrl + C). Namathisela - (Ctrl + V). Ukususa uhlamvu olulodwa ukusuka isikhombisi: Kwesokunxele (Susa), ngakwesokunxele - (Isikhala). Ukushintsha iseli esebenzayo - (F2). Susa Inani lamanje futhi ushintshe iseli esebenzayo - (blank).

Okunye okhiye ashisayo Excel

Call Ukucinga ibhokisi lombhalo - (Ctrl F), esikhundleni umbhalo - (Ctrl H), khetha isitayela - (Alt '). Dala ngokuzenzakalelayo ishadi ku ishidi elisha (F11). Shintsha amazwana yeseli - (u-Shift + F2). Ukubalwa Kuyazihlanganisela ukhethe amaseli kukholamu - (Alt =); ukubaluleka isamba efakwa ohlwini we iseli emgqeni olandelayo phansi kokhetho. Faka iseli ekhethiwe yamanje: Usuku - (Ctrl Shift +4), kuyilapho - (Ctrl Shift +6). Ukuhlola ukupela - (F7).

Ngokulandelayo, ake sixoxe indlela ukuhlanganisa amaseli e-Excel. Hotkey, kulesi simo, ngeshwa, hhayi umsizi. Nokho, zikhona ezinye tricks ezingakusiza ukuphungula ezinye inkinga.

I-algorithm

Uma ufuna ukuhlanganisa amaseli ku-Excel, kukhona ubunzima obuthile. Ngemva lo msebenzi sihilela ukulahleka kwedatha zonke amaseli Indawo ehlangene, ngaphandle phezulu kwesokunxele. Okokuqala kufanele ukhethe indawo lamaseli ukuba kuhlanganiswe, cindezela kwesokudla inkinobho yegundane endaweni Ukukhetha, ukhethe into "Ifomethi Amaseli ..." imenyu edonsela phansi. "Ifomethi Amaseli" iwindi livela lodwa, sikhethe ithebhu "Ukuhambisana" futhi uphawu "amaseli Ukuhlanganisa." Ukuze afeze ukuhlinzwa okukhulunywa is hhayi ngokuvamile enikeziwe Excel izinqamuleli zekhibhodi.

Hlanganisa amaseli kulula ukwenza nge inkinobho ekhethekile "Hlanganisa & Centre", esemgwaqweni imenyu "Ekhaya". Uma ungenalo ukubeka idatha phakathi nendawo, chofoza ilebula kuya kwesokudla inkinobho, futhi olwehlayo menyu engaphansi, ukhethe into efanele. By endleleni, uma uvame ukuyisebenzisa lo msebenzi, kungcono ukubeka inkinobho iThulibha Yongeno Olusheshayo. Ukugcina idatha evela kwamanye amangqamuzana ihlanganisa esifundeni ngaphandle phezulu kwesokunxele, kufanele uthumele okuqukethwe kwenye indawo noma usubengeze iseli esebenzisa ukukopisha (noma ahlabayo) nokunamathisela.

Ezinye izindlela kungenzeka ukuhlanganisa amaseli, ngaphandle yimuphi ukulahleka kwedatha ezihlobene nokusetshenziswa amamakhro engatholakala, isibonelo, ukusebenza Excel izinkundla. Isimiso yokusebenza ye Macro kuyafana ngesandla, kodwa ngokushesha futhi obunganakekile umsebenzisi.

Indlela irowu nge hotkey

Ngokuvamile kunesidingo kule Excel ekhasini lokusebenza ukuze irowu. Keys hot esetshenziswa kulo msebenzi - Ctrl uphawu lokuhlanganisa. Kufanele ukugqamisa emgceni kuyo okudingekile ukufaka entsha. Lokhu Ukukhetha engenziwa by okhiye esishisayo (Shift + Space) noma ngokuchofoza inkinobho yesinxele in the angafundwa irowu izinombolo ngakwesokunxele, lapho isikhombisi izinguquko i ijamo umcibisholo. Uma umugqa akuyona ekhethiwe, hotkey (Ctrl uphawu lokuhlanganisa) kuholela ukubonakala "Ukwengeza amaseli" imenyu okuhambisanayo enikeza Kukhetsa kutsi nguyiphi ukushumeka: shift amaseli ngezansi noma kwesokudla, irowu noma ikholomu.

Excel hotkey "Susa umugqa» - (Ctrl minus). Ukususa umugqa kubalulekile ukukhetha nokwenza cindezela lokhu inhlanganiselazihlonzi.

Uma ucindezela ikhi Alt kubha isicelo imenyu ubonisa Amacebo izikhiye ashisayo elihambisana imenyu izinto. Lokhu kuboniswa figure. Iyatholakala ezinguqulweni zohlelo oqala Excel 2007.

Namathisela okukhethekile e-Excel

Ngokuvamile kubalulekile ukufaka esitokisini amagugu kuphela, noma ifomula kuphela. Ukuze wenze lokhu, kukhona ukhetho e-Excel - Namathisela okukhethekile. Hotkeys salokhu - (Ctrl + Alt + V).

"Namathisela okukhethekile" ibhokisi evuleka uma ucindezela khi. Itholakala uma nje kokuba lokhu kwenzeke ekopisha noma ukusika into, okuqukethwe cell, umbhalo eseshadini noma olunye uhlelo. Ku-window, ukhethe indawo yakho: ifomula, Inani ifomethi, inothi noma ezinye izinketho ezihlongozwayo.

Ngakho, ukufunda okuqukethwe kulesi sihloko, eniyifundile, yiziphi okhiye ashisayo Excel ne uzisebenzise kanjani. Yiqiniso, lesi sihloko alimchazi zonke inhlanganisela ekhona. Ukuze isifundo more ephelele isihloko kufanele ukusizakala izincwadi ekhethekile.