Ogwiritsa ntchito ambiri azindikira kuti pamene akugwira ntchito ku Microsoft Excel, pali zochitika pamene maselo akulemba deta m'malo mwa nambala, zizindikiro zimawoneka ngati ma grids (#). Mwachibadwa, sikutheka kugwira ntchito ndi chidziwitso mwa mawonekedwe awa. Tiyeni timvetse zomwe zimayambitsa vutoli ndikupeza yankho lake.
Kuthetsa mavuto
Chizindikiro chotsatira (#) kapena, monga momwe zilili zovomerezeka kuitcha, oktotorp imapezeka m'maselo awo pa pepala la Excel, limene deta silikugwirizana ndi malire. Choncho, iwo amawonekera m'malo mwazizindikiro, ngakhale kuti, panthawiyi, pulogalamuyi ikugwirabe ntchito ndi mfundo zenizeni, osati ndi zomwe zikuwonetsera pazenera. Ngakhale izi, kwa wogwiritsa ntchito deta sichidziwika, choncho, kuthetsa vutoli kuli kofunika. Zoonadi, deta yeniyeni imatha kuwonedwa ndikugwiritsidwa ntchito kudzera mu bar, koma kwa ogwiritsa ntchito ambiri sichifukwa.
Kuwonjezera apo, mapulogalamu akale a pulogalamuyi anawonekera ngati, pogwiritsira ntchito mawonekedwe a malemba, malemba omwe ali mu selo anali ndi zoposa 1024. Koma, kuyambira pa tsamba la Excel 2010, choletsedwa ichi chinachotsedwa.
Tiyeni tione momwe tingathetsere vuto ili la mapu.
Njira 1: Kuwonjezera Buku
Njira yosavuta komanso yosamvetsetseka ya ogwiritsa ntchito ambiri kuti athetse malire a selo, ndipo, potero, kuthetsa vuto lowonetsa magalasi mmalo mwa manambala, ndikulumikiza mozungulira malirewo.
Izi zatheka mwachidule. Ikani cholozera pamalire pakati pa zigawo mu gulu logwirizana. Tikudikira mpaka chithunzithunzi chimasandulika kukhala mzere wotsatira. Timakanikiza ndi batani lamanzere, ndipo, mutagwira, kukokera malire mpaka mutha kuona kuti zonsezi zikugwirizana.
Pambuyo pomaliza ndondomekoyi, selo lidzakula, ndipo ziwerengero zidzawoneka mmalo mwake.
Njira 2: Kuchepetsedwa kwa ndondomeko
Inde, ngati pali chigawo chimodzi chokha kapena ziwiri zomwe deta silingagwirizane ndi maselo, ndi zophweka kukonza mkhalidwe monga momwe tafotokozera pamwambapa. Koma choti muchite ngati pali zipilala zambiri. Pankhaniyi, mungagwiritse ntchito zochepetsera malemba kuti muthe kuthetsa vutoli.
- Sankhani malo omwe tikufuna kuchepetsa malemba.
- Kukhala mu tab "Kunyumba" pa tepiyi mu zida za zipangizo "Mawu" Tsegulani mawonekedwe osintha. Timayika chizindikiro chochepa kuposa chomwe chikuwonetsedwa pano. Ngati deta silingagwirizane ndi maselo, ndiye kuti malirewo asachepetse mpaka zotsatira zomwe zikufunidwa zikukwaniritsidwa.
Njira 3: Kukula Kwambiri
Pali njira yina yosinthira fayilo mumaselo. Ikuchitika mwa kupangidwira. Pachifukwa ichi, kukula kwa malembo sikudzakhala kofanana kwa mtundu wonsewo, ndipo mu gawo lirilonse lidzakhala ndi phindu lokwanira kulumikiza deta mu selo.
- Sankhani kuchuluka kwa deta yomwe tidzakonza. Dinani botani lamanja la mouse. Mu menyu yachidule, sankhani mtengo "Sungani maselo ...".
- Zowonetsera zojambula zimatsegula. Pitani ku tabu "Kugwirizana". Ikani mbalame pafupi ndi mtengo "Kukula Kwambiri". Kuti mukonze kusintha, dinani pa batani. "Chabwino".
Monga mukuonera, patatha izi, ndondomeko m'maselo inachepa mokwanira kuti deta ikhale yoyenera.
Njira 4: Sinthani chiwerengero cha chiwerengero
Kumayambiriro kumeneku, pamakhala zokambirana zomwe zakale za Excel zimakhala zowerengeka zomwe zinaikidwa pa chiwerengero cha anthu omwe ali mu selo limodzi pamene akuyika malemba. Popeza kuti ambiri ogwiritsa ntchito akupitiriza kugwiritsa ntchito mapulogalamuwa, tiyeni tiwone njira yothetsera vutoli. Pofuna kupyolera muyeso iyi, muyenera kusintha mawonekedwe kuchokera m'malemba kupita kwa onse.
- Sankhani malo okonzedwa. Dinani botani lamanja la mouse. Mu menyu imene ikuwonekera, dinani pa chinthucho "Sungani maselo ...".
- Muzenera zowonongeka pitani ku tabu "Nambala". Muyeso "Maofomu Owerengeka" kusintha mtengo "Malembo" on "General". Timakanikiza batani "Chabwino".
Tsopano choletsedwa chachotsedwa ndipo nambala iliyonse ya malemba idzawonetsedwa bwino mu selo.
Mukhozanso kusintha mtunduwu pa kaboni mu tab "Kunyumba" mu chigawo cha zipangizo "Nambala"posankha mtengo woyenera pawindo lapadera.
Monga mukuonera, kuchotsa oktotorp ndi manambala kapena deta ina yolondola ku Microsoft Excel sivuta. Kuti muchite izi, muyenera kuwonjezera mazenera kapena kuchepetsa maonekedwe. Kwa mapulogalamu akale a pulogalamuyi, kusintha mawonekedwe a malemba kwa wamba ndi ofunikira.