Contents
Da kanta, takardar Excel ta riga ta zama babban tebur da aka tsara don adana bayanai iri-iri. Bugu da ƙari, Microsoft Excel yana ba da kayan aiki mafi mahimmanci wanda ke canza kewayon sel zuwa tebur "na hukuma", yana sauƙaƙa aiki da bayanai sosai, kuma yana ƙara ƙarin fa'idodi. Wannan darasi zai rufe tushen aiki tare da maƙunsar rubutu a cikin Excel.
Lokacin shigar da bayanai akan takardar aiki, ƙila ka so a tsara shi a cikin tebur. Idan aka kwatanta da tsarawa na yau da kullun, allunan na iya haɓaka kamanni da jin daɗin littafin gaba ɗaya, da kuma taimakawa tsara bayanai da sauƙaƙe sarrafa shi. Excel ya ƙunshi kayan aiki da salo da yawa don taimaka muku cikin sauri da sauƙi ƙirƙirar tebur. Mu duba su.
Ma'anar "tebur a cikin Excel" ana iya fassara shi ta hanyoyi daban-daban. Mutane da yawa suna tunanin cewa tebur wani nau'in sel ne da aka tsara da gani akan takarda, kuma ba su taɓa jin wani abu mafi aiki ba. Teburan da aka tattauna a cikin wannan darasi wani lokaci ana kiran su tebur “masu wayo” don amfaninsu da aikinsu.
Yadda ake yin tebur a Excel
- Zaɓi sel ɗin da kuke so ku canza zuwa tebur. A cikin yanayinmu, za mu zaɓi kewayon sel A1:D7.
- A kan Babba shafin Gida a cikin rukunin umarni styles latsa umarnin Tsara azaman tebur.
- Zaɓi salon tebur daga menu mai saukewa.
- Akwatin maganganu zai bayyana inda Excel ke daidaita kewayon tebur na gaba.
- Idan ya ƙunshi rubutun kai, saita zaɓi Teburi mai takensai ka latsa OK.
- Za a canza kewayon sel zuwa tebur a cikin salon da aka zaɓa.
Ta hanyar tsoho, duk allunan da ke cikin Excel suna ɗauke da filtata, watau Kuna iya tacewa ko tsara bayanai a kowane lokaci ta amfani da maɓallin kibiya a cikin taken shafi. Don ƙarin bayani game da rarrabawa da tacewa a cikin Excel, duba Aiki tare da Bayanai a cikin Koyarwar Excel 2013.
Canza tebur a cikin Excel
Ta ƙara tebur zuwa takardar aiki, koyaushe zaka iya canza kamannin sa. Excel ya ƙunshi kayan aiki da yawa don keɓance tebur, gami da ƙara layuka ko ginshiƙai, canza salo, da ƙari.
Ƙara layuka da ginshiƙai
Don ƙara ƙarin bayanai zuwa tebur na Excel, kuna buƙatar canza girmansa, watau ƙara sabbin layuka ko ginshiƙai. Akwai hanyoyi guda biyu masu sauƙi don yin haka:
- Fara shigar da bayanai a cikin layi mara komai (shafi) kai tsaye kusa da teburin da ke ƙasa (a hannun dama). A wannan yanayin, jere ko ginshiƙi za a haɗa ta atomatik a cikin tebur.
- Jawo ƙananan kusurwar dama na tebur don haɗa ƙarin layuka ko ginshiƙai.
Canjin salo
- Zaɓi kowane tantanin halitta a cikin tebur.
- Sannan bude shafin Constructor kuma sami rukunin umarni Tsarin tebur. Danna gunkin Ƙarin zaɓuɓɓukadon ganin duk salon da ake da su.
- Zaɓi salon da kuke so.
- Za a yi amfani da salon a teburin.
Canja saitunan
Kuna iya kunna da kashe wasu zaɓuɓɓukan akan shafin Constructordon canza kamannin tebur. Akwai zaɓuɓɓuka guda 7 gabaɗaya: Layi na kai, Jimillar Layi, Layukan Tsige, Rukunin Farko, Rukunin Ƙarshe, Rukunin Tsige da Maɓallin Tace.
- Zaɓi kowane tantanin halitta a cikin tebur.
- A kan Babba shafin Constructor a cikin rukunin umarni Zaɓuɓɓukan salon tebur duba ko cire alamar zaɓuɓɓukan da ake buƙata. Za mu kunna zaɓi Jimlar jeredon ƙara jimlar jeri zuwa tebur.
- Tebur zai canza. A cikin yanayinmu, sabon layi ya bayyana a ƙasan tebur tare da dabara wanda ke ƙididdige jimlar ƙimar da ke cikin shafi ta atomatik.
Wadannan zaɓuɓɓuka na iya canza bayyanar tebur ta hanyoyi daban-daban, duk ya dogara da abun ciki. Wataƙila za ku buƙaci gwada ɗan gwaji tare da waɗannan zaɓuɓɓukan don samun kamannin da kuke so.
Share tebur a cikin Excel
Bayan lokaci, buƙatar ƙarin aikin tebur na iya ɓacewa. A wannan yanayin, yana da daraja share tebur daga littafin aiki, yayin da yake riƙe duk bayanan da abubuwan tsarawa.
- Zaɓi kowane tantanin halitta a cikin tebur kuma je shafin Constructor.
- A cikin rukunin umarni Service zaɓi ƙungiya Maida zuwa kewayo.
- Akwatin maganganu na tabbatarwa zai bayyana. Danna A .
- Za a canza teburin zuwa kewayon yau da kullun, duk da haka, za a adana bayanai da tsarawa.