Yadda za a kwafe takaddun aiki da yawa a cikin Excel ɗaya

Microsoft Excel

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.

kwafe zanen gado da yawa

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.


Abubuwan da ke cikin labarin suna bin ka'idodinmu na ka'idojin edita. Don yin rahoton kuskure danna a nan.

Kasance na farko don yin sharhi

Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Mai alhakin bayanan: Miguel Ángel Gatón
  2. Dalilin bayanan: Gudanar da SPAM, gudanar da sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.