AmaSpredishithi Afihliwe ku-Excel: Ungawabonisa kanjani noma uwafihle kanjani

Ku-Excel, umsebenzisi angakha futhi asebenze kumashidi amaningana ngesikhathi esisodwa. Futhi ngezinye izikhathi, ngenxa yezizathu ezihlukahlukene, kungase kube nesidingo sokufihla ezinye zazo. Ngokwesibonelo, ngenxa yesifiso sokufihla ukwaziswa okubalulekile emehlweni ahlolayo, okungase kube kuyimfihlo futhi kube nenani lezentengiselwano. Noma, umsebenzisi umane afune ukuzivikela ezenzweni zephutha ngedatha eseshidini okungafanele lithintwe.

Ngakho-ke, ungafihla kanjani ishidi ku-Excel? Kunezindlela ezimbili zokwenza lokhu. Ake sibheke ngayinye yazo.

Ungalifihla kanjani ishidi usebenzisa imenyu yokuqukethwe

Lena indlela elula neshesha kakhulu yokufihla ishidi, eyenziwa ngezinyathelo ezi-2 kuphela.

1. Ukuze senze lokhu, sidinga ukubiza imenyu yokuqukethwe ngokuchofoza kwesokudla eshidini olifunayo.
2. Khetha okuthi “Fihla” ohlwini oluvelayo.
3. Lokho, empeleni, yikho konke. Ishidi elidingekayo lifihliwe.

Ukucasha usebenzisa amathuluzi ohlelo

Indlela ethandwa kancane, kodwa noma kunjalo, ulwazi ngayo ngeke lube ludingekile.

1. Okokuqala, khetha ishidi ofuna ukulifihla.
2. Iya kuthebhu ethi “Ekhaya”, chofoza ithuluzi elithi “Amaseli,” ezinkethweni ezivelayo, khetha “Fometha”.
3. Ohlwini oluvulayo, khetha okuthi “Fihla noma bonisa” bese uthi “Fihla ishidi”.

   

4. Ishidi elikhethiwe lizofihlwa.

Qaphela: uma ubukhulu bewindi nohlelo lwe-Excel buvumela, inkinobho ethi “Fometha” izovezwa ngokushesha kuthebhu ethi “Ekhaya”, kudlule ibhokisi lamathuluzi elithi “Amaseli”.

Ungawafihla kanjani amashidi amaningi

Inqubo yokufihla amashidi amaningana, empeleni, ayihlukile kulawo achazwe ngenhla. Kodwa-ke, ngaphambi kokuqhubeka nakho, udinga ukukhetha wonke amashidi okufanele afihlwe.

1. Uma amashidi ehlelwe ngokulandelana, ukhiye we-Shift uzofika kahle. Khetha ishidi lokuqala, ubambe ukhiye we-Shift, futhi ngaphandle kokulikhulula, chofoza ishidi lokugcina, bese ukhulula ukhiye. Ukukhetha kungenziwa futhi ngokuphambene - kusukela kokugcina kuya kweyokuqala. Ngokwemvelo, sikhuluma ngamashidi okuqala nawokugcina adinga ukufihlwa.
2. Uma amashidi azofihlwa engahlelwanga ngokulandelana, kufanele akhethwe kusetshenziswa ukhiye we-Ctrl (Cmd - we-macOS). Siyibamba phansi bese sichofoza kwesokunxele kuwo wonke amashidi adinga ukufihlwa. Ungakwazi ke ukukhulula ukhiye Ctrl.
3. Sikhethe wonke amashidi adingekayo, manje ungawafihla usebenzisa noma yiziphi izindlela ezihlongozwe ngaphambili. Umphumela uzoba okufanayo.

Isiphetho

Ngakho-ke, sisanda kuthola ukuthi singawafihla kanjani amashidi ku-Excel ngezindlela ezimbili. Kungakhathaliseki ukuthi ukhetha yiphi, ukusizakala kwalo msebenzi kwezinye izimo kusobala, ngakho ulwazi nekhono lokuwusebenzisa kuzosiza abasebenzisi abavame ukusebenza nohlelo izikhathi ezingaphezu kwesisodwa.