Ma tebulo okhala ndi mizere yopanda kanthu si abwino kwambiri. Kuonjezerapo, chifukwa cha mizere yowonjezereka, kuyenderera kupyolera mwa iwo kungakhale kovuta kwambiri, popeza muyenera kupyola mumaselo ambirimbiri kuti muyambe kuchokera kumayambiriro kwa tebulo mpaka kumapeto. Tiyeni tipeze njira zomwe tingachotsere mizere yopanda kanthu ku Microsoft Excel, ndi momwe tingawachotse mofulumira komanso mosavuta.
Kuchotsedwa kwakukulu
Njira yotchuka kwambiri komanso yotchuka yochotsera mizere yopanda kanthu ndiyo kugwiritsa ntchito pulogalamu ya pulogalamu ya Excel. Kuti muchotse mizere mwanjira iyi, sankhani maselo osiyanasiyana omwe alibe data, ndipo dinani pomwepo. Mu menyu yotseguka, timapita ku chinthu "Chotsani ...". Simungathe kuitanitsa zam'ndandanda, koma tchulani njira yochezera "Ctrl + -".
Dindo laling'ono likuwonekera momwe muyenera kufotokozera zomwe tikufuna kuchotsa. Timayika pamasewero "chingwe". Dinani pa batani "OK".
Pambuyo pake, mizere yonse ya osankhidwayo idzachotsedwa.
Mwinanso mungasankhe maselo mumzere wofanana, ndipo mukakhala pa Tsambali la Home, dinani pa Chotsani Chotsani, chomwe chili mu Cell boxes pa riboni. Pambuyo pake, idzachotsedwa nthawi yomweyo popanda zolemba zina.
Inde, njirayi ndi yophweka komanso yotchuka kwambiri. Koma, kodi ndi yabwino kwambiri, mofulumira ndi yotetezeka?
Sakani
Ngati mizere yopanda kanthu ili pamalo omwewo, kuwachotsa kumakhala kosavuta. Koma, ngati amwazikana patebulo, kufufuza ndi kuchotsa kwawo kungatenge nthawi yambiri. Pankhaniyi, kusankha kumathandiza.
Sankhani lonse tablepace. Dinani pa ilo ndi botani lamanja la mouse, ndipo m'ndandanda wamakono muzisankha chinthu "Chotsani". Pambuyo pake, mndandanda wina ukuwonekera. Momwemo, muyenera kusankha chimodzi mwa zinthu zotsatirazi: "Yambani kuchokera pa A mpaka Z", "Kuchokera payeso kufika pazomwe", kapena "Kuchokera kwatsopano mpaka chakale." Zina mwa zinthu zomwe zatchulidwazi zidzakhala mndandanda zimadalira mtundu wa deta yomwe imayikidwa m'maselo a tebulo.
Ntchitoyi itatha, maselo onse opanda kanthu adzapita pansi pa tebulo. Tsopano, tikhoza kuchotsa maselowa m'njira iliyonse yomwe takambirana mu gawo loyamba la phunziroli.
Ngati dongosolo la kuyika maselo mu tebulo ndilofunika, ndiye tisanayambe kusankha, timayika khola lina pakati pa tebulo.
Maselo onse a m'ndandanda iyi awerengedwa.
Kenaka, timakhala ndi mbali ina iliyonse, ndikutsani maselo akutsika pansi, monga tafotokozera kale.
Pambuyo pake, kuti tibwezeretse dongosolo la mizere kupita kumalo omwe kale anali asanayambe kusankhidwa, timayankha pamndandanda ndi nambala za mzere "Kuchokera pachepera mpaka kufika".
Monga momwe mukuonera, mizere yayikidwa mu dongosolo limodzi, kupatula pa zopanda kanthu, zomwe zachotsedwa. Tsopano, tingofunika kuchotsa chigawo chowonjezeredwa ndi ziwerengero zowerengera. Sankhani ndimeyi. Kenaka dinani pa batani pa tepi ya "Chotsani". Mu menyu yomwe imatsegulidwa, sankhani chinthucho "Chotsani zipilala pa pepala." Pambuyo pake, gawo lofunidwa lidzachotsedwa.
Phunziro: Kusankha mu Microsoft Excel
Kugwiritsa ntchito fyuluta
Njira ina yobisa maselo opanda kanthu ndiyo kugwiritsa ntchito fyuluta.
Sankhani mbali yonse ya tebulo, ndipo, yomwe ili mu tab "Home", dinani pa "Sakani ndi Fyuluta" batani, yomwe ili mu bokosi lokonzekera "Kusintha". Mu menyu yomwe ikuwonekera, pangani kusintha kwa chinthu "Fyuluta".
Chithunzi chosiyana chimapezeka m'maselo a mitu ya tebulo. Dinani pa chithunzi ichi mu gawo lililonse limene mukufuna.
Mu menyu imene ikuwonekera, sankhani bokosi lakuti "Wopanda". Dinani pa batani "OK".
Monga mukuonera, patapita izi, mizere yonse yopanda kanthu inatha, monga idasankhidwa.
Maphunziro: Momwe mungagwiritsire ntchito fyuluta yamoto ku Microsoft Excel
Kusankhidwa kwa magulu
Njira ina yochotsera imagwiritsa ntchito kusankha gulu la maselo opanda kanthu. Kuti mugwiritse ntchito njirayi, choyamba musankhe tebulo lonse. Ndiye, pokhala mu tabu ya "Home", dinani pa "Fufuzani ndi kuika patsogolo" batani, yomwe ili pa leboni mu gulu la chida "Edit". Mu menyu imene ikuwonekera, dinani pa chinthu "Sankhani gulu la maselo ...".
Mawindo amatsegulira kumene timasuntha kusintha ku malo "opanda kanthu". Dinani pa batani "OK".
Monga mukuonera, patatha izi, mizere yonse yomwe ili ndi maselo opanda kanthu imatsindikizidwa. Tsopano dinani pa batani "Chotsani" yomwe tidziwa kale, yomwe ili pa thaboni mu gulu la "Gulu".
Pambuyo pake, mizera yonse yopanda kanthu idzachotsedwa patebulo.
Chofunika kwambiri! Njira yomalizayo sitingagwiritsidwe ntchito m'matawuni okhala ndi zigawo zowonjezereka, ndipo ndi maselo opanda kanthu omwe ali m'mizera kumene kulipo deta. Pankhaniyi, maselo akhoza kusintha, ndipo tebulo lidzasweka.
Monga mukuonera, pali njira zambiri zochotsera maselo opanda kanthu patebulo. Njira yabwino yomwe mungagwiritsire ntchito ikudalira zovuta za tebulo, komanso momwe mizere yosasinthika ikufalikira kuzungulira iyo (yokonzedwa mu chigawo chimodzi, kapena yosakanizidwa ndi mizere yodzaza ndi deta).