Ungayisusa Kanjani Yonke Imigqa Engenalutho ku-Excel

Kulesi sihloko, ngizochaza ukuthi kungani ususa imigqa engenalutho ku-Excel usebenzisa gqamisa amaseli angenalutho > susa umugqa umqondo omubi, futhi ngizokukhombisa izindlela ezi-2 ezisheshayo nezilungile zokususa imigqa engenalutho ngaphandle kokucekela phansi idatha. Zonke lezi zindlela zisebenza ku-Excel 2013, 2010, nezinguqulo ezindala.

Uma ufunda lesi sihloko, khona-ke kungenzeka ukuthi uhlala usebenza ku-Excel ngamatafula amakhulu. Uyazi ukuthi imigqa engenalutho ivela ngezikhathi ezithile phakathi kwedatha, ikhawulela umsebenzi wamathuluzi amaningi ethebula le-Excel (ukuhlunga, ukususa izimpinda, ama-subtotals, njalonjalo), ukuwavimbela ekunqumeni kahle ububanzi bedatha. Futhi isikhathi ngasinye kufanele uchaze ngesandla imingcele, ngaphandle kwalokho umphumela uzoba umphumela ongalungile kanye nesikhathi esiningi esichithwa ukulungisa amaphutha.

Kunezizathu eziningi zokuthi kungani kuvela imigqa engenalutho. Isibonelo, uthole ibhuku lokusebenza le-Excel komunye umuntu noma ngenxa yokuthunyelwa kwedatha kusizindalwazi senkampani, noma idatha engadingekile emigqeni yasuswa mathupha. Kunoma ikuphi, uma inhloso yakho kuwukukhipha yonke leyo migqa engenalutho futhi ube netafula elihlanzekile nelihlelekile, landela lezi zinyathelo ezilula ezingezansi:

• Ungalokothi ususe imigqa engenalutho ngokukhethwa kweseli okungenalutho
• Ukukhipha imigqa engenalutho kusetshenziswa ikholomu yokhiye
• Ukukhipha imigqa engenalutho kuthebula ngaphandle kwekholomu yokhiye

Ungalokothi ususe imigqa engenalutho ngokukhethwa kweseli okungenalutho

Kuyo yonke i-inthanethi, uzothola ithiphu elilula okuthiwa likuvumela ukuthi ususe imigqa engenalutho:

• Khetha idatha kusukela kweyokuqala kuya kweyokugcina.
• Cindezela F5ukuvula ibhokisi Iya ku (Uguquko).
• Ebhokisini lengxoxo, chofoza inkinobho Special (Gqamisa).
• Ebhokisini lengxoxo Iya kokukhethekile (Khetha iqembu lamaseli) maka ibhokisi izikhala (Amaseli angenalutho) bese uchofoza OK.
• Chofoza kwesokudla kunoma yimaphi amaseli akhethiwe bese ucindezela Susa (Susa).
• Ebhokisini lengxoxo Susa (Susa amaseli) khetha Umugqa wonke (umugqa) bese ucindezela OK.

Lena indlela embi kakhulu., yenza lokhu kuphela ngamathebula alula anemigqa embalwa elingana esikrinini esisodwa, noma okungcono kakhulu - ungakwenzi lokho nhlobo! Isizathu esiyinhloko siwukuthi uma umugqa onedatha ebalulekile uqukethe okungenani iseli elilodwa elingenalutho, khona-ke wonke ulayini uzosuswa.

Isibonelo, sinetafula lekhasimende elinemigqa engu-6 isiyonke. Sifuna ukususa imigqa 3 и 5ngoba azinalutho.

Yenza njengoba kuphakanyiswe ngenhla futhi uthole umphumela olandelayo:

Line 4 (Roger) naye wanyamalala ngoba iseli D4 kukholamu Umthombo wethrafikhi kubonakale kungenalutho

Uma ithebula lakho lingelikhulu uzoqaphela ukulahleka kwedatha, kodwa kumathebula wangempela anezinkulungwane zemigqa ungasusa ngokungazi inqwaba yemigqa edingekayo. Uma unenhlanhla, uzothola ukulahlekelwa emahoreni ambalwa, buyisela ibhuku lomsebenzi kukhophi yasenqolobaneni, futhi uqhubeke nokusebenza. Kuthiwani uma unebhadi futhi ungenayo ikhophi yasenqolobaneni?

Kamuva kulesi sihloko, ngizokukhombisa izindlela ezi-2 ezisheshayo nezithembekile zokususa imigqa engenalutho kumashidi e-Excel.

Ukukhipha imigqa engenalutho kusetshenziswa ikholomu yokhiye

Le ndlela isebenza uma ithebula lakho linekholomu elisiza ukunquma ukuthi ikholomu okukhulunywa ngayo ayinalutho noma cha (ikholomu yokhiye). Isibonelo, kungaba i-ID yekhasimende noma inombolo ye-oda, noma into efanayo.

Kubalulekile kithi ukuthi silondoloze ukuhleleka kwemigqa, ngakho-ke asikwazi ukuvele sihlele ithebula ngaleyo kholomu ukuze sihambise yonke imigqa engenalutho.

1. Khetha ithebula lonke, kusukela kowokuqala kuya kumugqa wokugcina (cindezela Ikhaya le-Ctrl, bese Ctrl + Shift + End).
2. Engeza isihlungi esizenzakalelayo etafuleni. Ukuze wenze lokhu, kuthebhu Idatha (idatha) chofoza Hlunga (Hlunga).
3. Faka isihlungi kukholamu Cust#. Ukuze wenze lokhu, chofoza inkinobho yomcibisholo esihlokweni sekholomu, susa ukumaka inketho Khetha konke (Khetha Konke), skrolela phansi uze ufike ekugcineni kohlu (uma usebenza, lolu hlu lungaba lude kakhulu) bese uqoka ibhokisi izikhala (Akunalutho) ngaphansi kohlu. Chofoza OK.
4. Khetha yonke imigqa ehlungiwe: chofoza Ikhaya le-Ctrl, bese kuba umcibisholo oya phansi ukuze uye kumugqa wokuqala wedatha, bese ucindezela Ctrl + Shift + End.
5. Chofoza kwesokudla kunoma iyiphi iseli ekhethiwe futhi ukhethe kumenyu yokuqukethwe Susa irowu (Susa umugqa) noma vele uchofoze Ctrl + -(ukukhipha uphawu).
6. Efasiteleni elivela nombuzo Susa wonke umugqa weshidi? (Susa wonke umugqa weshidi?) chofoza OK.
7. Sula isihlungi esisetshenzisiwe: kuthebhu Idatha (idatha) chofoza Sula (Sula).
8. Kuhle kakhulu! Yonke imigqa engenalutho isuswe ngokuphelele, kanye nomugqa 3 (URoger) usekhona (qhathanisa nomphumela womzamo wangaphambilini).

Ukukhipha imigqa engenalutho kuthebula ngaphandle kwekholomu yokhiye

Sebenzisa le ndlela uma ithebula lakho linamaseli amaningi angenalutho ahlakazeke kumakholomu ahlukene, futhi udinga ukususa kuphela leyo migqa engenawo amaseli anedatha.

Kulokhu, asinayo ikholomu yokhiye ukusiza ukunquma ukuthi iyunithi yezinhlamvu ayinalutho noma cha. Ngakho-ke, sengeza ikholomu eyisizayo etafuleni:

1. Ekupheleni kwethebula, engeza ikholomu enegama izikhala bese unamathisele ifomula elandelayo kuseli lokuqala lekholomu:

   =COUNTBLANK(A2:C2)

   =СЧИТАТЬПУСТОТЫ(A2:C2)

   Le fomula, njengoba negama layo liphakamisa, ibala amaseli angenalutho ebangeni elinikeziwe. A2 и C2 amaseli okuqala nawokugcina omugqa wamanje, ngokulandelana.

   

2. Kopisha ifomula kuyo yonke ikholomu. Ungakwenza kanjani lokhu - bheka imiyalelo yesinyathelo ngesinyathelo Indlela yokufaka ifomula efanayo kuwo wonke amaseli akhethiwe ngesikhathi esisodwa.
3. Manje ithebula lethu linekholomu eyisihluthulelo! Faka isihlungi kukholamu izikhala (ngenhla umhlahlandlela wesinyathelo ngesinyathelo sendlela yokwenza lokhu) ukukhombisa kuphela imigqa enenani eliphezulu (3). Inombolo 3 kusho ukuthi wonke amaseli kulo mugqa akanalutho.
4. Okulandelayo, khetha yonke imigqa ehlungiwe bese uyisusa ngokuphelele. Indlela yokwenza lokhu ichazwe ngenhla. Ngenxa yalokho, ulayini ongenalutho (umugqa wesi-5) uzosuswa, yonke eminye imigqa (noma ngaphandle kwamaseli angenalutho) izohlala endaweni yayo.
5. Manje ikholomu eyisizayo ingasuswa. Noma ungasebenzisa esinye isihlungi ukuze ubonise kuphela lawo maseli aneseli elilodwa noma amaningi angenalutho. Ukuze wenze lokhu, susa ukumaka umugqa onevelu 0 (zero) bese ucindezela OK.