Excel inopisa makiyi (kiibhodhi yokudimbudzira)

Keyboard kunotoda Kubatsira vanozvishandisa kurerutsa uye rikurumidze basa rayo nokutsiva zvimwe zviito mumwe. Izvi zvakakosha kuti hofisi zvirongwa sezvo Microsoft Excel, iyo yakagadzirirwa aivabatsira munhu kushanda ose mashoko. Funga akakurumbira kiibhodhi kunotoda, kushanda mushanduro iyi chikumbiro (kubva Excel 2003 kusvika Excel 2013) zhinji. Uye muna Excel 2003 asina anofambidzana kushanda pamwe Ribbon - nokukurumidza kuwana panel, sezvo mukana uyu akauya chete ari Excel 2007 uye rinowanika akazotevera shanduro. Vamwe anofambidzana izvi varege kushanda vemunyika neshanduro pasi kukurukurwa zvikumbiro.

Most popular Excel inopisa makiyi

Nokutsikirira chikuru anofambidzana izvi kuita inokosha yepurogiramu mashandiro. Paaitsanangura kiibhodhi kunotoda "+" chiratidzo rinoshandiswa kuratidza rollover, amire kurutivi rworudyi uye wakasiya "+" chiratidzo. mubatanidzwa Key zvinoratidzwa muzvikomberedzo, anogona chakatsikirirwa panguva, mabhatani mumwe, vaviri, vatatu kana kunyange mana pamusoro kiibhodhi. Kazhinji, mumwe, vaviri kana vatatu vacho inokosha basa - Ctrl, Shift kana alt. Vanofanira wokudhinda wokutanga uye kuchengeta pasi mamiriro, wokudhinda mumwe (rechitatu kana kuti rechina) of inopisa anokosha pamwe.

zvakafanira kuti pave faira idzva, wokudhinda (Ctrl + N). Kuenda Muterere, kana kuvhura faira - (Ctrl + O), asi faira - (Ctrl + S), «Save se» - (F12), Print - (Ctrl + P). Ugopfiga faira - (Ctrl + F4). Active: kukanzura - (Ctrl + Z), kudzokorora - (Ctrl + Y). Tanga nokusika of nzira - (=). Ugopfiga faira - (alt + F4). Wedzerai Column - (Ctrl + Shift + ndinoiitawo anokosha). Pinza jira itsva - (Shift + F11). Challenge tafura yokusika nhaurirano - (Ctrl + L). Vanza mashoko muchitokisi - (alt + Enter).

wekushandisa akavhiyiwa

Kuti aite kutendeuka kunopa zvinotevera inopisa kiyi Excel. Dana hwindo "Go» - (Ctrl + G). Jump: kuti sero kurudyi - (Tab); kuti sero kuruboshwe - (Shift + Tab); mumwe chidzitiro - (PageUp); pasi mumwe chidzitiro - (PageDown); rinotevera shizha - (Ctrl + PageDown); pamusoro yapfuura jira - (Ctrl + PageUp); ari date nzvimbo: kubva muchitokisi kwokutanga - (Ctrl + Home); nokuti zvakapoteredza sero - (Ctrl + End); nenzira museve nechitokisi rokutanga - (Ctrl + Arrow). Kufamba pakati machira pachena bhuku - (Ctrl + F6).

Text formatting uye sero

Kuti Format mashoko ari yasarudzwa muchitokisi (nharaunda) rakashandiswa Excel makiyi inopisa kuti dziri pasi apa. In anofambidzana izvi vanoshandisa Ctrl kiyi ndinoiitawo dzimwe kiyi raanotaura subsection ichi, muzvikomberedzo.

Font: ushingi - (B), kuti dzakamakwa - (U), Italic - (3), Strikethrough - (5). Menu change Kukura - (Shift + F), Kukura kwemavara - (Shift + P). Shandisa chiratidzo miganhu - (Shift + 7). Bvisa miganhu zvose - (Shift + Underline).

Dzindodana Muterere: Sero formatting - (1), Kukura kusarudzwa - (Shift + F), sarudza Schriftgröße - (Shift + P). Set nemanyorerwo: mubereko - (Shift + 5), Numeric - (Shift + 1), nguva - (alt + 2), musi - (alt + 3), mari - (alt + 4), currency - (Shift + 4) , zvakafanana (kuti Remove formatting) - (Shift + #).

Pakusarudza fora chinyorwa

Highlight: yose jira - (Ctrl + A), zvizere mutsetse - (Shift + varara), yose mbiru - (Ctrl + Space), foni vakarongedza yakananga miseve - (Shift + museve) Sero kuko dzine date bhuku shizha - (Ctrl + Shift + 8).

Pachena chinyorwa: chekawo (the buffer) - (Ctrl + X), Copy (kuti clipboard) - (Ctrl + C). Namatidza - (Ctrl + V). Zvinomuomera kuikanganwa imwe hunhu kubva cursor: Left (Kudzima), kuruboshwe - (Backspace). Changing zvinoshingaira sero - (F2). Kudzima kuitika kukosha uye kuchinja basa sero - (amboita).

Other Hot makiyi Excel

Dana Search bhokisi chinyorwa - (Ctrl + F), kutsiva mashoko - (Ctrl + H), sarudza wokugadzira - (alt + '). Vapiwa kusika munhu chati iri jira itsva (F11). Kushandura mashoko kuti sero - (Shift + F2). Kukarukureta AutoSum yasarudzwa masero ari mbiru - (alt + =); kukosha Verengai rakaiswa mbiru sero iri chinotevera musara pazasi Kusarudza. Dzinoisa mashoko yasarudzwa muchitokisi ano: musi - (Ctrl + Shift +4), ukuwo - (Ctrl + Shift +6). Spellcheck - (F7).

Next, ngatimbotaura sei kubatanidza masero ari Excel. Hotkey, muchiitiko ichi, zvinosuwisa, kwete mubatsiri. Zvisinei, pane dzimwe emazano okunyengera anogona kukubatsira kuderedza zvimwe dambudziko.

The algorithm

Kana uchida batanidza masero kuna Excel, pane zvimwe zvinetso. Avhiyiwa ichi kunosanganisira kurasikirwa mashoko mumasero vose kubatanidzwa nzvimbo, asi yokumusoro kuruboshwe. First unofanira kusarudza nzvimbo masero kuti zvabatanidzwa achizviendesa rworudyi negonzo bhatani pamusoro kusarudzwa nzvimbo, sarudza kuti chinhu "Format Masero ..." donhwe-pasi Muterere. "Format Masero" hwindo sokuti woga, sarudza panzvimbo Tab "Alignment" uye kuratidza "masero kubatanidzwa nomumwe." Kuti aite kwomudzimu muna mubvunzo haasi kazhinji inopiwa muna Excel kiibhodhi kunotoda.

Kubatanidza masero nyore kuita chaiwo bhatani "Kubatanidza & Center", riri munzvimbo Muterere "Home". Kana usina kuisa umboo pakati, tinya Chikwata kuenda kurudyi bhatani, uye mune donhwe-pasi submenu, sarudza yakakodzera chinhu. Panzira, kana iwe dzinowanzotaura kuvhiyiwa ichi, zvakanaka woisa bhatani pamusoro Quick Access Toolbar. Kuti aponese mashoko nemamwe masero anosanganisa nharaunda kunze rokumusoro kuruboshwe, unofanira uchatamisa zviri kune imwe nzvimbo kana kuwedzera sero navo achishandisa kungatonziwo (kana nokuveza) uye pasting.

Other zvinogoneka nzira chokubatanidza masero, dzakakudzingai chero kurasikirwa nemashoko chokuita kushandisa macro anogona kuwanikwa Somuenzaniso, kushanda Excel forum. The uchishandisa nheyo makro akangofanana manually, asi ndiye nokukurumidza uye chisanyanya kuoneka kuti user.

Sei vemabhuku musara pamwe hotkeys

Kazhinji pane kudiwa muna Excel pepa kuti pinza pamusara mumwe. Hot makiyi kushandiswa oparesheni ichi - Ctrl + ndinoiitawo chiratidzo. Zvinofanira anoratidza Mutsara chiri pairi zvakafanira kuti pinza itsva. kusarudzwa Izvi zvinogona anoitwa inopisa makiyi (Shift + Space) kana nekudzvanya kuruboshwe negonzo bhatani ari runoenzanirana mutsara nhamba kuruboshwe, kana cursor Kuchinja kune nomuseve chimiro. Kana mutsetse asina kusarudzwa, kuti hotkey (Ctrl + ndinoiitawo chiratidzo) zvinotungamirira chimiro "The kusanganiswa masero" pamusoro runoenzanirana Muterere kuti anopa pakusarudza kuti Embed: kusuduruka masero pasi kana kurudyi, mutsara kana mbiru.

Excel hotkey "Kudzima mutsetse» - (Ctrl + minus sign). Zvinomuomera kuikanganwa panhurikidzwa zvakafanira kusarudza nokukuitira muchisviniro ichi chinokosha mubatanidzwa.

Kana iwe achizviendesa alt kiyi pamusoro pokushandisa Muterere bhaa anoratidza zvahungava hwakaita zvakavimbika inopisa makiyi zvakafanana Muterere zvinhu. Izvi zvinoratidzwa nemifananidzo. Available nokuti shanduro chirongwa kutanga Excel 2007.

Namatidza unokosha Excel

Kazhinji zvakakosha dzinoisa kupinda muchitokisi tsika chete, kana chete payakavakirwa. Kuti aite izvi, pane kusarudza Excel - namatidza Special. Hotkeys ichi - (Ctrl + alt + V).

"Namatidza Special" nhaurirano bhokisi anovhura kana unopfuurira kiyi idzi. Inowanika kana chete izvi zvisati zvaitika nokukopa kana kucheka chinhu, zviri muchitokisi, rugwaro pepa kana chimwe chirongwa. Pahwindo, sarudza nzvimbo yenyu: wevacheche, ukoshi zvinogona, katsamba kana zvimwe richaitirwa nzira.

Saka, kuverenga zviri nyaya ino, chawakadzidza, ndedzipi inopisa kiyi Excel uye sei kuti kuzvishandisa. Chokwadi, nyaya haritsananguri zvose zviripo mubatanidzwa. Nokuti kudzidza wenyaya zvizere vanofanira kushandisa mabhuku anokosha.