Kuphweka ntchito pulojekitiyi kumathandiza nthawi zonse kutentha kwa Excel. Nthawi zambiri mukazigwiritsa ntchito, ndizosavuta kuti mukhale ndikukonza matebulo aliwonse.
Kutentha kwa Excel
Pamene mukugwira ntchito ndi Excel ndizofunikira kugwiritsa ntchito njira zochepetsera makina m'malo mwa mbewa. Pulogalamu ya pulogalamuyi imaphatikizapo ntchito zambiri ndi machitidwe kuti agwiritse ntchito ngakhale magome ndi zovuta zambiri. Imodzi mwa mafungulo akulu adzakhala Ctrl, imapanga kuyanjana kopindulitsa ndi ena onse.
Pogwiritsa ntchito njira zochepetsera makina ku Excel, mukhoza kutsegula, kutsegula mapepala, kutsegula malemba, kuwerengera ndi zina zambiri.
Ngati simukugwira ntchito ku Excel nthawi zonse, ndi bwino kuti musataya nthawi yanu pophunzira ndi kukumbukira makiyi otentha.
Gome: Zowonjezera Zowonjezeretsa
Kusakaniza kwakukulu | Ndichitani chomwe chidzachitike |
Ctrl + Chotsani | Mawu osankhidwa achotsedwa. |
Ctrl + Alt + V | Kuika kwapadera kumachitika |
Ctrl + chizindikiro | Mipiringi yowonongeka ndi mizere yowonjezedwa. |
Ctrl + chizindikiro - | Masamba kapena mizere yosankhidwa imachotsedwa. |
Ctrl + D | Mtundu wotsikawu uli ndi deta kuchokera ku selo losankhidwa. |
Ctrl + R | Njira yomwe ili kumanja imadzazidwa ndi deta kuchokera ku selo losankhidwa. |
Ctrl + H | Fenje la Search-Replace likuwonekera. |
Ctrl + Z | Yachotsedwa ntchito yotsiriza |
Ctrl + Y | Chotsatira chotsiriza chikubwerezedwa. |
Ctrl + 1 | Mndandanda wa mndandanda wa mawonekedwe a selo umatsegulidwa. |
Ctrl + B | Mawu a Bold |
Ctrl + I | Kusintha kwa italiki kukupitirira. |
Ctrl + U | Malembo adatsindika |
Ctrl + 5 | Malemba osankhidwa apita |
Ctrl + Lowani | Lowani maselo onse osankhidwa |
Ctrl +; | Tsiku limasonyezedwa |
Ctrl + Shift +; | Nthawi imasindikizidwa |
Ctrl + Backspace | Wotembereredwa abwerera ku selo lapitalo. |
Ctrl + Spacebar | Imani |
Ctrl + A | Zinthu zooneka zikuwonetsedwa. |
Ctrl + Mapeto | Tsitsilo laikidwa pa selo lotsiriza. |
Ctrl + Shift + Kutha | Selo lotsiriza likuwonetsedwa. |
Ctrl + Mizere | Tsitsilo likuyendetsa pamphepete mwa chigawocho kutsogolo kwa mivi |
Ctrl + N | Buku latsopano lopanda kanthu likuwonekera. |
Ctrl + S | Chilembacho chapulumutsidwa |
Ctrl + O | Fayilo lofufuzira fayilo limatsegula. |
Ctrl + L | Masewu a Smart Table ayamba. |
Ctrl + F2 | Kuwonera kumaphatikizidwa. |
Ctrl + K | Hyperlink inayikidwa |
Ctrl + F3 | Dzina loyamba limayamba. |
Mndandanda wa zosakanizika za Ctrl zomwe zimagwira ntchito ku Excel ndizonso zodabwitsa:
- F9 iyamba kuyambiranso kwa mayendedwe, ndipo kuphatikiza ndi Shift idzachita papepala looneka;
- F2 idzayitanitsa mkonzi wa selo yeniyeni, ndipo idzaphatikizidwa ndi Shift - zilemba zake;
- ndondomeko ya "F11 + Shift" idzapanga pepala latsopano lopanda kanthu;
- Alt pamodzi ndi Shift ndi muvi kupita kumanja adzasankha zonse zomwe zasankhidwa. Ngati utawu ukulozera kumanzere, ndiye kuti ungrouping idzachitika;
- Alt ndi chingwe chotsitsa chidzatsegula mndandanda wotsika wa selo yeniyeni;
- mzere udzasuntha mukakanikizira Alt + Lowani;
- Kusuntha ndi malo kudzawonetsa mzere mu tebulo.
Mwinanso mutha kukhala ndi chidwi ndi zomwe mungakonde kugwiritsa ntchito mu Photoshop:
Zolemba zazing'ono, pozindikira malo amatsenga amatsenga, zidzamasula maso awo kuti agwire ntchito pa vukuti. Ndiyeno liwiro la ntchito yanu pamakompyuta lidzakula mofulumira.