Sau da yawa dole ne ku canza tebur daga Microsoft Excel zuwa Magana, sama da na biyun, amma har yanzu, maganganun ƙaurawar juyawa shima ba kasafai yake ba. Misali, wani lokaci kuna buƙatar canja wurin tebur zuwa Excel, wanda aka yi a Word, don amfani da ayyukan edita tebur don ƙididdige bayanan. Bari mu bincika hanyoyin da teburin motsi a cikin wannan shugabanci suke.
Kwafin kwafi
Hanya mafi sauƙi don ƙaura tebur ita ce amfani da hanyar kwafin yau da kullun. Don yin wannan, zaɓi teburin a cikin shirin Kalma, danna-dama akan shafin, sannan zaɓi abu "Kwafa" a cikin mahallin mahallin da ya bayyana. Kuna iya, maimakon haka, danna maɓallin "Kwafi", wanda ke saman saman kintinkiri. Wani zaɓi kuma ya ƙunshi, bayan sa alama akan teburin, latsa maɓallan keyboard Ctrl + C.
Don haka muke kofe teburin. Yanzu muna buƙatar manna shi a cikin takardar aiki mai kyau. Mun fara aikin Microsoft Excel. Mun danna kan tantanin a cikin wurin takardar inda muke son sanya teburin. Ya kamata a lura cewa wannan tantanin halitta zai zama hagu babba babba na tebur da aka saka. Daga wannan ne dole ne mu ci gaba lokacin da muke shirin jera teburin.
Mun danna-dama akan takardar, kuma a cikin menu na mahallin, a cikin zaɓuɓɓukan shigarwar, zaɓi ƙimar "Ajiye ƙirar asali". Hakanan zaka iya saka tebur ta danna maɓallin "Sakawa" wanda ke gefen hagu na haƙarƙarin. Ko, akwai zaɓi don buga maɓallin gajeriyar hanya Ctrl + V.
Bayan haka, za a shigar da teburin a cikin takardar aikin Microsoft Excel. Kwayoyin da ke cikin takardar ba za su iya zama tare da sel cikin teburin da aka saka ba. Sabili da haka, don sanya teburin zama mai gani, ya kamata a miƙa su.
Tebur shigo
Hakanan, akwai wata hanya mafi rikitarwa don canja wurin tebur daga Kalma zuwa Excel, ta hanyar shigo da bayanai.
Bude teburin a cikin Kalma. Zaba shi. Na gaba, je zuwa shafin "Layout", kuma a cikin rukunin kayan aiki na "Data" a kan kintinkiri, danna maballin "Maida zuwa Rubutu".
Zaɓuɓɓukan juyawa don buɗewa. A cikin "Separator" sigogi, ya kamata a saita juyawa zuwa "Tab." Idan wannan ba batun bane, matsar da canjin zuwa wannan matsayin, sannan danna maɓallin "Ok".
Je zuwa shafin "Fayiloli". Zaɓi abu "Ajiye azaman ...".
A cikin taga da zai buɗe, adana daftarin aiki, saka wurin fayilolin da ake so waɗanda za mu adana, kuma a ba shi suna idan sunan tsohuwar bai gamsar ba. Kodayake, ba cewa fayil ɗin da aka ajiye zai zama matsakaici kawai don canja wurin tebur daga Kalma zuwa Excel, yana ba da ma'ana kaɗan don canza sunan. Babban abin da yakamata ayi shine saita sashin "Rubutun Plain" a cikin filin "Nau'in fayil". Latsa maɓallin "Ajiye".
Taga juyawa ya buɗe. Anan ba kwa buƙatar yin kowane canje-canje ba, kawai kawai ku tuna ɓoye-ɓoye wanda kuke adana rubutun. Latsa maɓallin "Ok".
Bayan haka, mun fara shirin Microsoft Excel. Je zuwa shafin "Data". A cikin toshe tsare-tsaren "Samun bayanan waje" a kan kintinkiri, danna maɓallin "Daga rubutu".
Window ɗin shigo da rubutu yake buɗe. Muna neman fayil ɗin da muka adana a baya a cikin Kalma, zaɓi shi, kuma danna maɓallin "Shigo".
Bayan haka, taga Wizard ɗin yana buɗewa. A cikin saitunan tsarin bayanai, saka sigogi "Raba". Saita rikodin daidai gwargwadon wanda ka ajiye aikin rubutun a cikin Word. A mafi yawan lokuta, zai kasance "cibiya: Cyrillic (Windows)." Latsa maɓallin "Mai zuwa".
A taga na gaba, a saitin "Halaran mai raba shi ne", saita sauya zuwa matsayin “Tab Stop”, idan ba a shigar da shi ta gidan ba. Latsa maɓallin "Mai zuwa".
A cikin taga na karshe na Mayen Rubutu, zaku iya tsara bayanan a cikin ginshiƙai, la'akari da abin da ke ciki. Mun zabi takamaiman shafi a cikin bayanin Sample ɗin, kuma a saiti don tsarin bayanan shafi, zaɓi ɗaya daga zaɓuɓɓuka huɗu:
- janar;
- matani
- Kwanan Wata
- tsallake shafin.
Muna yin irin wannan aiki don kowane shafi daban. A ƙarshen tsarawa, danna maɓallin "Gama".
Bayan haka, taga shigo da bayanai yana buɗewa. A fagen, da hannu saka adireshin tantanin, wanda zai zama sashin hagu na sama na ƙarshe na teburin da aka saka. Idan kun kasance asara yin wannan da hannu, to danna kan maɓallin zuwa dama na filin.
A cikin taga da ke buɗe, zaɓi zaɓi kawai. To, danna kan maɓallin zuwa dama na bayanan da aka shigar a cikin filin.
Komawa taga shigo da bayanai, danna maballin "Ok".
Kamar yadda kake gani, an saka tebur.
,Ari, idan ana so, zaku iya saita iyakoki na ganuwa, tare da tsara ta ta amfani da ingantattun hanyoyin Microsoft Excel.
Hanyoyi guda biyu don canja wurin tebur daga Kalma zuwa Excel an gabatar dasu a sama. Hanya ta farko tana da sauƙin sauƙaƙa fiye da ta biyu, kuma duka hanyar tana ɗaukar lokaci da yawa. A lokaci guda, hanya ta biyu tana ba da tabbacin rashin ƙarin charactersan haruffa, ko watsawar sel, wanda yake mai yiwuwa ne yayin canja hanyar ta farko. Don haka, don sanin zaɓi na canja wuri, kuna buƙatar farawa daga hadaddun tebur, da kuma manufarta.
