Momwe mungasinthire mizere mu Excel

Mukamagwira ntchito mumkonzi wa spreadsheet, nthawi zambiri zimakhala zofunikira kusinthana mizere mu chikalata cha spreadsheet. Kuti mugwiritse ntchito njirayi yosavuta, pali njira zambiri zosiyana. M'nkhaniyi, tikambirana mwatsatanetsatane njira zonse zomwe zimatilola kugwiritsa ntchito njira yosinthira mizere mu chikalata cha Excel spreadsheet.

Njira yoyamba: kusuntha mizere pokopera

Kuwonjezera mzere wothandiza wopanda kanthu, momwe deta yochokera ku chinthu china idzalowetsedwa pambuyo pake, ndi imodzi mwa njira zosavuta. Ngakhale kuphweka kwake, sikuthamanga kwambiri kugwiritsa ntchito. Malangizo atsatanetsatane amawoneka motere:

1. Timasankha ma cell ena pamzere, pamwamba pomwe tikukonzekera kukhazikitsa mzere wina. Dinani kumanja mbewa batani. Menyu yaying'ono yapadera yowonekera idawonekera pachiwonetsero. Timapeza batani "Ikani ..." ndikudina LMB.

2. Zenera laling'ono linawonekera pazenera, lotchedwa "Add Cells". Pali zosankha zingapo zowonjezera zinthu. Timayika chizindikiro pafupi ndi mawu akuti "mzere". Dinani LMB pa "Chabwino" kuti mutsimikizire zosintha zomwe zachitika.

3. Mzere wopanda kanthu wawonekera muzambiri za tabular. Timasankha mzere womwe tikufuna kusunthira mmwamba. Muyenera kusankha chonsecho. Timapita ku gawo la "Home", pezani chida cha "Clipboard" ndikudina LMB pachinthu chotchedwa "Copy". Njira ina yomwe imakulolani kuti mugwiritse ntchito njirayi ndikugwiritsa ntchito kiyi yapadera "Ctrl + C" pa kiyibodi.

4. Sunthani cholozera kumunda woyamba wa mzere wopanda kanthu womwe wawonjezeredwa masitepe angapo apitawo. Timapita ku gawo la "Home", pezani chida cha "Clipboard" ndikudina kumanzere chinthu chotchedwa "Paste". Njira ina yomwe imakulolani kuti mugwiritse ntchito njirayi ndikugwiritsa ntchito kiyi yapadera "Ctrl +".V” pa kiyibodi.

5. Mzere wofunikira wawonjezedwa. Tiyenera kuchotsa mzere woyambirira. Dinani batani lakumanja la mbewa pa chinthu chilichonse cha mzerewu. Menyu yaying'ono yapadera yowonekera idawonekera pachiwonetsero. Timapeza batani la "Chotsani ..." ndikudina LMB.

6. Zenera laling'ono linawonekeranso pazenera, lomwe tsopano lili ndi dzina lakuti "Chotsani Maselo". Pali zingapo kuchotsa options pano. Timayika chizindikiro pafupi ndi mawu akuti "mzere". Dinani batani lakumanzere la mbewa pa "Chabwino" kuti mutsimikizire zosintha zomwe zachitika.

7. Chinthu chosankhidwa chachotsedwa. Takhazikitsa kuvomereza kwa mizere ya spreadsheet document. Okonzeka!

Njira Yachiwiri: Kugwiritsa Ntchito Njira Yophatikizira

Njira yomwe ili pamwambayi ikuphatikizapo kuchita zinthu zambiri. Kugwiritsa ntchito kwake ndikoyenera pokhapokha ngati kuli kofunikira kusinthana mizere ingapo. Ngati mukufuna kugwiritsa ntchito njirayi pazambiri zambiri, ndiye kuti ndi bwino kugwiritsa ntchito njira zina. Langizo latsatanetsatane la amodzi mwa iwo likuwoneka motere:

1. Dinani batani lakumanzere la mbewa pa nambala ya serial ya mzere, yomwe ili pagulu la ma coordinates amtundu woyimirira. Mzere wonse wasankhidwa. Timapita ku gawo la "Home", pezani chida cha "Clipboard" ndikudina LMB pachinthu chomwe chili ndi dzina loti "Dulani".

2. Dinani kumanja pa coordinate bar. Pamawonekedwe ang'onoang'ono apadera adawonekera, momwe m'pofunika kusankha chinthu chotchedwa "Ikani maselo odulidwa" pogwiritsa ntchito LMB.

3. Titachita izi, tidapanga kuti mzere wodulidwa uwonjezedwe pamalo omwe adanenedwa. Okonzeka!

Njira Yachitatu: Kusinthana ndi Khoswe

The table editor imakulolani kuti mugwiritse ntchito zololeza mzere m'njira yachangu kwambiri. Njira imeneyi imaphatikizapo kusuntha mizere pogwiritsa ntchito mbewa ya pakompyuta ndi kiyibodi. Zida, ntchito zosinthira, ndi menyu yankhani sizigwiritsidwa ntchito pano. Malangizo atsatanetsatane amawoneka motere:

1. Timasankha nambala yamtundu wa mzere pa gulu logwirizanitsa lomwe tikukonzekera kusuntha.

2. Sunthani cholozera cha mbewa kupita pamwamba pa mzerewu. Imasinthidwa kukhala chithunzi ngati mivi inayi yolozera mbali zosiyanasiyana. Gwirani pansi "Shift" ndikusunthira mzere kumalo omwe tikukonzekera kuwusuntha.

3. Okonzeka! Munjira zingapo, tidakhazikitsa kusuntha mzere kupita kumalo omwe tikufuna kugwiritsa ntchito mbewa yakompyuta yokha.

Mapeto ndi zomaliza za kusintha malo a mizere

Tinapeza kuti mkonzi wa spreadsheet ali ndi njira zambiri zomwe zimasinthira mizere muzolemba. Wogwiritsa ntchito aliyense azitha kusankha yekha njira yabwino kwambiri yoyendetsera. Mwachidule, tikhoza kunena kuti njira yogwiritsira ntchito mbewa ya pakompyuta ndiyo njira yachangu komanso yosavuta yogwiritsira ntchito ndondomeko yosinthira mizere mu chikalata cha spreadsheet.