Njira 1. Pamanja
Tiyerekeze kuti muli ndi tchati zotsatirazi, anamanga pa mfundo ndime yoyamba ya tebulo (Moscow):
Ntchito ndikuwonjezera mwachangu deta yowonjezereka popanda kukonzanso chithunzicho (Samara).
Chilichonse chanzeru, monga mwachizolowezi, ndi chosavuta: sankhani ndime yokhala ndi deta yatsopano (D1: D7), ikopereni ku bolodi (CTRL + C), sankhani tchati ndikumata zomwe zili pa bolodi (CTRL + V). Mu Excel 2003 ndi kupitilira apo, kukokera (!) mtundu wosankhidwa ndi mbewa m'dera la tchati kumagwiranso ntchito. Zosavuta komanso zabwino, sichoncho?
Ngati kuyika sikunachitike monga momwe mumafunira kapena mukufuna kuyika osati mzere watsopano ndi deta (mzinda watsopano), koma kupitiriza komwe kulipo (mwachitsanzo, deta ya theka lachiwiri la chaka cha Moscow chomwecho. ), ndiye m'malo mwa kuyika mwachizolowezi, mutha kugwiritsa ntchito yapadera podina CTRL+ALT+V kapena kugwiritsa ntchito batani lotsitsa. Ikani (Mata) tsamba Kunyumba (Kunyumba):
Njira 2. Zodziwikiratu
Ngati muli ndi Excel 2007 kapena mtsogolo, ndiye kuti muwonjezere deta yatsopano pa tchati, muyenera kuchita zochepa kwambiri - lengezani zamtundu wa tchati ngati Table pasadakhale. Izi zitha kuchitika pa tabu. Kunyumba (Kunyumba) pogwiritsa ntchito batani Pangani ngati tebulo (Format as Table):
Tsopano, powonjezera mizere yatsopano kapena mizati patebulo, miyeso yake idzasinthidwa zokha ndipo, chifukwa chake, mizere yatsopano ndi zinthu za mzere zidzagwera mu tchati pa ntchentche, popanda kuyesetsa kwina kulikonse. Zodzichitira!
- Smart Spreadsheets Excel 2007/2010