Momwe Mungagwirizanitse Maselo ku Excel ndi Google Spreadsheets

01 ya 01

Gwirizanitsani ma selo ku Excel ndi Google Spreadsheets

Mu Excel ndi Google Spreadsheets, selo yolumikizana ndi selo limodzi lokha lopangidwa ndi kuphatikiza kapena kuphatikiza maselo awiri kapena angapo pamodzi.

Mapulogalamu onse awiriwa ali ndi mwayi wosankha:

• gwirizanitsani maselo pang'onopang'ono
• gwirizani maselo vertically
• gwirizanitsani maselo onse mozungulira ndi mopingasa.

Kuonjezerapo, Excel ili ndi mwayi wosonkhanitsa ndi deta zomwe zimagwiritsidwa ntchito kawirikawiri popanga maudindo kapena mitu.

Kuphatikiza ndi malo kumapangitsa kuti zikhale zosavuta kuyika mutu pamapepala angapo a tsamba la ntchito.

Gwirizanitsani Magulu Amodzi A Data Okha

Gwirizanitsani maselo onse a Excel ndi Google Spreadsheets ali ndi malire amodzi - sangathe kuphatikiza deta ku maselo angapo.

Ngati maselo angapo a deta akuphatikizidwa, deta yokha yomwe ili kumtunda kwambiri imakhala yosungidwa - deta ina yonse idzatayika pamene kusonkhana kumachitika.

Chiwerengero cha selo cha selo yolumikizana ndi selo kumtunda wakumanzere kumanzere kwa choyambirira chosankhidwa kapena gulu la maselo.

Kumene Mungapeze Mgwirizano

Mu Excel, chisankho chophatikizana chikupezeka pa Tsambali la Home la Riboni. Chizindikiro cha pulogalamuyi chili ndi mutu wakuti Merge & Center, koma podutsa chingwe chotsika kumanja komwe kumatchulidwa pa chithunzi pamwambapa, mndandanda wotsika wazomwe mungasankhe mutsegulira.

Mu Google Spreadsheets, njira yosonkhanitsira maselo imapezeka pansi pa menyu. Chiwonetserocho chimangotsegulidwa ngati maselo oyandikana pafupi angasankhidwe.

Mu Excel, ngati Mgwirizano ndi Mgwirizano ukatsegulidwa ngati selo imodzi yokha isankhidwa, zotsatira zokha ndizosintha kayendedwe ka seloyo.

Mmene Mungagwirizanitse Maselo

Mu Excel,

1. Sankhani maselo angapo kuti agwirizane;
2. Dinani pazithunzi Zogwirizanitsa ndi Pakati pa tabu la Home la Ribbon kuti muphatikize maselo ndikuyika deta kudutsa mtundu wosankhidwa;
3. Kuti mugwiritse ntchito chimodzi mwazinthu zosakanikirana, dinani pansi pavivi pafupi ndi choyimira cha Merge & Center ndikusankha pazimene mungapeze:
   • Gwirizanitsani & Pakati;
   • Gwirizanitsani Ponse (kuphatikiza maselo osakanikirana - kudutsa mazenera);
   • Gwirizanitsani Maselo (akuphatikiza maselo osakanikirana, otsika, kapena onse);
   • Sungani maselo.

Mu Google Spreadsheets:

1. Sankhani maselo angapo kuti agwirizane;
2. Dinani pa Format> Gwirizanitsani maselo m'ma menus kuti mutsegule mndandanda wazomwe mungasankhe;
3. Sankhani pazimene mungapeze:
   • Gwirizanitsani zonse (kuphatikiza maselo pang'onopang'ono, pamtunda, kapena onse);
   • Gwirizanitsani kupingasa;
   • Gwirizanitsani vertically;
   • Sakanizani.

Kuyanjana kwa Excel ndi Njira Zina

Njira ina yosungira deta pazithunzi zambiri ndikugwiritsira ntchito Pulogalamu Yoyambira Padziko Lonse .

Ubwino wogwiritsa ntchito mbali imeneyi m'malo mogwirizanitsa & Center ndikuti sichiphatikiza maselo osankhidwa.

Kuonjezerapo, ngati selo limodzi liri ndi deta pamene mbaliyo ikugwiritsidwa ntchito, deta yomwe ili mu maselo imayikidwa payekha monga kusintha kusankhana kwa selo.

Mofanana ndi Merge & Center, kuyika mutu pamitu yambiri kumakhala kosavuta kuona kuti mutuwu ukugwira ntchito pazomwezi.

Pogwiritsa ntchito mutu kapena mutu wolemba pamakalata ambiri, chitani izi:

1. Sankhani maselo osiyanasiyana omwe ali ndi malemba oyenera kukhazikitsidwa;
2. Dinani pa tsamba la Home la riboni;
3. Mu gulu logwirizanitsa , dinani bokosi la bokosi la dialog box kuti mutsegule bokosi la bokosi la mawonekedwe;
4. Mu bokosi la bokosi, dinani pa Tsambali Lumikizanani;
5. Pogwiritsa ntchito malemba , dinani mndandanda wa mndandanda pansi pazowonongeka kuti muwone mndandanda wa zosankha;
6. Dinani pa Pakati Ponse Kusankhidwa kuti muyike malemba osankhidwa kudutsa maselo ambiri;
7. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.

Kuthamanga kwa & Excel Excel 2007

Pambuyo pa Excel 2007, kugwiritsira ntchito Merge & Center kungayambitse mavuto pakupanga kusintha kwina kumalo ophatikizana a tsamba .

Mwachitsanzo, sizingatheke kuwonjezera zigawo zatsopano kumalo ophatikizidwa pa tsamba.

Musanawonjezere zikhomo zatsopano, ndondomeko zotsatirazi ndi izi:

1. musagwirizanitse maselo ogwirizana omwe ali ndi mutu kapena kulowera;
2. onjezerani zikho zatsopano ku tsamba la ntchito;
3. Bwerezeraninso ntchito yosakanikirana ndi malo.

Kuchokera ku Excel 2007 komabe, zakhala zotheka kuwonjezera zipilala zina ku malo ophatikizidwa mofanana ndi mbali zina za tsambali popanda kutsatira tsatanetsatane.