Excel zafi keys (keyboard gajerar)

Keyboard da gajerun hanyoyin taimaka masu amfani don ya rage wuya da kuma bugun up ta aiki ta maye gurbin wasu ayyuka daya. Wannan ma ya fi muhimmanci ga ofishin shirye-shirye kamar Microsoft Excel, wanda aka tsara don sauƙaƙe wani mutum ya yi aiki tare da dukan bayanai. Ka yi la'akari da m keyboard gajerun hanyoyi, m, a da yawa versions da wannan aikace-aikace (daga Excel 2003 zuwa Excel 2013). Kuma a Excel 2003 ne wani haduwa da aiki tare da kintinkiri - saurin samun panel, tun da wannan dama ya zo ne kawai a Excel 2007 kuma shi ne samuwa a baya versions. Wasu daga cikin wadannan haduwa iya aiki ba tare da sarrafa versions karkashin shawara aikace-aikace.

Mafi m Excel zafi keys

Ta latsa wadannan key haduwa don yin asali ayyuka na shirin. Lokacin da ya bayyana keyboard gajerun hanyoyin "+" alama ce da ake amfani da ya nuna wa rollover, yana tsaye a dama da hagu da alamar "+". Key haduwa ana nuna cikin baka biyu, za a iya guga man lokaci guda, daya, biyu, uku ko hudu mashiga a kan keyboard. Yawancin lokaci, daya, biyu ko uku su ne key sabis - Ctrl, Shift ko Alt. Dole ne su fara latsa ka riže žasa jihar, latsa wani (na uku ko hudu) da zafi key hade.

shi wajibi ne don haifar da wani sabon fayil, latsa (Ctrl + N). Don zuwa menu, ko bude wani fayil - (Ctrl + O), ajiye fayil - (Ctrl + S), «Ajiye kamar yadda» - (F12), Print - (Ctrl + P). Rufe fayil - (Ctrl + F4). Active: soke - (Ctrl + Z), maimaita - (Ctrl + Y). Fara samar da dabara - (=). Rufe fayil - (Alt + F4). Add Column - (Ctrl + Shift + da key). Saka sabon takardar - (Shift + F11). Challenge tebur halittar maganganu - (Ctrl + L). Ɓoye da rubutu a cikin cell - (Alt + Shigar).

kewayawa ayyukan

Don yi Abubuwan Taɗi samar da wadannan zafi keys Excel. Kira taga "Go» - (Ctrl + G). Jump: ga tantanin halitta ya dama - (Tab). to tantanin halitta a kan hagu - (Shift + Tab). up daya allo - (PageUp). saukar daya allo - (PageDown). na gaba leaf - (Ctrl + PageDown). a baya takardar - (Ctrl + PageUp). a data yanki: daga farko cell - (Ctrl + Home). domin kwasfa da cell - (Ctrl + Karshen). a cikin shugabanci na kibiya to tantanin farko - (Ctrl + Kibiya). Don matsawa tsakanin zanen gado na bude littafi - (Ctrl + F6).

Tsarin rubutu da kuma cell

Don format rubutu a cikin zaba cell (yanki) amfani da na'urar mai kwakwalwa zafi keys da aka jera a kasa. A cikin wadannan haduwa amfani da Ctrl key da sauran keys kayyade a cikin wannan karamin sashe, cikin baka biyu.

Harafi: m - (B), da ja layi a ƙarƙashinsu - (U), Italic - (3), strikethrough - (5). Menu: Font canji - (Shift + F), font size - (Shift + P). Aiwatar da maki iyakoki - (Shift + 7). Cire duk iyakokin - (Shift + Subliñada).

Kira up menu: cell Tsarin - (1), font selection - (Shift + F), zaɓi wani font size - (Shift + P). Sa format: sha'awa - (Shift + 5), na lamba - (Shift + 1), lokaci - (Alt + 2), da kwanan wata - (Alt + 3), da tsabar kudi - (Alt + 4), musayar - (Shift + 4) , kowa (cire Tsarin) - (Shift + #).

Zabi da kuma tace rubutu

Haskaka: dukan takardar - (Ctrl + A), da cikakken layi - (Shift + blank), dukan shafi - (Ctrl + Space), a cell tsararru a cikin shugabanci na kibiyoyi - (Shift + kibiya) cell tsararru hada da bayanan littafin leaf - (Ctrl + Shift + 8).

Alama rubutu: yanke (da buffer) - (Ctrl + X), Copy (ga allo mai rike takarda) - (Ctrl + C). Manna - (Ctrl + V). Don share daya hali daga siginan: Hagu (Share), hagu - (QShortcut). Canza aiki cell - (F2). Share yanzu darajar da kuma canja aiki cell - (blank).

Sauran zafi keys Excel

Kira Search akwatin rubutu - (Ctrl + F), maye gurbin rubutu - (Ctrl + H), zaɓi style - (Alt + '). Ta atomatik ƙirƙirar ginshiƙi a kan wani sabon takardar (F11). Canja comment zuwa cell - (Shift + F2). Lissafin lokuttan AutoSum zaba Kwayoyin a shafi - (Alt + =). darajar Naira Miliyan Xari da aka sa a cikin shafi na cell a gaba jere a kasa da selection. Saka zaba halin yanzu cell: kwanan wata - (Ctrl + Shift +4), yayin da - (Ctrl + Shift +6). Duba kadan daga ciki - (F7).

Next, bari mu magana game da yadda za a ci Kwayoyin a Excel. Hotkey, a wannan yanayin, da rashin alheri, ba wani mataimaki. Duk da haka, akwai wasu dabaru da za su iya taimaka maka rage wasu daga cikin matsala.

A algorithm

Idan kana so ka ci Kwayoyin to Excel, akwai wasu matsaloli. Bayan wannan aiki ya shafi asarar data a duk Kwayoyin aka hada yankin, fãce babba hagu. Na farko dole ka zabi yanki na sel da za a hade, latsa dama linzamin kwamfuta button a kan selection yanki, zaɓi abu "Format Sel ..." drop-saukar menu. "Format Sel" taga bayyana da kanta, zaɓi shi a cikin shafin "jeri" da kuma Tick "Tattara abubuwa masu kyau Kwayoyin." Don gudanar da wani aiki a tambaya ba kullum bayar a Excel keyboard gajerun hanyoyi.

Ci Kwayoyin sauki a yi tare da ta musamman button "Ci & Center", wanda aka located a cikin menu "Home". Idan ba ka da sanya bayanai a cikin cibiyar, danna kan lakabin da dama daga cikin button, da kuma a cikin drop-saukar ra'ayi da ƙaramin menu, zaɓi da ya dace abu. Af, idan kana yawan amfani da wannan aiki, shi ne mafi kyau sanya button a kan Quick Access Toolbar. Don ajiye da bayanai daga wasu Kwayoyin hadawa da yankin fãce babba hagu, dole ka canza wurin da abinda ke ciki zuwa wani wuri, ko kuma ƙara su zuwa ga cell ta wajen kwashe (ko yankan) da kuma pasting.

Sauran yiwu hanyoyin da za a hada Kwayoyin, ban da wani asarar data alaka da amfani da macros cewa za a iya samu, misali, yin aiki a Excel forums. The aiki manufa da Macro ne guda a matsayin da hannu, amma yana sauri da kuma kasa m ga mai amfani.

Yadda za a saka a jere tare da hotkeys

Sau da yawa akwai bukatar a Excel worksheet to saka a jere. Hot keys amfani don wannan aiki - Ctrl + da alama. Ya kamata haskaka da jere a kan wanda shi wajibi ne don saka sabon daya. Wannan selection za a iya yi da zafi keys (Shift + Space) ko ta danna hagu linzamin kwamfuta button a cikin daidai jere lambobi a kan hagu, a lokacin da siginan Canje-canje zuwa kibiya siffar. Idan wani layi ba zaba, da hotkey (Ctrl + da alamar) take kaiwa zuwa bayyanar "The Bugu da kari daga cikin sel" na harkar menu cewa yayi wani zabi na abin da embed: shift Kwayoyin saukar ko dama, jere ko shafi.

Excel hotkey "Share line» - (Ctrl + alamar debewa). Don share jere shi wajibi ne don zaɓar da kashe latsa wannan key hade.

A lokacin da ka latsa Alt key a kan aikace-aikace menu mashaya nuna alamu na zafi keys m zuwa menu abubuwa. An misalta wannan a cikin adadi. Don versions na shirin fara da Excel 2007.

Manna musamman a Excel

Sau da yawa shi wajibi ne don saka a cikin cell kawai dabi'u, ko kuma kawai dabara. Don yin wannan, akwai wani zaɓi don Excel - Manna Special. Hotkeys ga wannan - (Ctrl + Alt + V).

"Manna Special" maganganu akwatin yana buɗewa lokacin da ka latsa wadannan keys. Yana samuwa ne idan kafin wannan da aka yi kwafan ko yankan wani abu, da abinda ke ciki na cell, da rubutu a kan worksheet ko a wani shirin. A cikin taga, zaɓi your location: dabara, darajar Formats, bayanin kula ko wasu na samarwa zabin.

Saboda haka, karanta abinda ke ciki na wannan labarin, da ka koya, abin da suke da zafi keys Excel da kuma yadda za a yi amfani da su. Hakika, labarin bai bayyana duk data kasance haduwa. Domin a more cikakken nazari na topic kamata dauki amfani da musamman wallafe-wallafe.