Ga mafi yawan masu amfani na Excel, tsarin aiwatar da kwashe Tables ba wuya. Amma ba kowa ba san wasu daga cikin hanyoyi da suke yin wannan hanyar yadda ya dace don kowane nau'in bayanai da manufofin daban-daban. Bari mu dubi wasu daga siffofin kwashe bayanan a Excel.
Rubuta a Excel
Yin kwashe tebur zuwa Excel shine ƙirƙirar ta. A cikin hanya kanta, babu kusan bambance-bambance dangane da inda za a saka bayanai: a wani sashi na takarda, a kan sabon takarda ko a wani littafi (fayil). Babban bambanci tsakanin hanyoyin biyan kuɗi shine yadda kuke son kwafin bayani: tare da takaddun ko kawai tare da bayanan da aka nuna.
Darasi: Kashe Tables a cikin Mirosoft Word
Hanyar 1: Kwafi ta tsoho
Kwafi ta sauƙaƙe ta tsoho a Excel yana samar da kirkiro na teburin tare da dukan samfurori da tsarawa a ciki.
- Zaɓi yankin da muke so mu kwafi. Danna kan yankin da aka zaɓa tare da maɓallin linzamin linzamin dama. Yanayin mahallin yana bayyana. Zaɓi abu a ciki "Kwafi".
Akwai wasu zaɓuɓɓuka don yin wannan mataki. Na farko shi ne danna maɓallin ƙwaƙwalwar hanya akan keyboard. Ctrl + C bayan zaɓar yankin. Hanya na biyu ya shafi danna maballin. "Kwafi"wanda yake a kan rubutun a cikin shafin "Gida" a cikin ƙungiyar kayan aiki "Rubutun allo".
- Bude yankin da muke son saka bayanai. Wannan zai iya zama sabuwar takarda, wani fayil na Excel, ko wani sashi na sel a kan takardar. Danna kan tantanin halitta, wanda ya kamata ya zama babban hagu na hagu na saitin da aka saka. A cikin mahallin menu a cikin zaɓuɓɓukan zaɓi, zaɓi "Saka" abu.
Akwai kuma zaɓuɓɓukan zabi don aikin. Zaka iya zaɓar tantanin salula kuma danna maɓallin haɗakarwa akan keyboard Ctrl + V. A madadin, za ka iya danna kan maballin. Mannawanda yake a gefen hagu na tef kusa da maɓallin "Kwafi".
Bayan haka, za a saka bayanan yayin da za a adana tsarawa da samfurori.
Hanyar 2: Kwafi Lambobin
Hanyar na biyu ita ce haɗawa kawai dabi'u na tebur wanda aka nuna akan allon, kuma ba maƙala ba.
- Kwafi bayanai a cikin ɗaya daga cikin hanyoyin da aka bayyana a sama.
- Danna maɓallin linzamin linzamin dama a wurin da kake so ka saka bayanai. A cikin mahallin menu a cikin zaɓuɓɓukan zaɓi, zaɓi abu "Darajar".
Bayan haka, za a kara teburin a cikin takardar ba tare da tsara tsarin ba da tsari. Wato, kawai bayanan da aka nuna akan allon zai zama kofe.
Idan kana so ka kwafi dabi'un, amma kiyaye tsari na asali, kana buƙatar ka je menu na menu a yayin shigarwa "Manna Musamman". Akwai a cikin toshe "Saka bayanai" buƙatar zaɓar abu "Ƙimar da kuma tsara asali".
Bayan haka, za a gabatar da tebur a asalinsa, amma a maimakon ƙwayoyin, sel zasu cika dabi'u masu yawa.
Idan kana son yin wannan aiki kawai tare da adana tsarin lambobi, ba dukan tebur ba, to, a cikin ƙila na musamman ka buƙatar ka zaɓa abu "Darajoji da kuma Nau'in Lambobi".
Hanyar 3: Samar da kwafin yayin riƙe da nisa daga cikin ginshiƙai
Amma, da rashin alheri, har ma da yin amfani da fasalin asalin ba ya ƙyale yin kwafin teburin da asalin asalin ginshiƙan. Wato, sau da yawa akwai lokuta idan bayan saka bayanai basu dace ba cikin sel. Amma a Excel yana yiwuwa a riƙe da asalin asalin ginshiƙai ta amfani da wasu ayyuka.
- Kwafi tebur a cikin kowane hanyoyi masu saba.
- A inda kake buƙatar shigar da bayanai, kira menu mahallin. Hakanan zamu je kan maki "Manna Musamman" kuma "Ajiye nisa daga ginshiƙan asali".
Zaka iya yin wata hanya. Daga cikin mahallin mahallin, je zuwa abu da sunan guda sau biyu. "Musamman saka ...".
A taga yana buɗe. A cikin "Saka" kayan aikin kayan aiki, matsar da canjin zuwa matsayin "Gurbin ginshiƙin". Muna danna maɓallin "Ok".
Kowace hanya da ka zaba daga sama da biyun zaɓuɓɓuka, a kowane hali, ɗakin da aka kwafi zai kasance daidai ɗayan ɗigin ɗigin as source.
Hanyar 4: Saka azaman hoto
Akwai lokuta a lokacin da ake buƙatar tebur ba a cikin tsarin ba, amma a matsayin hoto. Wannan matsala kuma an warware shi tare da taimakon wani zaɓi na musamman.
- Muna kwafin layin da ake so.
- Zaɓi wuri don sakawa kuma kira menu mahallin. Je zuwa maƙallin "Manna Musamman". A cikin toshe "Sauran Saka Zaɓuka" zabi abu "Zane".
Bayan haka, za a saka bayanai a cikin takarda a matsayin hoton. A al'ada, bazai yiwu a shirya irin wannan tebur ba.
Hanyar 5: Kwafi Takardar
Idan kana so ka kwafe dukan tebur a kan wata takarda, amma a lokaci guda ka kiyaye shi daidai da lambar tushe, sa'an nan kuma a wannan yanayin, yafi kyau a kwafe dukan takardar. A wannan yanayin, yana da mahimmanci don sanin cewa kana son canja duk abin da yake a kan takardar shaidar, in ba haka ba wannan hanya ba zai yi aiki ba.
- Domin kada a zabi dukkanin sassan takardar da hannu, wanda zai dauki lokaci mai tsawo, danna kan rectangle dake tsakanin daidaitawar kwance da tsaye. Bayan haka, duk takaddun za a haskaka. Don kwafe abubuwan da ke ciki, rubuta haɗin haɗin akan keyboard Ctrl + C.
- Don saka bayanai, bude sabon takarda ko sabon littafi (fayil). Hakazalika, danna kan rectangle dake a tsakiya tsakanin bangarori. Don saka bayanai, danna haɗin maɓalli Ctrl + V.
Kamar yadda ka gani, bayan yin wadannan ayyuka, mun gudanar da kwafin takarda tare da tebur da sauran abubuwan da ke ciki. A lokaci guda kuma ya fito ne domin adana ba kawai hanyar tsara ainihin ba, amma har da girman ƙwayoyin.
Editan Rubutun Labarai na Excel tana da kayan aiki masu yawa don kwashe Tables a daidai nau'in da mai amfani ya buƙaci. Abin takaici, ba kowa ba san game da nuances na aiki tare da saitin musamman da wasu kayan aikin kwafi wanda zai iya fadada yiwuwar canja wurin bayanai, da kuma sarrafa ayyukan mai amfani.
