Izindlela Ezi-3 Zokufihla Amakholomu Kuthebula le-Excel

I-Excel wuhlelo oluyingqayizivele, njengoba lunezici eziningi, eziningi zazo ezenza kube lula kakhulu ukusebenza ngamatafula. Lesi sihloko sizogxila kwesinye salezi zici, ezikuvumela ukuthi ufihle amakholomu etafuleni. Ngenxa yalokho, kuzokwazi, isibonelo, ukufihla izibalo eziphakathi okuzophazamisa ukunaka kumphumela wokugcina. Ziningi izindlela ezitholakalayo njengamanje, ngayinye yazo izochazwa ngezansi.

Indlela 1: Shifta Umngcele Wekholomu

Le ndlela ilula futhi iphumelela kakhulu. Uma sicubungula izenzo ngokuningiliziwe, kuzomele wenze lokhu okulandelayo:

1. Okokuqala, kufanele unake umugqa wokuxhumanisa, isibonelo, phezulu. Uma uhambisa phezu komngcele wekholomu, izoshintsha ukuze ibukeke njengomugqa omnyama onemicibisholo emibili emaceleni. Lokhu kusho ukuthi ungakwazi ukuhambisa umngcele ngokuphepha.

2. Uma umngcele ulethwa eduze ngangokunokwenzeka emngceleni oseduze, khona-ke ikholomu izoncipha kakhulu kangangokuthi ngeke isabonakala.

Indlela 2: Imenyu Yokuqukethwe

Le ndlela ithandwa kakhulu futhi ifunwa phakathi kwazo zonke ezinye. Ukuze uyisebenzise, ​​kuzokwanela ukwenza uhlu olulandelayo lwezenzo:

1. Okokuqala udinga ukuchofoza kwesokudla egameni lekholomu.

2. Kuzovela imenyu yokuqukethwe, lapho kwanele ukukhetha into ethi "Fihla".

3. Ngemva kwezenzo ezenziwe, ikholomu izofihlwa. Kuhlala kuphela ukuzama ukuyibuyisela esimweni sayo sokuqala, ukuze uma kwenzeka iphutha konke kungalungiswa ngokushesha.

4. Akukho lutho olunzima kulokhu, kwanele ukukhetha amakholomu amabili phakathi kwekholomu yethu eyinhloko efihliwe. Chofoza kwesokudla kuzo bese ukhetha Bonisa. Ikholomu izobe isivela kuthebula futhi ingasetshenziswa futhi.

Ngenxa yale ndlela, kuzokwazi ukusebenzisa lo msebenzi ngenkuthalo, wonge isikhathi futhi ungahlushwa imingcele yokudonsa. Lolu khetho lulula kakhulu, ngakho-ke ludingeka phakathi kwabasebenzisi. Esinye isici esithakazelisayo sale ndlela ukuthi kwenza kube lula ukufihla amakholomu amaningana ngesikhathi esisodwa.. Ukuze wenze lokhu, kuzokwanela ukwenza lezi zinyathelo ezilandelayo:

1. Okokuqala udinga ukukhetha wonke amakholomu ofuna ukuwafihla. Ukuze wenze lokhu, cindezela u-“Ctrl” bese uchofoza kwesokunxele kuwo wonke amakholomu.

2. Okulandelayo, vele uchofoze kwesokudla kukholomu ekhethiwe bese ukhetha okuthi “Fihla” kumenyu yokudonsela phansi.

3. Ngemva kwezenzo ezenziwe, wonke amakholomu azofihlwa.

Ngalesi sici, kuzokwaziwa ukufihla wonke amakholomu atholakalayo, kuyilapho uchitha isikhathi esincane. Into esemqoka ukukhumbula ukuhleleka kwazo zonke izenzo futhi uzame ukungajahi, ukuze ungenzi iphutha.

Indlela yesi-3: Amathuluzi eRibhoni

Kukhona enye indlela ephumelelayo ezofinyelela umphumela oyifunayo. Kulokhu uzosebenzisa ibha yamathuluzi phezulu. Izinyathelo ngesinyathelo zimi kanje:

1. Isinyathelo sokuqala ukukhetha iseli yekholomu ofuna ukuyifihla.

2. Bese uya kubha yamathuluzi bese usebenzisa ingxenye ethi “Ekhaya” ukuze uzulele entweni ethi “Fometha”.
3. Kumenyu evulayo, khetha okuthi “Fihla noma Bonisa”, bese ukhetha okuthi “Fihla Amakholomu”.

Uma konke kwenziwa ngendlela efanele, khona-ke amakholomu azofihlwa futhi ngeke esalayisha itafula. Le ndlela ifinyelela ekufihleni ikholomu eyodwa, kanye neziningana ngesikhathi esisodwa. Ngokuqondene nokushanela kwabo okuhlanekezelwe, imiyalelo enemininingwane yokusebenzisa lesi senzo kwaxoxiswana ngayo ngenhla kulesi sihloko, ngokuyisebenzisa, ungadalula kalula wonke amakholomu afihliwe ngaphambilini.

Isiphetho

Manje usunalo lonke ulwazi oludingekayo, okuzokuvumela ukuthi usebenzise ngokugcwele ikhono lokufihla amakholomu angadingekile esikhathini esizayo, okwenza ithebula lisebenziseke kalula. Indlela ngayinye kwezintathu ayinzima ukuyisebenzisa futhi itholakala kuwo wonke umsebenzisi wephrosesa yesipredishithi se-Excel - kokubili abaqalayo nabaqeqeshiwe.