Momwe mungatolere tebulo pa pepala lonselo

Anonim

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 pagome

Mizere patebulo imatha kukulitsidwa motere:

  1. Ikani cholozera mbewa pansi pamzere womwe uyenera kukulira malire ndi mzere wotsatira.
  2. Amalamulira kuti chotembererochi tsopano chakhala muviwo utali.
Momwe mungatolere tebulo pa pepala lonselo 6882_1
Kukhazikitsidwa koyenera kwa cholozera kuti muwonjezere kukula kwa chingwe
  1. Gwira Lkm ndikusuntha mbewa pansi, i. Kuchokera ku chingwe.
  2. Malizitsani kukoka pomwe mzere udzatenga wogwiritsa ntchito.
Momwe mungatolere tebulo pa pepala lonselo 6882_2
Mzere wamkulu
  1. Momwemonso, kukulitsa mzere wina uliwonse patebulo pansipa.

Kukula kwa mizamu kumawonjezeka chimodzimodzi:

  1. Ikani cholozera mbewa ndi mbali yakumanja kwa mzati, i.e. Kumalire ake ndi gawo lotsatira.
  2. Onetsetsani kuti chotemberero chidatenga mitundu ya mivi yoyera.
  3. Dinani kiyi yakumanzere yayo ndikusunthira mbewa kumanja kuti muwonjezere gawo la gwero.
Momwe mungatolere tebulo pa pepala lonselo 6882_3
Kusankhidwa kwa mizamu m'malo opingasa
  1. Onani zotsatira zake.
Momwe mungatolere tebulo pa pepala lonselo 6882_4
Kuchuluka kwa mizere ya tebulo

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 tebulo

Palinso njira ina yosinthira zingwe zabwino kwambiri, zomwe zikutanthauza kuti zotsatirazi:

  1. Fotokozerani mizere imodzi kapena zingapo za LKM, kusuntha pepalalo molowera "pamwamba-pansi", i. molunjika.
  2. Dinani PCM pazakudya zoperekedwa.
  3. Munkhani yankhani, dinani pa chingwe kutalika ... ".
Momwe mungatolere tebulo pa pepala lonselo 6882_5
Zochita zowonjezera zingwe zopangidwa mu chida cha pulogalamuyo
  1. Mu mzere wotsegulira pazenera lotseguka, m'malo mwake mtengo wopatsa utali wa chiwerengero chachikulu ndikudina "Chabwino" kuti musinthe.
Fotokozerani mtengo womwe mukufuna
  1. Onani zotsatira zake.

Kutambasula mzamba pogwiritsa ntchito pulogalamu ya chida chomangidwa, mutha kugwiritsa ntchito malangizo awa:

  1. Sankhani gawo lina la tebulo lomwe limafunikira kuwonjezeka kwa mbali yopingasa.
  2. Mu malo aliwonse osankhidwa, dinani PKM ndikusankha njira "m'lifupi mwake".
Momwe mungatolere tebulo pa pepala lonselo 6882_6
Kuchulukitsa mizatiyo mwanzeru kudzera mu menyu
  1. Muuzeni mtengo wa kutalika komwe kudzakhala koposa imodzi.
Chisonyezo cha m'lifupi mwake
  1. Onetsetsani kuti gawo la tebulo lambiri lachuluka.
Njira 3. Kusintha sikelo ya polojekiti

Tambasulani chizindikirocho pachiwonetsero cha pepala lonse lomwe lingatheke, ndikuwonjezera chitsimezelo. Iyi ndi njira yosavuta yochitira ntchitoyi, yomwe imagawidwa m'njira zotsatirazi:

  1. Tsegulani chikalata chofunikira kwambiri cha Microsoft poyendetsa fayilo yosungidwa pakompyuta yanu.
  2. Dinani batani la "CTRL" pa kiyibodi ya PC ndikuyigwira.
  3. Popanda kumasula "Ctrl", fufuzani mawilo a mbewa mpaka pazenera limakwera kukula kwa wogwiritsa ntchito. Chifukwa chake, tebulo lonselo lichuluka.
  4. 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.
Momwe mungatolere tebulo pa pepala lonselo 6882_7
Kwezani Scrip Scalch kuchokera ku pepala la ntchito ku Excel ndi Slider kumanzere
Momwe mungatolere tebulo pa pepala lonselo 6882_8
Batani "sikelo" munjira yopambana (tebulo la slide slide musanasindikize chikalata chosindikiza

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:

  1. Dinani pa batani la "Fayilo" pakona yakumanzere yazenera.
  2. Pawindo loyankhidwa, dinani LKM pa mzere "kusindikiza".
Momwe mungatolere tebulo pa pepala lonselo 6882_9
Njira yosindikiza magawo a Excel
  1. Mu "kukhazikitsa" mu menyu yowonetsedwa, pezani batani lomwe lakonzedwa kuti musinthe sikelo. M'mabaibulo onse a Excel, ili pamalo omaliza mndandanda ndipo imatchedwa "Zapaka".
  2. Gutsani chithunzi chomwe chili ndi dzinalo "lapano" ndikudina pamzere "zosintha za kubzala ...".
Momwe mungatolere tebulo pa pepala lonselo 6882_10
Kukhazikitsa Kukula
  1. Mu "makonda" pazenera, muyenera kupita ku tabu yoyamba, mu "Scale" kusinthitsa chingwe cha "seti" 300%.
  2. Pambuyo dinani "Chabwino", onani zotsatira mu zenera lowonetsera.
Momwe mungatolere tebulo pa pepala lonselo 6882_11
Zochita patsamba lazenera "masamba"
Momwe mungatolere tebulo pa pepala lonselo 6882_12
Onani Chikalata Chisanasindikize

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.

Werengani zambiri