Ungayisusa kanjani i-apostrophe ku-Excel

Olunye lwezimpawu zokubhala zekhibhodi i-apostrophe, futhi kumaspredishithi e-Excel ngokuvamile lisho ifomethi yombhalo yezinombolo. Lolu phawu luvame ukuvela ezindaweni ezingafanele, le nkinga iyenzeka nakwezinye izinhlamvu noma izinhlamvu. Ake sithole ukuthi singasula kanjani itafula lokuphazamisa izinhlamvu ezingenamsebenzi.

Indlela yokususa i-apostrophe ebonakalayo kuseli

I-aphostrophe uphawu oluthile lokubhala, lubhalwa kuphela ezimweni ezithile. Ngokwesibonelo, ingase ivele emagameni afanele noma amanani ezinombolo. Kodwa-ke, kwesinye isikhathi abasebenzisi be-Excel babhala ama-apostrophe ezindaweni ezingafanele. Uma kunezinhlamvu eziningi kakhulu ezengeziwe kuthebula, ungazishintsha ufake ezinye. Ake sithole ukuthi sikwenza kanjani ngezinyathelo ezimbalwa ezisheshayo sisebenzisa amathuluzi ohlelo.

1. Khetha amaseli lapho izinhlamvu ezingalungile zitholakala khona. Kuthebhu ethi "Ekhaya", thola inkinobho ethi "Thola bese ukhetha" bese uchofoza kuyo.

2. Khetha into ethi "Faka esikhundleni" kumenyu evulayo noma cindezela okhiye abashisayo "Ctrl + H".

3. Ibhokisi lengxoxo lizovuleka elinezinkambu ezimbili. Emgqeni ongaphansi kwesihloko esithi "Thola" udinga ukufaka uphawu olubhalwe ngokungalungile - kulokhu, i-apostrophe. Sibhala emgqeni othi “Faka esikhundleni nge” umlingiswa omusha. Uma ufuna ukususa i-aphostrophe kuphela, shiya umugqa wesibili ungenalutho. Isibonelo, ake sishintshe ukhefana kukholamu ethi “Faka esikhundleni ngokuthi” bese uchofoza inkinobho ethi “Miselela Konke”.

4. Manje etafuleni esikhundleni sama-aphostrophe kukhona okhefana.

Ungashintsha ama-aphostrophe hhayi eshidini elilodwa kuphela, kodwa kuyo yonke incwadi. Chofoza inkinobho ethi "Izinketho" ebhokisini lengxoxo yokumiselela - izinketho ezintsha zizovela. Ukuze ufake uhlamvu olulodwa esikhundleni solunye kuwo wonke amashidi edokhumenti, khetha inketho ethi “Ebhukwini” entweni ethi “Sesha” bese uchofoza okuthi “Faka esikhundleni Konke”.

Indlela yokususa i-aphostrophe engabonakali ngaphambi kweyunithi yezinhlamvu

Kwesinye isikhathi lapho ukopisha amanani kwezinye izinhlelo, i-apostrophe ivela ngaphambi kwenombolo kubha yefomula. Lo mlingisi akekho esitokisini. I-aphostrophe ibonisa ifomethi yombhalo wokuqukethwe kweseli - inombolo ifomethiwe njengombhalo, futhi lokhu kuphazamisa izibalo. Izinhlamvu ezinjalo azikwazi ukususwa ngokushintsha ifomethi, amathuluzi Excel noma imisebenzi. Kufanele usebenzise i-Visual Basic Editor.

1. Ukuvula iwindi le-Visual Basic for Applications usebenzisa inhlanganisela yokhiye u-Alt+F
2. Umhleli utholakala kuphela ngesiNgisi. Sithola kubha yemenyu ephezulu Faka (Faka) bese uchofoza entweni Imojuli (Imojula).

3. Bhala imakhro ukuze ususe i-aphostrophe.

Qaphela! Uma kungenakwenzeka ukwenza i-macro ngokwakho, sebenzisa lo mbhalo.

4. Khetha uhla lwamaseli lapho kuvela khona uhlamvu olwengeziwe, bese ucindezela inhlanganisela yokhiye "Alt + F8". Ngemva kwalokho, ama-aphostrophe azonyamalala futhi izinombolo zizothatha ifomethi efanele.

Ukukhipha izikhala ezengeziwe etafuleni

Izikhala ezengeziwe zifakwa kumathebula e-Excel ukuze kuhlukaniswe izinombolo ezinkulu zibe izingxenye noma ngephutha. Uma wazi ukuthi kunezikhala eziningi kakhulu kudokhumenti okungafanele zibe khona, sebenzisa Iseluleki Somsebenzi.

1. Khetha iseli yamahhala bese uvula iwindi Lomphathi Womsebenzi. Uhlu lwamafomula lungafinyelelwa ngokuchofoza isithonjana esithi “F(x)” eduze kwebha yefomula noma ngethebhu ethi “Amafomula” kubha yamathuluzi.

2. Vula isigaba esithi "Umbhalo", ufakwe ohlwini lwebhokisi lengxoxo noma kuthebhu ethi "Amafomula" njengengxenye ehlukile. Kufanele ukhethe umsebenzi we-TRIM. Isithombe sibonisa izindlela ezimbili.

3. Iseli elilodwa kuphela elingaba ukuphikisana komsebenzi. Sichofoza iseli oyifunayo, igama layo lizowela emugqeni wokungqubuzana. Okulandelayo, chofoza "OK".

4. Sigcwalisa imigqa eminingana, uma kunesidingo. Chofoza iseli elingaphezulu lapho ifomula itholakala khona bese ubamba umaka oyisikwele omnyama ekhoneni elingezansi kwesokudla. Khetha wonke amaseli lapho ufuna khona amanani noma umbhalo ngaphandle kwezikhala bese ukhulula inkinobho yegundane.

Kubalulekile! Akunakwenzeka ukusula lonke ishidi lezikhala ezengeziwe, kuzodingeka usebenzise ifomula kumakholomu ahlukene isikhathi ngasinye. Ukuhlinzwa kuthatha isikhathi esincane, ngakho-ke ngeke kube khona ubunzima.

Ungazisusa kanjani izinhlamvu ezikhethekile ezingabonakali

Uma uhlamvu olukhethekile embhalweni lungafundeki uhlelo, kufanele lususwe. Umsebenzi we-TRIM awusebenzi ezimweni ezinjalo, ngoba isikhala esinjalo phakathi kwezinhlamvu akusona isikhala, nakuba zifana kakhulu. Kunezindlela ezimbili zokusula idokhumenti ezinhlamvu ezingafundeki. Indlela yokuqala yokususa izinhlamvu ze-Excel ezingajwayelekile ukusebenzisa inketho ethi "Faka esikhundleni".

1. Vula iwindi lokumiselela ngenkinobho ethi “Thola bese ukhetha” kuthebhu eyinhloko. Elinye ithuluzi elivula leli bhokisi lengxoxo isinqamuleli sekhibhodi “Ctrl+H”.
2. Kopisha izinhlamvu ezingafundeki (isikhala esingenalutho abahlala kuzo) futhi uzinamathisele emugqeni wokuqala. Inkambu yesibili ishiywe ingenalutho.
3. Cindezela inkinobho ethi "Faka esikhundleni Konke" - izinhlamvu zizonyamalala eshidini noma kuyo yonke incwadi. Ungalungisa ububanzi kokuthi “Amapharamitha”, lesi sinyathelo sixoxiwe ngaphambili.

Ngendlela yesibili, siphinda sisebenzisa izici zeWizard Function. Isibonelo, masifake okufakiwe okunqamuke komugqa kwelinye lamaseli.

1. Isigaba "sombhalo" siqukethe umsebenzi we-PRINT, usabela kunoma yiziphi izinhlamvu ezingaphrinteki. Udinga ukuyikhetha ohlwini.

2. Sigcwalisa inkambu kuphela ebhokisini lengxoxo - kufanele kuvele igama leseli lapho kunohlamvu olwengeziwe. Chofoza inkinobho ethi "OK".

Ezinye izinhlamvu azikwazi ukususwa kusetshenziswa umsebenzi, ezimweni ezinjalo kufanelekile ukuguqulelwa esikhundleni.

• Uma udinga ukubeka enye into esikhundleni sezinhlamvu ezingafundeki, sebenzisa umsebenzi we-SUBSTITUTE. Le ndlela ibuye ibe usizo ezimweni lapho amaphutha enziwa emagameni. Umsebenzi ungokwesigaba "Sombhalo".
• Ukuze ifomula isebenze kahle, udinga ukugcwalisa izimpikiswano ezintathu. Inkambu yokuqala iqukethe iseli elinombhalo okushintshwa kuwo izinhlamvu. Umugqa wesibili ubekelwe uhlamvu olushintshiwe, emgqeni wesithathu sibhala uhlamvu olusha noma uhlamvu. Amagama amaningi aphinda izinhlamvu, ngakho izimpikiswano ezintathu azanele.

• Inombolo yesenzeko iyinombolo ebonisa ukuthi yiluphi uhlamvu olumbalwa olufanayo okufanele lushintshwe. Isibonelo sibonisa ukuthi uhlamvu lwesibili elithi “a” lwashintshwa, nakuba lisegameni ngendlela efanele. Masibhale inombolo 1 endaweni ethi “Inombolo yesenzeko”, umphumela uzoshintsha. Manje ungachofoza okuthi KULUNGILE.

Isiphetho

Isihloko sacabangela zonke izindlela zokususa i-apostrophe. Ngokulandela imiyalelo elula, umsebenzisi ngamunye uzokwazi ukubhekana nomsebenzi ngaphandle kwezinkinga.