Kana iwe wakavhura Excel uye wakaerekana waona kuti pakanga paine manhamba mumisoro yemisoro pachinzvimbo chemavara akajairwa, usaore moyo uye verenga chinyorwa ichi kusvika kumagumo! Muchidzidzo ichi, iwe unozodzidza maitiro ekuchinja manhamba kuita mavara mumakoramu, uye zvakare kujairana nemaitiro ekubatanidza muMicrosoft Excel.
Chii chinonzi link style?
Pepa rega rega reExcel rakagadzirwa nemitsara nemakoramu. Kazhinji, makoramu anoratidzwa nemavara (A, B, C) uye mitsetse inoratidzwa nenhamba (1, 2, 3). MuExcel inonzi link style A1. Zvisinei, vamwe vanosarudza kushandisa chimiro chakasiyana, apo makoramu anoverengwawo. Inonzi R1C1 yekubatanidza maitiro.
Iyo R1C1 yekubatanidza maitiro inogona kubatsira mune mamwe mamiriro, asi sezviratidziro zvinoratidza, izvi hazviwanzo. Kune zvakare boka revashandisi vanoda kushanda neiyi link fomati, zvisinei, ivo havasisiri vatsva. Muzviitiko zvakawanda, iwe uchashanda neA1 link style, iyo inoiswa muMicrosoft Excel nekukasira.
Ichi chidzidzo uye zvingangoita zvese zvezvidzidzo pane ino saiti shandisa iyo A1 yekubatanidza maitiro. Kana iwe parizvino uri kushandisa iyo R1C1 yekubatanidza maitiro, unofanirwa kuidzima.
Gonesa/dzima R1C1 yekubatanidza maitiro
- Baya faira, Kutamira ku backstage view.
- dzvanya Parameters.
- Mubhokisi rebhokisi rinoonekwa Excel sarudzo Sarudza chikamu Formula. Tarisa bhokisi R1C1 yekubatanidza maitiro uye tigoshingairira OK. Excel ichachinja kune iyo R1C1 yekubatanidza maitiro.
Sezvaungave wakafungidzira, kudzokera kuA1 yekubatanidza maitiro, zvakakwana kuti usatarise bhokisi iri.