Excel kī wera (pokatata papapātuhi)

pokatata papapātuhi āwhina i ngā kaiwhakamahi ki te faaohie, ka tere ake ona mahi mā te whakakapi etahi mahi kotahi. He ara atu nui mo te hōtaka tari rite Microsoft Excel, hoahoa nei ki te whakahaere i te tangata ki te mahi ki katoa o ngā raraunga tenei. A feruri i te rongonui pokatata papapātuhi, e hāngai ana i roto i putanga maha o tenei tono (i Excel 2003 ki Excel 2013). A i roto i Excel 2003 he kahore ngā ki te mahi ki te rīpene - rōpū uru tere, mai haere mai tenei faingamālie anake i roto i Excel 2007 me he wātea i roto i te putanga i muri mai. e kore ai ētahi o ēnei ngā mahi ki ngā putanga paetata raro tono whakaaro.

Te nuinga o taviri wera Excel rongonui

Mā te pēhi i enei kautaha matua ki te mahi i ngā mahi taketake o te hōtaka. A, no te whakaahua pokatata papapātuhi whakamahia "+" tohu te ki te whakaatu i te atahanga, e tu ana i runga i te matau, ka mahue o te "+" tohu. kia aki ngā matua e tohua i roto i te ', kia wā kotahi, kotahi, e rua, e toru ranei, ara wha pātene i runga i te papapātuhi. Ko te tikanga, kia kotahi, e rua ranei e toru o ratou he mahi matua - Mana, Shift Alt ranei. me ratou press tuatahi, me te pupuri iho kāwanatanga, pēhi tetahi (te toru ranei te wha) o te pahekotanga pātuhi wera.

Ko reira e tika ana ki te hanga i tētahi kōnae hōu, pēhi (Ctrl + N). Hei haere ki te tahua, ranei te whakatuwhera i te kōnae - (Ctrl + e), whakaora i te kōnae - (Ctrl + S), «Save rite» - (F12), Tā - (Ctrl + P). Katia te kōnae - (Ctrl + F4). Active: whakakore - (Ctrl + Z), faahiti - (Ctrl + Y). Tīmata hanga o te tātai - (=). Katia te kōnae - (Alt + F4). Tāpiri Tīwae - (Ctrl + Shift + me kī). Kōkuhu whārangi hou - (Shift + F11). Wero kōrero hanga tepu - (Ctrl + L). Huna te kuputuhi i roto i te pūtau - (Alt + Tāuru).

ngā mahi whakatere

Hei te mahi faafariuraa whakarato te mau taviri wera e whai ake nei Excel. Karangatia matapihi "Haere» - (Ctrl + G). Peke: ki te pūtau ki te matau - (Ripa); ki te pūtau i runga i te maui - (Shift + Ripa); ake kotahi mata - (PageUp); iho kotahi mata - (PageDown); te rau i muri - (Ctrl + PageDown); i runga i te whārangi o mua - (Ctrl + PageUp); i roto i te rohe raraunga: i te pūtau tuatahi - (Ctrl + Home); hoki karapotia te pūtau - (Ctrl + End); i roto i te ahunga o te pere ki te pūtau tuatahi - (Ctrl + Pere). Hei nuku i waenganui i nga rau o te pukapuka tuwhera - (Ctrl + F6).

whakahōputu kuputuhi me te pūtau

Hei whakahōputu te kuputuhi i roto i te pūtau (wāhi) tīpakohia whakamahia Excel taviri wera e rārangi ana i raro. I roto i enei kautaha whakamahi i te kī Ctrl me te tahi atu mau taviri i tohua i roto i tenei wahanga tekiona, i roto i te reu.

Momotuhi: maia - (B), te tāraro - (U), tītaha - (3), tāroto - (5). Tahua: huringa Momotuhi - (Shift + F), te rahi momotuhi - (Shift + P). Hoatu rohe tohu - (Shift + 7). Tangohia rohe katoa - (Shift + Tāraro).

Karangatia ake tahua: hōputu pūtau - (1), kōwhiringa momotuhi - (Shift + F), tīpako i te rahi momotuhi - (Shift + P). Tautuhi hōputu: moni - (Shift + 5), te tau - (Shift + 1), te wā - (Alt + 2), te rā - (Alt + 3), te moni - (Alt + 4), te utu - (Shift + 4) , noa (ki te tango hōputu) - (Shift + #).

kuputuhi te kōwhiri me te whakatika

Miramira: te whārangi katoa - (Ctrl + A), te rārangi tonu - (Shift + pātea), te tīwae katoa - (Ctrl + Space), he ngohi pūtau i roto i te ahunga o pere - (Shift + pere) ngohi pūtau ngā rau pukapuka raraunga - (Ctrl + Shift + 8).

kuputuhi miramira: tarai (te moka) - (Ctrl + X), Tārua (ki te Papatopenga) - (Ctrl + C). Whakapiri - (Ctrl + V). Hei muku kotahi huru i te pehu: Left (Mukua), te maui - (Hokimuri). Te huri i te pūtau hohe - (F2). Mukua te uara o nāianei, me te huri i te pūtau hohe - (pātea).

Ētahi atu mau taviri wera Excel

Karangatia kuputuhi pouaka Rapu - (Ctrl + F), whakakapi i te kuputuhi - (Ctrl + H), tīpako i te kāhua - (Alt + '). waihanga aunoatia te tūtohi i runga i te rau hou (F11). Hurihia te kōrero ki te pūtau - (Shift + F2). Tātaitanga TapekeAunoa tīpakohia ngā pūtau i roto i te tīwae - (Alt + =); hoatu uara o te moni i roto i te tīwae o te pūtau i roto i te rarangi i muri i raro i te kōwhiringa. Kōkuhu i te pūtau o nāianei tīpakohia: rā - (Ctrl + Shift +4), ia - (Ctrl + Shift +6). Spellcheck - (F7).

Next, kia kōrero a pā ana ki te pehea, ki te hanumi pūtau i roto i Excel. Hotkey, i roto i tenei take, kāore, e kore te kaiāwhina. Heoi, i reira e te tahi mau tinihanga e taea te āwhina te hiki koe etahi o te raruraru.

te hātepe

Ki te hiahia koe ki te hanumi pūtau ki Excel, i reira e te tahi mau fifi. I muri i tenei mahi tā te ngaronga o ngā raraunga i roto i ngā pūtau katoa i ngā wāhi, ki te kahore hoki te maui o runga. Tuatahi whai koe ki te tīpako i te rohe o ngā pūtau ki kia ngā, pēhi te pātene kiore matau i runga i te rohe kōwhiringa, tīpako i te tūemi "Pūtau Hōputu ..." tahua taka-iho. "Hōputu Pūtau" matapihi puta i tahaki, tīpako i te reira i roto i te ripa "Tīaroaro" ka tohu "pūtau E whakahanumi ana." Hei kawe i te mahi i roto i te pātai e kore e tikanga whakaratohia i roto i te pokatata papapātuhi Excel.

Hanumia ngā pūtau māmā ki te mahi ki te pātene motuhake "hanumi & Center", kei nei i roto i te tahua "Home". Ki te kore koe e whai ki te tuu i te raraunga i roto i te pokapū, pāwhiri i runga i te tapanga ki te matau o te pātene, me i roto i te tahuaroto taka-iho, tīpako i te tūemi e tika ana. E te ara, ki te maha te whakamahi koe i tenei mahi, he reira pai ki te waiho i te pātene i runga i te Paeutauta Uru Tere. Hei whakaora raraunga mai i ētahi atu pūtau fakatahai te rohe anake te maui o runga, whai koe ki te whakawhiti i te tirotiro ki tētahi atu wāhi tāpiri ratou ki te pūtau i te tikanga o te tāruatanga (ranei tapahi) me whakapiri ranei.

Ētahi atu ara taea ki ngā pūtau, hāunga i tetahi mate o ngā raraunga e pā ana ki te whakamahi o ngā tonotono e taea te kitea, mo te tauira, ki te mahi i roto i ngā wānanga Excel. Ko te parau tumu whakahaere o te tonotono, ko te taua rite ā, engari he tere me iti kitea ki te kaiwhakamahi.

Me pēhea te ki te kōkuhu i te rarangi ki te hotkeys

E mea pinepine i reira he he hiahia i roto i te pepamahi Excel ki te kōkuhu i te rarangi. mau taviri Hot whakamahia hoki tenei mahi - Ctrl + me tohu. kia whakanui te reira i te rarangi i runga i te mea e tika ana ki te kōkuhu i tētahi tetahi hou. Ka taea e tēnei kōwhiringa e whakamana e te mau taviri wera (Shift + Space) mā te pāwhiri i te pātene kiore maui i roto i te tau haupae hāngai i runga i te maui, ina e taui te pehu ki te āhua pere ranei. Ki te te kore tīpakohia te raina, te hotkey (Ctrl + me tohu) arata'i ki te ahua o "Te tua o te pūtau" o te tahua e hāngai ana e tuku he kōwhiringa o te mea ki te whakaū i: ngā pūtau neke iho tika, haupae tīwae ranei ranei.

Excel hotkey "Muku raina» - (Ctrl tohu + tango). Hei muku i te rarangi ko reira e tika ana ki te tīpako me te mahia pēhi i tenei pahekotanga pātuhi.

A, no te pēhi koe te kī Alt i runga i te pae tahua tono whakaatu tīwhiri o taviri wera ōrite ki ngā tūemi tahua. fakatātaa'i tēnei i roto i te ahua. Wātea mō ngā putanga o te hōtaka timata ki Excel 2007.

Whakapiri motuhake i roto i te Excel

E mea pinepine te mea e tika ana ki te kōkuhu ki te pūtau uara anake, tātai anake ranei. Ki te mahi i tenei, i reira ko te kōwhiringa ki Excel - Whakapiri Motuhake. Hotkeys mō tenei - (Ctrl + Alt + V).

"Whakapiri Motuhake" oroko pouaka kōrero ina pēhi koe enei mau taviri. Ko reira e wātea ana ki te i meatia i mua i tika tenei te tārua tapahi he ahanoa, nga tirotiro o te pūtau, te kuputuhi i runga i te raumahi ranei i roto i tētahi atu hōtaka ranei. I roto i te matapihi, tīpako koutou tauwāhi: tātai, ngā hōputu uara, tuhipoka ranei te tahi atu o te kōwhiringa whakaarohia.

Ko te kupu, te tai'oraa i te tirotiro o tenei tuhinga, kua ako koe, he aha e nga taviri wera Excel me pehea ki te whakamahi i ratou. O te akoranga, e kore e te tuhinga whakaahua nga ngā ngā katoa. Hoki te ako oti atu o te kaupapa kia tango painga o te tuhinga motuhake.