Excel shine, a kan cancantarsa, da Mafi kyawun aikace-aikace don yin maƙunsar bayanai, daga mafi sauki kamar kiyaye tattalin arziƙin gida, zuwa zanen gado tare da bayanai marasa mahimmanci, wanda ke nuni zuwa wasu fayiloli da / ko shafukan yanar gizo, ɗakunan bayanan da aka ci gaba da sabuntawa wanda ke ba da damar ci gaba da kwararar bayanai da sabunta bayanai a kowane lokaci.
Kowane fayil na Excel ya kasance ne da zanen gado kuma duk mayafan da suka yi fayil na Excel ana kiran su Book. Wannan yana ba mu damar ƙirƙiri zanen gado daban-daban a cikin fayil / littafi ɗaya a sanya su duka a wuri guda. Kowane takarda na iya samun bayanan da kansa duk da cewa tsarin iri ɗaya ne.
Wato, zamu iya samun mayafan gado da yawa iri daya daidai a zane amma kowane daya yana nuna mana bayanai daban daban ko kuma yana samun bayanan ta atomatik daga wasu hanyoyin. Amma saboda wannan, abu na farko da dole ne muyi shine kwafa sau da yawa a takardar guda a cikin wannan fayil / littafin.
Don kwafin maƙunsar bayanai da yawa a cikin littafi ɗaya, adana ƙira da tsarin, muna da zaɓi biyu:
Hanyar 1
- Sanya linzamin kwamfuta akan takardar da muke son kwafa ka latsa maɓallin dama na linzamin kwamfuta
- Sannan zaɓi Matsa ko kwafa.
- A akwatin na gaba, za mu duba akwatin Airƙiri kwafa kuma mun zaɓi matsayin da zai kasance akan takardar, zaɓi don matsawa zuwa ƙarshen shine zaɓin da aka ba da shawara, don haka an sanya sabon takardar a matsayin takardar ƙarshe ta littafin.
Hanyar 2
Wani zaɓi mafi sauri kuma danna takardar da muke son kwafa da danna maɓallin Sarrafa yayin motsa linzamin kwamfuta zuwa wurin da muke son yin kwafin takardar da ake tambaya.