Phunziro la kusankha tebulo mu Excel

Pulogalamu ya Excel idapangidwa kuti izitha kuwerengera masamu osiyanasiyana, kupanga matebulo, ma graph ndi ma chart. Kuti muchite chilichonse ndi tebulo, muyenera kusankha bwino.

Kutengera kukula kwa matebulo, kupezeka kwazinthu zilizonse m'malo oyandikana nawo, pali zosankha zitatu zosankha matebulo mu Excel. Kusankha zovomerezeka kwambiri, m'pofunika kuganizira aliyense wa iwo mwatsatanetsatane.

Njira 1: kuwunikira tebulo ndi mbewa

Njirayi ndi yosavuta komanso yofala kwambiri. Ubwino wake, ndithudi, ndizosavuta komanso zomveka kwa ogwiritsa ntchito ambiri. Choyipa chake ndi chakuti njira iyi si yabwino kugawa tebulo lalikulu, komabe, imagwira ntchito.

Chifukwa chake, kuti musankhe tebulo motere, muyenera kukanikiza batani lakumanzere la mbewa, ndikuligwira, sankhani malo onse a tebulo kuchokera pakona yakumanzere kupita kumunsi kumanja.

Komanso, mukhoza kuyamba kusankha ndi kusuntha mbewa zonse kuchokera pamwamba kumanzere ngodya ndi kumunsi kumanja ngodya, kusankha diametrically moyang'anizana ndi imodzi monga mfundo yomaliza. Kuchokera pakusankha mfundo zoyambira ndi zomaliza, sipadzakhala kusiyana muzotsatira.

Njira 2: hotkeys kusankha

Kusankha matebulo akulu, ndikosavuta kugwiritsa ntchito njira yachidule ya kiyibodi "CTRL + A" ("Cmd + A" - ya macOS). Mwa njira, njirayi imagwira ntchito osati mu Excel, komanso m'mapulogalamu ena.

Chonde dziwani kuti kusankha tebulo pogwiritsa ntchito njirayi, pali kachigawo kakang'ono - panthawi yomwe makiyi otentha akuphwanyidwa, cholozera cha mouse chiyenera kuikidwa mu selo lomwe lili mbali ya tebulo. Iwo. kuti musankhe bwino malo onse a tebulo, muyenera dinani pa selo iliyonse patebulo ndikusindikiza makiyi "Ctrl + A" pa kiyibodi.

Kukanikizanso makiyi otentha omwewo kudzasankha pepala lonse.

Ngati cholozera chiyikidwa kunja kwa tebulo, kukanikiza Ctrl + A kudzasankha pepala lonse pamodzi ndi tebulo.

Njira 3: Sankhani ndi Shift Key

Mwanjira iyi, zovuta monga momwe ziliri mu njira yachiwiri siziyenera kuwuka. Ngakhale njira yosankhidwa iyi ndi yayitali pang'ono pakukhazikitsa kuposa kugwiritsa ntchito ma hotkeys, ndikwabwino nthawi zina, komanso yabwino kuposa njira yoyamba, momwe matebulo amasankhidwa pogwiritsa ntchito mbewa.

Kuti musankhe tebulo motere, muyenera kutsatira njira iyi:

1. Ikani cholozera pamwamba kumanzere kwa tebulo.
2. Gwirani pansi kiyi ya Shift ndikudina pa cell yakumanja yakumanja. Kenako mutha kumasula kiyi ya Shift.
3. Ngati tebulo ndi lalikulu kwambiri kuti likwanire pa zenera, choyamba ikani cholozera pa selo yoyambira, kenako yendani patebulo, pezani pomaliza, ndiyeno tsatirani njira zomwe zili pamwambapa.

Motero, tebulo lonse lidzasankhidwa. Ikhoza kuzindikirika pogwiritsa ntchito njira iyi pamwambapa komanso mosiyana. Iwo. mmalo mwa selo pamwamba kumanzere, mukhoza kusankha kumanja pansi monga poyambira, kenako muyenera dinani pamwamba kumanzere.

Kutsiliza

Pazosankha zitatu zosankha tebulo mu Excel zomwe zafotokozedwa pamwambapa, mutha kugwiritsa ntchito zonse zitatu. Ndipo posankha njira yeniyeni, m'pofunika kuganizira, choyamba, kukula kwa tebulo. Njira yoyamba ndiyosavuta komanso yomveka bwino, koma ndi yabwino komanso yosavuta kugwiritsa ntchito pamatebulo ang'onoang'ono. Popeza kusankha malo onse a tebulo ndi mbewa kudzakhala kovuta kwambiri ngati tebulo liri ndi mizere yambiri, chifukwa chake muyenera kugwira batani lakumanzere kwa nthawi yaitali. Njira yachiwiri yokhala ndi ma hotkey ndiyothamanga kwambiri, koma mawonekedwe ake amatha kuyambitsa zovuta kwa wogwiritsa ntchito. Njira yachitatu imapewa zovuta izi, koma imatenga nthawi yayitali kuposa kugwiritsa ntchito batani lophatikizidwa munjira yachiwiri.