Kuphatikiza patebulo mu Microsoft Office Excel, wogwiritsa ntchitoyo amatha kuwonjezera kukula kwa magawowo kuti awonjezere zomwe zili m'maselo. Izi ndizothandiza pamene kukula kwa zinthu zoyambirira ndizochepa kwambiri, ndipo sizovuta kugwira nawo ntchito. Nkhaniyi ifotokoza mawonekedwe a magome akuwonjezereka.
Momwe mungakulitsire kukula kwa zizindikilo mu Excel
Pali njira ziwiri zazikulu zomwe zimakupatsani mwayi wokwaniritsa cholingachi: kukulitsa maselo a mayina amodzi, mwachitsanzo, mizere kapena mizere; Ikani ntchito yolumikizira. Potsirizira pake, kuchuluka kwa pepala logwira lidzakhala lochulukirapo, chifukwa cha omwe anthu onse otchulidwawo adzakulira. Kenako, njira zonsezi zidzalingaliridwa mwatsatanetsatane.
Njira 1. Momwe mungakweze kukula kwa magome a pagome a pagomeMizere patebulo imatha kukulitsidwa motere:
- Ikani cholozera mbewa pansi pamzere womwe uyenera kukulira malire ndi mzere wotsatira.
- Amalamulira kuti chotembererochi tsopano chakhala muviwo utali.
- Gwira Lkm ndikusuntha mbewa pansi, i. Kuchokera ku chingwe.
- Malizitsani kukoka pomwe mzere udzatenga wogwiritsa ntchito.
- Momwemonso, kukulitsa mzere wina uliwonse patebulo pansipa.
Kukula kwa mizamu kumawonjezeka chimodzimodzi:
- Ikani cholozera mbewa ndi mbali yakumanja kwa mzati, i.e. Kumalire ake ndi gawo lotsatira.
- Onetsetsani kuti chotemberero chidatenga mitundu ya mivi yoyera.
- Dinani kiyi yakumanzere yayo ndikusunthira mbewa kumanja kuti muwonjezere gawo la gwero.
- Onani zotsatira zake.
Njira yodziwika imatha kukulitsidwa ndi mizere ndi mizere yanu patebulo mpaka khola mpaka khola likatenga malo onse a pepala logwira ntchito. Ngakhale malire a mundawo sangakhale ndi malire.
Njira 2. Kugwiritsa ntchito chida chomangidwa muyeso kuti muwonjezere kukula kwa zinthu za tebuloPalinso njira ina yosinthira zingwe zabwino kwambiri, zomwe zikutanthauza kuti zotsatirazi:
- Fotokozerani mizere imodzi kapena zingapo za LKM, kusuntha pepalalo molowera "pamwamba-pansi", i. molunjika.
- Dinani PCM pazakudya zoperekedwa.
- Munkhani yankhani, dinani pa chingwe kutalika ... ".
- Mu mzere wotsegulira pazenera lotseguka, m'malo mwake mtengo wopatsa utali wa chiwerengero chachikulu ndikudina "Chabwino" kuti musinthe.
- Onani zotsatira zake.
Kutambasula mzamba pogwiritsa ntchito pulogalamu ya chida chomangidwa, mutha kugwiritsa ntchito malangizo awa:
- Sankhani gawo lina la tebulo lomwe limafunikira kuwonjezeka kwa mbali yopingasa.
- Mu malo aliwonse osankhidwa, dinani PKM ndikusankha njira "m'lifupi mwake".
- Muuzeni mtengo wa kutalika komwe kudzakhala koposa imodzi.
- Onetsetsani kuti gawo la tebulo lambiri lachuluka.
Tambasulani chizindikirocho pachiwonetsero cha pepala lonse lomwe lingatheke, ndikuwonjezera chitsimezelo. Iyi ndi njira yosavuta yochitira ntchitoyi, yomwe imagawidwa m'njira zotsatirazi:
- Tsegulani chikalata chofunikira kwambiri cha Microsoft poyendetsa fayilo yosungidwa pakompyuta yanu.
- Dinani batani la "CTRL" pa kiyibodi ya PC ndikuyigwira.
- Popanda kumasula "Ctrl", fufuzani mawilo a mbewa mpaka pazenera limakwera kukula kwa wogwiritsa ntchito. Chifukwa chake, tebulo lonselo lichuluka.
- Muthanso kuwonjezera chophimba mwanjira ina. Chifukwa cha ichi, kukhala pa pepala la ntchito Excel, muyenera kusunthira wotsika pachimake kumanja kwa chophimba kuchokera ku ... kutero. Pomwe zimamuyendera, kukula mu chikalatachi kudzachulukana.
Musanasindikize tebulo kuchokera pachabe, ndikofunikira kuyang'ana kukula kwake. Muthanso kuwonjezera kukula kwa khola kuti ikhale ndi pepala lonse la A4. Kusintha sikele kusindikizidwa kumasiyana malinga ndi chiwembu chotsatira:
- Dinani pa batani la "Fayilo" pakona yakumanzere yazenera.
- Pawindo loyankhidwa, dinani LKM pa mzere "kusindikiza".
- Mu "kukhazikitsa" mu menyu yowonetsedwa, pezani batani lomwe lakonzedwa kuti musinthe sikelo. M'mabaibulo onse a Excel, ili pamalo omaliza mndandanda ndipo imatchedwa "Zapaka".
- Gutsani chithunzi chomwe chili ndi dzinalo "lapano" ndikudina pamzere "zosintha za kubzala ...".
- Mu "makonda" pazenera, muyenera kupita ku tabu yoyamba, mu "Scale" kusinthitsa chingwe cha "seti" 300%.
- Pambuyo dinani "Chabwino", onani zotsatira mu zenera lowonetsera.
Mapeto
Chifukwa chake, kutambasula tebulo ku Excel ndikosavuta kugwiritsa ntchito njira yosinthira. Werengani zambiri zomwe zafotokozedwa pamwambapa.
Mauthenga monga kukweza tebulo pa pepala lonselo adayamba woyamba kuchita ukadaulo wazokhudza.