☑️ Njira 4 Zosavuta Zokonzera Makiyi a Mivi Osagwira Ntchito Mu Excel
- Ndemanga za News
- Ogwiritsa ntchito a Microsoft Excel amagwiritsa ntchito makiyi a mivi kuti adutse maspredishithi awo.
- Nthawi zina makiyi amasiya kugwira ntchito.
- Takonza kalozera wamomwe mungakonzere makiyi a Excel spreadsheet osagwira ntchito.
XINSTALL PODANIZA PAFAyilo YOKOKOTA
Kukonza zovuta zosiyanasiyana za PC, timalimbikitsa DriverFix:
Pulogalamuyi imasunga madalaivala anu kugwira ntchito, kukutetezani ku zolakwika wamba zamakompyuta ndi kulephera kwa hardware. Yang'anani madalaivala anu onse tsopano munjira zitatu zosavuta:
- Tsitsani DriverFix (tsitsani fayilo yatsimikiziridwa).
-
pitani yambani kusanthula kuti mupeze madalaivala onse ovuta.
-
pitani Sinthani madalaivala kuti mupeze matembenuzidwe atsopano ndikupewa kulephera kwadongosolo.
- DriverFix idatsitsidwa ndi owerenga 0 mwezi uno.
Ogwiritsa ntchito a Excel amatha kuyenda pamasamba ndi mbewa ndi kiyibodi. Ogwiritsa ntchito akasindikiza makiyi a mivi, amatha kuyendayenda m'maspredishiti posuntha pakati pa ma cell.
Mwachitsanzo, kukanikiza batani la pansi kudzasankha selo lotsatira kuchokera pa yosankhidwayo, mwina kupukuta pepalalo pansi.
Komabe, ogwiritsa ntchito ena a Excel anena m'mabwalo awo kuti sangasunthe kuchokera ku cell kupita ku cell pokanikizira makiyi a mivi pa kiyibodi yawo.
M'malo mwake, tsamba logwirira ntchito limangopendekera pansi, mmwamba, kumanzere, kapena kumanja mukasindikiza makiyi amivi mofanana ndi mukanikizira mabatani a scrollbar.
Chifukwa chake, ogwiritsa ntchitowa amadabwa momwe angabwezeretsere magwiridwe antchito a kiyiyo kuti athe kusuntha tsamba la Excel kupita ku selo lotsatira.
Kodi mungakonze bwanji vuto la makiyi a Excel spreadsheet?
1. Dinani Scroll Lock kiyibodi
Ogwiritsa ntchito a Excel sangathe kuyendayenda m'maselo a mapepala a Excel okhala ndi makiyi a mivi pamene srolllock yayatsidwa. Mutha kuwona ngati Scroll Lock yayatsidwa ndikudina kumanja pa bar yomwe ili pansi pa zenera la Excel kuti mutsegule menyu yomwe ili pansipa.
Menyu iyi imakuwuzani ngati loko ya mipukutu yatsegulidwa kapena yozimitsa. Komabe, mukadina Scroll Lock mu menyu, malo omwe ali pamwambawa amasiya kuwoneka pokhapokha ngati loko yotsegula yayatsidwa.
Kuyimitsa loko kuthetsera vutoli kwa ogwiritsa ntchito ambiri. Ngati kiyibodi yanu ili ndi kiyi yotsekera, dinani batani ili. Ogwiritsa ntchito ena angafunike kukanikiza kiyi ya ScrLk kuti atseke SL.
2. Zimitsani Mpukutu Lock ndi On-Screen Kiyibodi
1. Kukhazikitsa Kuthamanga kukambirana bokosi ndi kukanikiza ndi mawindo + R makiyi nthawi yomweyo.
2. Lowani Chabwino Dinani Kuthamanga ndi kukanikiza batani. Chabwino batani.
3. Kiyibodi yowonekera pazenera idzatsegulidwa.
4. Dinani pa Mpukutu kiyi pa izo kuti mulepheretse loko loko.
5. Tsekani kiyibodi yowonekera pazenera.
6. Yesani kudutsa mu Excel spreadsheet yokhala ndi makiyi a mivi ndikuwona ngati ikugwira ntchito.
Malingana ngati Scroll Lock yayatsidwa pa kiyibodi yanu, makiyi a mivi sangagwire ntchito bwino mu Excel. Ngati kiyibodi yanu siyikugwira ntchito, mutha kugwiritsa ntchito kiyibodi yapakompyuta kuti muyimitse izi.
3. Yambitsani Excel mu Safe Mode
Kukangana kowonjezera kwa Excel nthawi zina kumatha kulepheretsa ogwiritsa ntchito kudutsa ma cell omwe ali patsamba la Excel pogwiritsa ntchito makiyi a mivi pa kiyibodi yawo.
Kuti mukonze vutoli, yesani kutsegula Excel mu Safe Mode, yomwe imayamba kugwiritsa ntchito popanda zowonjezera zosafunikira. Mutha kuchita izi polowetsa 'excel/safe' mu Run ndikudina Chabwino.
Ngati izi zithetsa vutoli, ndiye kuti pulogalamu yowonjezera ndiyomwe yayambitsa. Pankhaniyi, muyenera kuletsa pulogalamu yowonjezera mwa kuwonekera mbiri > kusankha > Chalk mu Excel.
Kenako sankhani Zowonjezera za Excel mu Sinthani menyu yotsitsa ndikudina Tiyeni batani. Pambuyo pake, mutha kutsitsanso mabokosi a zowonjezera za Excel kuti muwaletse.
4. Letsani Makiyi Omata
- Choyamba, tsegulani amathamanga
- dinani pa Mawindo kiyi + R njira yachidule
- Katengedwe control/name Microsoft.EaseOfAccessCenter mu Open bokosi ndi kusankha Chabwino mwina.
- pitani Pangani kiyibodi kukhala yosavuta kugwiritsa ntchito kuti mutsegule zomwe zasonyezedwa pansipa.
- Chotsani kusankha Yambitsani Mafungulo Omata mwina.
- Ngati iye Yambitsani Mafungulo Omata bokosi silikufufuzidwa, fufuzani bokosi lake.
- Dinani bokosi loyang'ana panjira iyi kachiwiri kuti muzimitse.
- dinani pa ntchito batani.
- pitani Chabwino kutuluka pawindo.
Zosankha zomwe zili pamwambazi zakhazikitsa ma kiyibodi a Excel spreadsheet cell kwa ogwiritsa ntchito ambiri.
Ngati mukudziwa njira ina yothetsera vutoli, chonde gawani mu gawo la ndemanga pansipa kuti ogwiritsa ntchito ena ayesenso.
NKHANI ZOFUNIKIRA KUONA:
Muli ndi mavuto? Konzani ndi chida ichi:
- Tsitsani Chida ichi chokonzekera PC adavotera Zabwino kwambiri pa TrustPilot.com (kutsitsa kumayambira patsamba lino).
- pitani yambani kusanthula kuti mupeze zovuta za Windows zomwe zingayambitse mavuto pa PC.
- pitani konza zonse kuthetsa mavuto ndi matekinoloje ovomerezeka (kuchotsera kwa owerenga athu).
Restoro idatsitsidwa ndi owerenga 0 mwezi uno.
SOURCE: Ndemanga za News
Osayiwala kugawana nawo nkhani yathu pamasamba ochezera kuti atilimbikitse. 🤗