Momwe mungachotsere tchati mu Excel

Anonim

Momwe mungachotsere tchati mu Excel

Njira 1: Kiyi yotentha

Yambitsani kuti tipereke kuchokera njira yosavuta kwambiri yomwe imatanthawuza kugwiritsa ntchito Hotkey (kufufuta) kuti muchotse zonse zomwe zili patsamba lililonse. Mudzafunikira kuwunikira makonzedwe okha kuti muoneke kuti musinthe mfundo zosintha, kenako dinani batani ili ndikuwona momwe chinthucho chidzachotsedwera patebulo.

Kugwiritsa ntchito kiyi yotentha kuti muchotsetu tchati chowonjezera

Ngati mungakanikizire fufuyi kangapo, mutha kukhudzidwa ndi zinthu zina za tebulo, kotero musaiwale kuti pali mitundu yosiyanasiyana ya CTRL yomwe imaletsa chochita chomaliza.

Njira 2: Chida

Kupambana pali chida chotchedwa "kudula", lotchedwa kuti limatha kumvetsetsa kuti limapangidwa kuti lichotse zinthu zosafunikira. Imatchedwa njira ziwiri zosiyana, ndipo njira yonse yoyeretsa tebulo kuchokera ili ndi ndandandayi ikuwoneka motere:

  1. Unikani chithunzichi ndikudina malo aliwonse opanda kanthu ndi batani lamanzere kuti muitane menyu.
  2. Kusankha tchati kuti muchotse chida chodulidwa

  3. Sankhani "kudula" koyamba.
  4. Kusankha Chida chodulidwa kudzera mwazosankha kuti muthetse tchati

  5. Zonse zomwe zidzatsukidwa pomwepo.
  6. Kuchotsa mayeso a tchati ku Excel kudzera pa chida chodulidwa mu menyu

  7. Kuphatikiza apo, mutha kugwiritsa ntchito "kusinthana" tabu "kunyumba", komwe kuli chithunzi chokhala ndi lumo, zomwe zimapangitsa chida cha "kudula" isanayambe kuwonetsa chithunzi.
  8. Kusankha Chida Chochotsa Tchalitchi Chowonjezera Kudutsa Clipboard Clipboard

Njira 3: Ntchito "Choyera"

Pafupifupi mfundo yomweyo imagwira ntchito yodziwika bwino, koma kuthekera kwake kumatha. Kwa ife, zimangotenga imodzi mwazochita zake zokha kuti muyeretse chithunzi chonse.

  1. Tsindikani chithunzicho komanso "kunyumba" pokonzanso tabu yokonza.
  2. Pitani ku gawo losintha kuti mugwire ntchito ndi ntchito yomveka mukachotsa tchati

  3. Kukulitsa menyu "omveka bwino".
  4. Sankhani ntchitoyi kuti muyeretse kuti muchepetse tchati mu tebulo lambiri

  5. Dinani pa chinthu choyambirira "chotsani zonse".
  6. Kugwiritsa ntchito ntchito zonse zochotsa ma chart attete mu tebulo lambiri

  7. Bweretsani patebulo ndikuwonetsetsa kuti ndandandayi siyiwonetsedwa pamenepo.
  8. Tsitsi lopambana pakubwezeretsanso patebulo laposachedwa kugwiritsa ntchito ntchito yomveka bwino

Werengani zambiri zogwirizira "zodziwika bwino", ngati mtsogolo mukufuna kuti zithetse zomwe zili patebulo, mafomu ndi zinthu zina.

Njira 4: Kuchotsa zomwe zili pa tchati

Nthawi zina wogwiritsa ntchito sayenera kuchotsa chithunzithunzi, koma zomwe zili zenizeni, mwachitsanzo, dzinalo, dzina lake. Poterepa, mfundo ya chochitika sizisintha kwambiri ndipo njira zokhazokha sizikhala zovuta.

  1. Pambuyo posintha kugwira ntchito ndi ndandanda, sankhani chinthu chomwe mukufuna kuti kusintha kwa mawonekedwe akuwonekera m'mbali. Gwiritsani ntchito kiyi ya Del kuti muchotse mwachangu.
  2. Sankhani Chachikulu Chotsatsa Kuti Muchotse Zomwe Zilitu

  3. Zomwe zili zofunikirazi ziyeretsedwe, zomwe zitha kuwoneka mu chithunzi chotsatirachi.
  4. Kuchotsa bwino zomwe zili patsamba la chithunzi pogwiritsa ntchito kiyi yotentha

  5. Njira Zina - Pangani dinani kumanja pa chinthucho ndi mbewa ndikusankha kuchotsa zomwe zili patsamba. Izi zimabweretsa zomwezo.
  6. Kugwiritsa ntchito mndandanda wazomwe zili ndi zojambulazo kuti muyeretse zomwe zalembedwa pa tchati

Ngati pakufunika kuchotsa tchati kapena zomwe zili pachiyambi chifukwa cha kupanga sicholakwika, tikukulangizani kuti muwerenge malangizo ena patsamba lathu, zomwe zingakuthandizeni kudziwa kugwiritsa ntchito mitundu yosiyanasiyana ya ma graphs.

Onaninso: ma chart mu Microsoft Excel

Werengani zambiri