Kuchepetsa ntchito polojekitiyi, ma cookkeys a Excel azithandizabe. Mukamazigwiritsa ntchito pafupipafupi, zimakhala zosavuta kuti musinthe matebulo.
Makina Amtundu Wamtambo wa Excel
Pogwira ntchito ndi Excel, ndibwino kugwiritsa ntchito njira zazifupi m'malo mwa mbewa. Pulogalamu ya tebulo la pulogalamuyi imaphatikizapo ntchito zambiri ndi kuthekera kochita ndi magome komanso zikalata zovuta kwambiri. Chinsinsi chimodzi chimakhala Ctrl, chimakhala chophatikiza ndi ena onse.
![](http://img.eifeg.com/img/pcpr-2019/10450/excel.png)
Pogwiritsa ntchito tatifupi ya keyboard ku Excel, mutha kutsegula, kutseka ma sheet, kusuntha chikalata, kuwerengera, ndi zina zambiri
Ngati simugwira ntchito ku Excel nthawi zonse, ndibwino kuti musawononge nthawi yanu ndikuphunzira ndi kukumbukira makiyi otentha.
Gome: zophatikiza zothandiza mu Excel
Njira yachidule | Zomwe achite |
Ctrl + Chotsani | Mawu osankhidwa amachotsedwa. |
Ctrl + Alt + V | Kukhazikika kwapadera kumachitika |
Ctrl + sign + | Tizilonda takale ndi mizere tawonjezedwa. |
Ctrl + chizindikiro - | Mizati yosankhidwa kapena mizera imachotsedwa. |
Ctrl + D | Gawo lotsika limadzaza ndi data kuchokera mu foni yosankhidwa |
Ctrl + R | Gawo lamanzere limadzaza ndi data kuchokera mu foni yosankhidwa. |
Ctrl + H | Windo la Search-Replace limawonekera. |
Ctrl + Z | Machitidwe omaliza aletsedwa. |
Ctrl + Y | Machitidwe omaliza abwerezedwa |
Ctrl + 1 | Kukambirana kwa mawonekedwe a cell kumatsegulidwa. |
Ctrl + B | Mawu ndi olimba mtima |
Ctrl + Ine | Kukhazikika kwanyengo |
Ctrl + U | Lembali lidapangidwa. |
Ctrl + 5 | Zolemba zazikuluzikulu zidatulutsidwa. |
Ctrl + Lowani | Maselo onse amasankhidwa. |
Ctrl +; | Tsiku lasonyezedwa |
Ctrl + Shift +; | Nthawi idasokonekera |
Ctrl + Backspace | Chombo chobwerera ku foni yapitayi. |
Ctrl + Malo | Mzerewu ukuonekera |
Ctrl + A | Zinthu zowoneka zimawunikidwa. |
Ctrl + Mapeto | Temberero lakhala pa foni yomaliza. |
Ctrl + Shift + Mapeto | Selo yomaliza imatchulidwa |
Ctrl + Arrows | Chikumbukiro chimayenda m'mphepete mwa mzere kulowera kwa mivi. |
Ctrl + N | Buku latsopano lopanda kanthu limawonekera |
Ctrl + S | Zikalata zasungidwa |
Ctrl + O | Bokosi losakira fayilo yomwe mukufuna |
Ctrl + L | Smart tebulo mode akuyamba |
Ctrl + F2 | Chithunzithunzi chikuphatikizidwa |
Ctrl + K | Hyperlink yoyikika |
Ctrl + F3 | Woyang'anira dzina wayambitsa |
Mndandanda wa kuphatikiza kwa Ctrl kopanda ntchito ku Excel kulinso kosangalatsa:
- F9 iyambitsa kuyambiranso kwa mitundu, ndipo kuphatikiza ndi Shift ichita izi pokhapokha;
- F2 idzaitanira mkonzi mu khungu linalake, ndipo lojambulidwa ndi Shift - zolemba zake;
- formula "F11 + Shift" ipanga pepala latsopano;
- Alt pamwe ndi Shift ndi muvi woyenera adzayendetsa zonse zomwe zasankhidwa. Ngati muvi ulunjikira kumanzere, ndiye kuti kusolola kudzachitika;
- Alt wokhala ndi muvi pansi adzatsegula mndandanda wotsitsa-wa cell yomwe yatchulidwa;
- kukulunga mzere kudzachitika ndi kukanikiza Alt + Enter;
- Shift ndi malo adzaunikira mzere wa tebulo.
Mwinanso mukuganiza kuti ndi njira ziti zazifupi zomwe mungagwiritse ntchito pa Photoshop: //pcpro100.info/goryachie-klavishi-fotoshop/.
Zala zam'manja, mutadziwa komwe kuli mafungulo amatsenga, amasula maso anu kuti agwiritse ntchito chikalatacho. Ndipo kuthamanga kwa ntchito zamakompyuta anu kudzathamanga kwenikweni.