Gudurar Excel Maimakon Motsi Jikin
Hanya Excel tana motsa shafi maimakon cell
Idan ya faru da cewa kana matsar da yanki na shafin da aka dube shi a zabi makullin maɓallin, ba zai iya warwarewa ba kuma za a iya magance matsalar idan aka sake kunna kwamfutarka ko Shirin Microsoft Excel.
Kamar yawancin batutuwa a cikin MS Excel, warware Kibiyoyin Ba Su vingaura swayoyi A cikin Excel ɗayan sauƙi ne na gajerun hanyoyin MS Excel da hanyoyin da za ku iya koya a cikin fewan matakai ka kuma yi amfani da su a yanayi daban-daban. Bari mu ga yadda za mu warware shi - kuma me ya sa hakan ma yake faruwa sam.
Microsoft Excel horo kan layiBude maɓallin kan allon allo, da kuma buɗe maɓallin SCRLK (kulle allo), kuma an gama! Za ku iya komawa kan tsarin tallanku na Exceler Excelery kamar yadda aka saba kuma kun sauyawa daga ɗayan zuwa wani amfani da makullin kifayen ku.
Duba cikakken tafiya kan yadda za a kulle allon allo yayin amfani da maɓallin kibiya da keybox ɗin kuma dawowa don sauya Sirel na yanzu tare da makullin:
Bayanin bayaniYawancin lokaci, idan kun kasance a cikin salula A1, kuma kun danna maballin arrow arrow dama
Kuna tsammani za a ƙare tare da tantanin halitta B1:
Idan, a maimakon haka, allon allon yana motsa ɗaya tantanin salula - har yanzu tare da cell A1 zaba:
Duk abin da zaka yi shi ne bude menu na Windows, shigar da keyboard a cikin mashigar bincike, sa'annan ka buɗe Allon allo:
A nan, tare da bude maɓallin Excel a wuri ɗaya, maballin ScrLk ya zama fari, ma'anar da aka zaba:
Danna kawai a kan maɓallin ScrLk don yada shi:
Koma zuwa Excel, kuma latsa maɓallin kewayawa dama yayin da aka zaɓi A1 wanda ya zaba ya kamata ya motsa zaɓi zuwa sel B1
Excel ba gungurawa sel tare da maballin arrow
Kasance mai kyau Pro: Kasance da karatunmu!
Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.
Rijista a nanWannan fitowar ta kiban kiɗan marasa motsi ba ya faru lokacin da aka duba maɓallin allon allo.
Yana kaiwa ga maɓallin maɓallin kewayawa shigar da shafi ba cell ba, latsa wannan maɓalli a cikin maɓallin maɓallin arrow arrow.
Idan maɓallin kibiya maɓallin kewayawa ba maɓulewa ba ne, to sai kawai bude maɓallin kama-da-wane da kuma canza maɓallin ginin allo, kuma maɓallin maɓallin kewayawa ba motsi kwayoyin halitta ba za a warware su!
Gudurar Excel maimakon motsi jikin
Lokacin da Excel ke tafiyawa maimakon motsi Kwayoyin, saboda kunna motsawa na kulle gungura, akwai hanya ɗaya don kashe shi.
Kunna maɓallin allo kuma kunna maɓallin kulle maɓallin gungura, ta hanyar gano aikace-aikacen kwamfutar a menu na bincike na Windows a gefen hagu na allon.
Bayan haka, kawai ka kashe maɓallin kulle gungura kai tsaye daga keyboard mai mahimmanci.
Mene ne maɓallin SCRLK akan mabuɗin don?
Maballin SCRLK akan mabuɗin an samo asali ne zuwa maɓallan maɓallin kwamfuta don samun hanyar da za a kunna taga kwamfutar ta amfani da madannin kawai, duk da haka ba shi da amfani kamar yadda yake a da, saboda yana yiwuwa a gungura tare da linzamin kwamfuta, ko ma da yatsa akan allon taɓawa. Amma wannan ba koyaushe lamarin yake ba
Maballin SCRLK akan maballin: gungurawa ta taga ta amfani da kibiyoyin madannai
A yau, idan kuka danna mabuɗin wannan mabuɗin, ko kunna aikin a cikin software, zaku ƙare da sanin kibiyoyi waɗanda basa motsi a cikin Excel saboda maɓallan kibiya a maimakon haka zasu sanya ku kulle aikin mirginewa.
Kibiyoyi Ba Sa vingaukar Kwayoyin A cikin Excel: warware ta ta hanyar kashe maɓallin SCRLK akan madannin
Idan kun kunna wannan aikin bisa kuskure, kuma kuna ƙarancin kasancewar kibiyoyi basa motsi kwayoyin a cikin Excel sannan kawai buɗe madannin allo, ta hanyar neman madannin a menu na Windows, kuma kashe zaɓi. Idan an kunna shi, maɓallin SCRLK akan mabuɗin ya kamata a haskaka kuma za a iya gane shi da sauƙi.
Kashe Kulle Kulle - Excel - Tallafin MicrosoftTambayoyi Akai-Akai
- Me yasa maganganun FIFT yake motsawa maimakon batun sel ya faru?
- Wannan batun tare da kibiyoyi masu fice ba su motsa sel faruwa lokacin da aka bincika akwatin katin allo. Wannan yana haifar da maɓallin kibiya mai kyau don motsa shafin kuma ba shine tantanin halitta ba, danna wannan maɓallin maɓallin Excel yana canza halayen kifayen kifaye.
- Me yasa makullin kibiya mai kyau ba ya motsi sel amma yana motsa shafin maimakon?
- Wannan batun yakan tashi lokacin da ake kunna aikin rikodin (SCRLK) a kwamfutarka. Don warware wannan, buɗe maɓallin allon allo a cikin Windows kuma kashe maɓallin SCRLK. Da zarar an kashe, kibiya maɓallin ya kamata suyi aiki koyaushe a Excel, yana ba ku damar motsawa tsakanin sel maimakon gungurawa shafin.
- Me ya kamata in yi lokacin da maɓallin Arewa Exceley ke motsa allon maimakon tantanin halitta?
- Idan makullin kibiya a Excel yana gungurawa allon maimakon motsi tsakanin sel, yawanci yana nufin cewa an kunna kulle. Latsa maɓallin 'Gungura Kalli' a kan keyboard don kashe shi kuma ku koma ga kewayawa ta al'ada.
- Ta yaya masu amfani za su gyara batun da maɓallan kibiya ba sa motsawa tsakanin sel a Excels, amma maimakon a maimakon shafin?
- Wannan batun galibi saboda ana kunna kulle kulle. Masu amfani za su iya magance wannan ta latsa maɓallin Gungurran Kulle a kan keyboard don kashe shi. Idan keyboard din ke da maɓallin kullewa kogin, toshewa ta ta hanyar allon allon allo a cikin Windows kuma zai iya warware matsalar.
Gudurar Excel Maimakon Motsi Jikin
Yoann Bierling shine ƙwararren ɗab'i na dijital, mai ba da shawara na duniya, yin tasiri na duniya ta hanyar ƙwarewa da bidi'a a cikin fasaha. Masu sha'awar ƙarfafa mutane da ƙungiyoyi don haɓaka sakamako na musamman da haɓaka haɓakawa ta hanyar samar da abun ciki.
Kasance mai kyau Pro: Kasance da karatunmu!
Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.
Rijista a nan