Bayyana bayani kamar yadda kake bukata
Ƙididdiga masu kyau na Excel, jerin shimfidawa da daidaitawa tare da wasu shirye-shiryen MS Office sun sanya shi tsari na musamman don shigarwa da adana abubuwan da aka tsara na rubutu. Da zarar ka sami duk bayanin da aka shigar, zaka iya rarraba shi don biyan bukatunka ba tare da komai ba sai kaɗan daga cikin linzamin kwamfuta.
Koyon yadda za a haruffa a cikin Excel da wasu hanyoyi don warware rubutu zai iya ceton ku na lokaci kuma ya ba ku iko fiye da bayanan da kuke buƙatar amfani.
Bincika matakai na kusan kowane fasali na Microsoft Excel ciki har da 2016, 2013, 2010, 2007 da 2003 ko a baya da kuma Excel na Mac 2016, 2011, 2008 da 2004. Kuna iya yin fasali na asali ta amfani da Excel tareda layi 365.
Yadda za a Tsara Aiki a cikin Excel
Hanyar da ta fi sauƙi don haruffa a shafi na Excel ita ce ta yi amfani da fasalin fasalin. Inda kake samun wannan yanayin ya dogara da wane ɓangaren Excel kake amfani da su.
A cikin Excel 2003 da 2002 don Windows ko Excel 2008 da 2004 don Mac , bi wadannan matakai.
- Tabbatar cewa babu Kwayoyin da ke cikin jerin.
- Danna kan kowane tantanin halitta a shafi da kake son rarraba.
- Zaži Bayanan a kan kayan aiki kuma zaɓi Zabuka . Rubutun maganganun da za a bude su.
- Zabi shafi da kake son bugawa cikin rubutun A cikin akwatin, zaɓi Girma .
- Danna Ya yi don rarraba jerin lissafi.
A cikin Excel 2016, 2013, 2010 da 2007 don Windows; Excel 2016 da 2011 don Mac; da kuma Office Excel Online, rarraba yana da sauki kuma.
- Tabbatar cewa babu Kwayoyin da ke cikin jerin.
- Danna Tsara & Fitawa a cikin Yanki na ɓangaren shafin shafin.
- Zaži Zaɓi A zuwa Z don haruffa jerin ku.
Tsara ta hanyar daidaituwa ta Multiple Columns
Idan kana so ka ba da kyautar kundin sel a cikin Excel ta amfani da ɗigo ɗaya fiye da ɗaya, siffar fasali ta ba ka damar yin haka, kazalika.
A cikin Excel 2003 da 2002 don Windows ko Excel 2008 da 2004 don Mac , bi wadannan matakai.
- Zaɓi dukkanin jikin da kake son warwarewa ta hanyar rubutun jerin lambobi biyu ko fiye a cikin kewayon.
- Zaži Bayanan a kan kayan aiki kuma zaɓi Zabuka . Rubutun maganganun da za a bude su.
- Zaɓi hanyar farko ta hanyar da kake so don harufa bayanai a cikin Tsara ta akwatin kuma zaɓi Girma .
- Zaɓi gunkin na biyu wanda kake son rarraba kewayon Kwayoyin a cikin Sa'an nan Daga jerin. Zaka iya raba ta har zuwa ginshiƙai uku.
- Zaɓi maɓallin rediyo na Header Row idan lissafinka yana da maɓallin kai a saman.
- Danna Ya yi don rarraba jerin lissafi.
A cikin Excel 2016, 2013, 2010 da 2007 don Windows ko Excel 2016 da 2011 don Mac, fashewa yana da mahimmanci. (Ba'a samuwa wannan fasali a cikin Office 365 Excel Online.)
- Zaɓi dukkanin jikin da kake son warwarewa ta hanyar rubutun jerin lambobi biyu ko fiye a cikin kewayon.
- Danna Tsara & Fitawa a cikin Yanki na ɓangaren shafin shafin.
- Zaži Yanayin Custom . Za a buɗe akwatin maganganun.
- Zaži Saiti na Na'urar Hasan masu duba akwatin idan lissafinka suna da sauti a saman.
- Zaɓi hanyar farko ta hanyar da kake so don haruffa bayanai a cikin Tsara ta akwatin.
- Zaɓi dabi'u na Cell a cikin Kwance a akwatin.
- Zaɓi A zuwa Z a cikin akwatin Cajin.
- Danna maɓallin Ƙara Ƙara a saman akwatin maganganu.
- Zaži shafi na biyu wanda zaka ke so don haruffa bayanai a cikin Tsara ta akwatin.
- Zaɓi dabi'u na Cell a cikin Kwance a akwatin.
- Zaɓi A zuwa Z a cikin akwatin Cajin.
- Danna Ƙara Matsayi don daidaita ta wani shafi, idan ana so. Danna Ya yi lokacin da kake shirye don buga kwamfutar ka.
Advanced Raba cikin Excel
A wasu lokuta, rarraba baƙaƙe kawai ba zai yi ba. Alal misali, ƙila ka sami lissafi mai tsawo wanda ya ƙunshi sunayen watanni ko ranakun mako da kake son rarraba lokaci-lokaci. Excel zai magance wannan a gare ku, kazalika.
A cikin Excel 2003 da kuma 2002 don Windows ko Excel 2008 da kuma 2004 don Mac , zaɓi jerin da kake son rarraba.
- Zaži Bayanan a kan kayan aiki kuma zaɓi Zabuka . Rubutun maganganun da za a bude su.
- Danna maballin Zaɓuɓɓuka a kasa na akwatin maganganu.
- Danna maɓallin jerin zaɓuɓɓuka a cikin Maɓallin Lissafi na Farko na Farko kuma zaɓi irin zaɓi da kake son amfani.
- Danna Ya yi sau biyu don rarraba jerin ku a jerin lokaci.
A cikin Excel 2016, 2013, 2010 ko 2007 don Windows da Excel 2016 da 2011 don Mac, zaɓi lissafin da kake son warwarewa. fasali yana da sauki. (Ba'a samuwa wannan fasali a cikin Office 365 Excel Online.)
- Danna Tsara & Fitawa a cikin Yanki na ɓangaren shafin shafin.
- Zaži Yanayin Custom . Rubutun maganganun da za a bude su.
- Danna maɓallin jerin zaɓuka a cikin jerin Lissafi kuma zaɓi Lissafin Yanayi . Lissafin Lissafin Lissafi zai buɗe.
- Zabi irin zaɓi da kake so ka yi amfani da shi.
- Danna Ya yi sau biyu don rarraba jerin ku a jerin lokaci.
Har ma Ƙarin Bayani Hanya
Excel yana samar da hanyoyi masu yawa don shiga, rarraba da kuma aiki tare da kusan kowace irin bayanai. Bincika 6 Hanyoyin da za a Bada Bayanai a Excel don ƙarin taimako da bayani.