Excel otentha makiyi (kiyibodi Simungachite)

Kiyibodi yachidule kuthandiza owerenga wosalira ndi kufulumizitsa ntchito yake ndi m'malo ena chinthu chimodzi. Ichi ndi chofunika kwambiri kwa mapulogalamu ofesi monga Microsoft kupambana, limene lakonzedwa kuti magawowa munthu ntchito mitundu yonse ya deta. Taganizirani otchuka yachidule kiyibodi, applicable mu Mabaibulo ambiri a ntchito iyi (kuchokera kupambana 2003 kupambana 2013). Ndipo mu kupambana 2003 sali pamodzi ntchito ndi riboni - mwamsanga kupeza gulu, popeza mwayi uyu anabwera yekha mu kupambana 2007 ndipo amapezeka m'mabaibulo ina. Ena mwa mankhwala osakanizidwa mwina ntchito ndi Mabaibulo mukuchitika pansi ntchito kuganizira.

Mankhwala ambiri kupambana makiyi otentha

Tikamapitiriza osakanizidwa chinsinsi ntchito yaikulu ya pulogalamu. Pofotokoza njira yachidule kiyibodi "+" chizindikiro ntchito kusonyeza rollover, ataima pa dzanja lamanja ndi kumanzere kwa "+" chizindikiro. ma chinsinsi anasonyeza mu parentheses, akhoza mbamuikha imodzi, mabatani chimodzi, ziwiri, zitatu kapena zinayi pa kiyibodi. Kawirikawiri, mmodzi, awiri kapena atatu a iwo utumiki kiyi - Ctrl, Kaonedwe kapena alt. Ayenela atolankhani woyamba ndi kugwira pansi boma, atolankhani wina (wachitatu kapena wachinayi) cha kuphatikiza otentha kiyi.

ndikofunikira kuti akonze file latsopano, atolankhani (Ctrl + N). Kupita ku menyu, kapena kutsegula wapamwamba - (Ctrl + O), kupatula file - (Ctrl + S), «Save monga» - (F12), Sindikizani - (Ctrl + P). Kutseka file - (Ctrl + F4). Yogwira: kuletsa - (Ctrl + Z), kubwereza - (Ctrl + Y). Yambani kulenga za njira - (=). Kutseka file - (alt + F4). Kuwonjezera ndime - (Ctrl + Kaonedwe + kuphatikiza kiyi). Amaika latsopano pepala - (Kaonedwe + F11). Challenge chilengedwe tebulo kukambirana - (Ctrl + L). Bisani malemba selo - (alt + Lowani).

ntchito navigation

Kuchita kutembenuza amapereka zotsatirazi makiyi otentha kupambana. Itanani zenera "Pita» - (Ctrl + G). Kulumpha: kwa selo kumanja - (Tab); kuti khungu kumanzere - (Kaonedwe + Tab); mpaka chophimba limodzi - (PageUp); pansi chophimba limodzi - (PageDown); yotsatira tsamba - (Ctrl + PageDown); pa pepala yapita - (Ctrl + PageUp); m'dera deta: mukachipinda koyamba - (Ctrl + Home); kuti kamodzi selo - (Ctrl + Mapeto); motsogozedwa ndi mivi kuti selo loyamba - (Ctrl + Mivi Yanu). Kusamukira pakati pa mapepala a bukhu lotseguka - (Ctrl + F6).

Text masanjidwe ndi selo

Kwa mtundu lemba mu osankhidwa khungu (dera) ntchito kupambana makiyi otentha kuti zili m'munsimu. Mu osakanizidwa ntchito Ctrl kiyi kuphatikiza mafungulo ena mwachindunji m'gawo lino, mu parentheses.

Wosasintha: molimba - (B), ndi anasonyeza - (U), zazing'ono - (3), strikethrough - (5). Zosankha: Zilembo kusintha - (Kaonedwe + F), wosasintha kukula - (Kaonedwe + P). Ikani chizindikiro malire - (kuloza + 7). Chotsani malire onse - (kuloza + Zamzere).

Amayitana menyu: masanjidwe selo - (1), wosasintha kusankha - (Kaonedwe + F), sankhani wosasintha kukula - (Kaonedwe + P). Ikani mtundu: chidwi - (Kaonedwe + 5), ndi n'zosangalatsa kumva - (kuloza + 1), nthawi - (alt + 2), tsiku - (alt + 3), ndi ndalama - (alt + 4), kuwombola - (kuloza + 4) , matenda (kuchotsa masanjidwe) - (Kaonedwe + #).

Yosankha ndi kusintha mawu

Yosangalatsa: lonse pepala - (Ctrl + A), mzere wonse - (Kaonedwe + losalembedwapo), lonse ndime - (Ctrl + Space), khamu selo motsogozedwa mivi - (Kaonedwe + muvi) selo zosiyanasiyana kupanga tsamba deta buku - (Ctrl + Kaonedwe + 8).

Anatsindika lemba: odulidwa (cha gawo lotetezedwa) - (Ctrl + X), Koperani (kuti zomatula) - (Ctrl + C). Matani - (Ctrl + V). Kuchotsa munthu wina kuchokera cholozera za: Kumanzere (Chotsani), lamanzere - (Backspace). Kusintha yogwira selo - (F2). Chotsani phindu panopa ndi kusintha yogwira selo - (losalembedwapo).

Other otentha makiyi Excel

Itanani Search bokosi lemba - (Ctrl + F), m'malo lemba - (Ctrl + H), kusankha kalembedwe - (alt + '). kulenga basi tchati pa pepala watsopano (F11). Kusintha ndemanga kuti khungu - (Kaonedwe + F2). Yowerengera AutoSum anasankha maselo ndime ya - (alt = +); mtengo wa ndalama ndi kuika mu ndime ya foni mu mzere lotsatira pansipa kusankha. Amaika anasankha panopa selo: tsiku - (Ctrl + kuloza +4), pamene - (Ctrl + kuloza +6). Spellcheck - (F7).

Tiyeni tikambirane mmene kuphatikiza maselo kupambana. Hotkey, mu nkhani iyi, mwatsoka, osati wothandizira. Komabe, pali ena zidule amene angakuthandizeni kuchepetsa ena vutoli.

The aligorivimu

Ngati mukufuna kuphatikiza maselo kupambana, pali mavuto ena. Pambuyo opaleshoni ikukhudza imfa deta maselo onse ophatikizana dera, kupatulapo kumanzere chapamwamba. Choyamba muyenera kusankha malo a maselo pamodzi, tilimbikire mbewa batani bwino pa malo kusankha, kusankha katunduyo "Mtundu Maselo ..." dontho-pansi menyu. "Mtundu Maselo" zenera limapezeka palokha, kusankha izo mu tsamba "mayikidwe" ndipo chongani "Merging maselo." Kugwira ntchito mu funso si ambiri operekedwa mu kupambana njira yachidule kiyibodi.

Kuphatikiza maselo yophweka ndi batani wapadera "kuphatikiza & Center", limene lili menyu "Home". Ngati mulibe kuika deta pakati, alemba pa chizindikiro kudzanja lamanja la batani, ndi submenu dontho-pansi, sankhani item yoyenera. Mwa njira, ngati inu zambiri ntchito opareshoni iyi, ndi bwino kuika batani Quick Access Toolbar. Kupulumutsa deta ku maselo ena Chili dera kupatula kumanzere chapamwamba, muli kusamutsa zili kwina kapena kuwonjezera kwa selo mwa kukopera (kapena kudula) ndi pasting.

njira zina zotheka kuphatikiza maselo, kupatulapo kutaya chilichonse deta zokhudzana ndi kugwiritsa ntchito macros kuti angapezeke Mwachitsanzo, kugwira ntchito kupambana maonekedwe. The opaleshoni mfundo zazikulu ndi chimodzimodzi monga pamanja, koma mofulumira ndi osaonekera kwa wosuta.

Kodi amaika mzere ndi hotkeys

Nthawi zambiri pali kufunika mu kupambana fomu amaika mzere. Hot makiyi ntchito opaleshoni - Ctrl + kuphatikiza chizindikiro. Izo ziyenera kuunikila mzere limene m'pofunika kumanga ina yatsopano. Kusankha izi zikhoza kuchitidwa ndi makiyi otentha (Kaonedwe + Space) kapena mwa kuwonekera kumanzere mbewa batani mu manambala lolingana mzere kumanzere, pamene cholozera akusintha mawonekedwe muvi. Ngati mzere si anasankhidwa ndi hotkey (Ctrl + kuphatikiza chizindikiro) kumabweretsa maonekedwe a "The Kuwonjezera maselo" wa menyu lolingana timakumana ndi kusankha chimene tsamba: maselo kosangalatsa pansi kapena, mzere kapena yachiwiri.

Excel hotkey "Chotsani mzerewu» - (Ctrl + opanda chizindikiro). Kuchotsa mzere m'pofunika kusankha ndi kudzapereka atolankhani kuphatikiza kiyi.

Pamene inu tilimbikire alt ofunika pa ntchito menyu bala amasonyeza lomveka makiyi otentha lolingana zinthu menyu. Izi zikufotokozeredwa ndi mu maonekedwe. Mungathenso mabaibulo pulogalamu kuyambira ndi kupambana 2007.

Ikani wapadera mu kupambana

Nthawi zambiri m'pofunika amaika mu selo mfundo zokha, kapena chilinganizo yekha. Kuti tichite zimenezi, pali njira kuti kupambana - Matani Special. Hotkeys ichi - (Ctrl + alt + V).

"Ikani Special" kukambirana bokosi akutsegula pamene inu tilimbikire makiyi amenewa. Lilipo ngati chabe pamaso ichi chidachitika kukopera kapena kudula chinthu, nkhani za selo, lemba pa fomu kapena wina pulogalamu. Pa zenera, sankhani malo anu: chilinganizo, akamagwiritsa mtengo, kapenanso zina mwa njira akufuna.

Choncho, kuwerenga nkhani za nkhaniyi, mwaphunzila, kodi makiyi otentha kupambana ndi mmene angadzigwiritsire ntchito izo. Kumene, nkhani sakufotokoza osakaniza onse alipo. Pakuti kuphunzira kokwanira kwambiri kwa mutu azitenga ntchito mabuku apadera.