Maitiro ekudzima chati muExcel

Anonim

Maitiro ekudzima chati muExcel

Nzira 1: inopisa kiyi

Kutanga isu tinopa kubva munzira iri nyore inowanikwa iyo inoreva kushandiswa kweiyo Del Hotyy (Delete) kukurumidza kudzima izvo zvirimo zvehuni chero mhando muExcel. Iwe unongoda kuratidza hurongwa pachako kuti uratidze kuti ugadzirise mapoinzi edit, wobva wadzvanya pane ino kiyi uye uone kuti chinhu chinobviswa patafura.

Uchishandisa kiyi inopisa kuti ubvise nekukurumidza chati mune excel

Kana iwe ukadzvanya kiyi iyi kanoverengeka, iwe unogona zvakare kukanganiswa nezvimwe zvinhu zvidiki, saka chenjera uye usakanganwa kuti pane kusiyana kwakasiyana kweiyo CTRL + Z makiyi anodzima chiitiko chekupedzisira.

Nzira 2: Cheka Tool

Mukuremekedza pane chishandiso chinonzi "cheterwa", zita raunogona kunzwisisa ipapo kuti rakagadzirirwa kubvisa zvinhu zvisina basa. Iyo inonzi nzira mbiri dzakasiyana, uye maitiro ese ekuchenesa tafura kubva purogiramu inotaridzika seizvi:

  1. Simbisai dhizaini uye tinya pane chero nzvimbo isina chinhu neiyo kurudyi mbeva bhatani kuti ufonere mamiriro menyu.
  2. Kusarudza chati kuti ubvise kuburikidza nekucheka chishandiso

  3. Sarudza yekutanga "kutemwa".
  4. Kusarudza chishandiso chetura kuburikidza nemusoro menyu kuti ubvise chati mune excel

  5. Zvese zvemukati zvichangocheneswa ipapo.
  6. Kubuditswa kwakabudirira kwe chati muExcel kuburikidza nekucheka chishandiso mumamiriro emenyu

  7. Pamusoro pezvo, unogona kushandisa iyo "Exchange Buffer" pa "Imba" Tab, iyo inokonzeresa kuti chishandiso chi "chocheka" chingokanganwe zvisati zvaitika kusimbisa girafu.
  8. Kusarudza chishandiso kubvisa chati muExcel kuburikidza ne clip clipboard

Nzira 3: Basa "Rakajeka"

Inenge nheyo imwe chete iyoyo inoshanda "kujeka" basa, asi kugona kwayo kunogona kuitika kwakasimba. Kwedu isu, zvinotora chete chimwe chezviito zvaro kuti chenese dhiramu yese.

  1. Simbisa iyo dhizaini uye pamusoro pe "Imba" tabu kuburikidza neiyo yekugadzirisa tab.
  2. Enda kune iyo yekugadzirisa chikamu kuti ushande neiyo yakajeka basa kana iwe ukadzima chati muExcel

  3. Wedzera "kujeka" kudonha-pasi menyu.
  4. Sarudza basa rekuchenesa kuti udzime chati mune yekunyanyisa tafura

  5. Dzvanya pane yekutanga chinhu "Chiedza zvese".
  6. Uchishandisa basa rakajeka zvese zvekukurumidza kudzima machati muTexcel tafura

  7. Dzokera patafura uye uve nechokwadi chekuti purogiramu haisisiri kuratidzwa ipapo.
  8. Yakabudirira Deletion chart muExcelafura yekuteedzera uchishandisa iyo yakajeka basa

Verenga zvimwe zvakadzama ne "Zvakajeka" Zvekushandisa basa, kana mune ramangwana iwe unoshuvira kudzima zviri nyore zviri mukati mefurafura, mafomu uye zvimwe zvinhu.

Nzira 4: Kubvisa zviri mukati mechati

Dzimwe nguva mushandisi anodikanwa kubvisa zvachose girafu, asi chete chairo chairo, semuenzaniso, zita, axis kana imwe yedata yemarangi. Mune ino kesi, nheyo yekuita haishanduri zvakanyanya uye maitiro pachayo haasi kunyanyoomera.

  1. Mushure mekushandurwa kushanda nehurongwa, sarudza chinhu chaunoda kuti ugadzirise chimiro chinowoneka mumicheto. Shandisa iyo del kiyi kuti ibvise nekukurumidza.
  2. Sarudza Chati Chati Kuti Ubvise Zvemukati muExcel

  3. Zvemukati zvichangocheneswa ipapo, izvo zvinogona kuoneka mumufananidzo unotevera.
  4. Kudzvanywa kwakabudirira kwezvinhu zve dhizaini uchishandisa kiyi inopisa muExcel

  5. Imwe sarudzo - ita iyo chaiyo tinya pane iyo iyo mbeva uye sarudza Delete chinhu mune iyo mamiriro menyu. Izvi zvinotungamira kune chaizvo mhedzisiro.
  6. Uchishandisa mamiriro emenyu uye mabasa akadzima kuchenesa zvirimo mune chati yemukati muExcel

Kana iyo yekuda kudzima chati kana zvirimo zvinokonzerwa nenzira isiriyo yekugadzira iyi yekugadzira imwe mirayiridzo yebhusaiti yedu, iyo inozobatsira kuti uzive sarudzo dzakasiyana dzemhando dzakasiyana dzeGraphs muExcel.

Onawo: Chati muMicrosoft Excel

Verenga zvimwe