Ungayibeka njani i-dash egqwetha

Abasebenzisi abaninzi abaphezulu xa bezama ukubeka ideshibhodi eshishino, kukho ubunzima obuninzi. Inyani yile yokuba inkqubo iyayiqonda i-dash, njengomqondiso otyatyayo, kwaye kwangoko iguqula amaxabiso kwiseli kwifomula. Ke ngoko, lo mbuzo ucinezela. Makhe siyifumane indlela yokubeka i-dash egqwesini.

I-Digger kwi-Exlole

Rhoqo, xa ugcwalisa amaxwebhu ahlukeneyo, iingxelo, izibhengezo kufuneka zicaciswe ukuba iseli ehambelana nesalathiso esithile ayinamaxabiso. Ngeenjongo, kulisiko ukusebenzisa ukutshixiza. Kwinkqubo ye-Excel, eli nqaku, likhona, kodwa ukuze umntu ongumsebenzisi ongalungiswanga yingxaki, njengoko i-downer iguqulwa kwangoko ibe yifomula. Ukuphepha olu tshintsho, kufuneka wenze isenzo esithile.

Indlela yoku-1: Uluhlu lwefomathi

Eyona ndlela idumileyo yokubeka idummy kwiseli kukwabelana ngefomathi yokubhaliweyo. Kuyinyani, olu khetho aluhlali luncedo.

1. Sibonisa iseli apho kufuneka ubeke ideshibhodi. Cofa kuyo kwiqhosha le mouse lasekunene. Kwimenyu yokujonga, khetha into yefomati yeseli. Ungayicinezela ikhibhodi ye-CTRL + kwikhibhodi kwikhibhodi endaweni yezi zenzo.



2. Ifestile ekufomeli iqalile. Yiya kwi "Number" ithebhu ukuba ivuliwe kwenye ithebhu. Kwimidlalo ye "fomus" zamanani, khetha into "yokubhaliweyo". Cofa kwiqhosha "Kulungile".

Emva kwale, iseli ekhethiweyo iya kunikwa ipropathi yefomati yesicatshulwa. Onke amaxabiso angeniswe kuyo akasayi kuthathwa njengezinto zekhomputer, kodwa njengesicatshulwa esilula. Ngoku kule ndawo, ungangenisa isimboli "-" ukusuka kwikhibhodi kwaye iya kuboniswa ngokuchanekileyo njenge-downer, kwaye ayiyi kwabonwa yinkqubo njengo "tyabs".

Kukho enye indlela yokutshintsha iseli kwifom yesicatshulwa. Ukwenza oku, ngelixa kwithebhu yasekhaya, kuya kufuneka ucofe kuluhlu olusezantsi lweefomathi zedatha, ezikwi-tepi kwi-Toolbar "yenombolo". Uluhlu lweentlobo ezikhoyo zefomathi zivuliwe. Kolu luhlu kufuneka ukhethe into "yokubhaliweyo".

Isifundo: Indlela yokutshintsha ifomathi yeseli kwi-Excel

Indlela 2: Ukucinezela iqhosha lokungena

Kodwa le ndlela ayisebenzi kuzo zonke iimeko. Rhoqo, kwanasemva kokuba enze le nkqubo, xa ungena kwi "-", onke amakhonkco afanayo ukuya kwezinye iindawo ezibonakala endaweni yophawu olufunwayo. Ukongeza, akusoloko kufanelekile, ngakumbi ukuba kwitheyibhile yeeseli ezihamba ngeentlukhwe ezizinye zeeseli ezizaliswe yidatha. Okokuqala, kule meko kuya kufuneka ifomameta nganye nganye, okwesibini, iiseli zele theyibhile ziya kuba nefomathi eyahlukileyo, engasoloko yamkelekile. Kodwa unokwenza ngokwahlukileyo.

1. Sibonisa iseli apho kufuneka ubeke ideshibhodi. Cofa kwiqhosha "Ngokulungelelanisa kwiziko", elikwiteyiphu kwithebhu yasekhaya kwibar ye-Isnesity. Kwaye kwakhona ucofe iqhosha u "Lungelelanisa embindini", ubekwe kwibhloko efanayo. Kuyimfuneko ukwenzela ukuba umngxunya ubekwe kanye embindini weseli, njengoko kufanele ukuba ibe njalo, kwaye hayi ngasekhohlo.



2. Siqesha "-" uphawu kwiseli. Emva koko, musa ukwenza nayiphi na intshukumo kunye nemouse, kwaye ngoko nangoko cinezela iqhosha lokungena ukuya kumgca olandelayo. Ukuba, endaweni yoko, umsebenzisi ucofa imouse, emva koko kwiseli, apho idabi limi khona, kuya kuphinda kubonakale ifomula kwakhona.

Le ndlela ilungile ngokulula kwaye isebenza ngayo nayiphi na ifomathi. Kodwa, kwangaxeshanye, kuyisebenzisa, kuyimfuneko ukuba unyamekele imixholo yeseli, okoko ngenxa yesenzo esinye esingalunganga, ifomula iphinde iboniswe endaweni yefibre.

Indlela 3: Ukufaka uphawu

Enye inguqulelo yokubhala i-fiber ukuya kwi-Excel kukufakelwa kophawu.

1. Sibonisa iseli apho kufuneka ufaka khona i-duct. Yiya kwi "Faka" ithebhu. Kwiteyiphu kwi "Sys" Ibloko yebhloko yesixhobo ngokunqakraza kwiqhosha "leSimboli".



2. Ukuba kwi "phawu" ithebhu, zimise imiqondiso "yezakhelo" kwifestile "yewindows". Kwinxalenye ephakathi yefestile sifuna uphawu "─" kwaye lilulase. Emva koko cofa iqhosha "Colas".

Emva koko, i-lattlefield iya kubonisa iseli ekhethiweyo.

Kukho olunye ukhetho ngaphakathi kule ndlela. Ukuba kwindawo "yesimboli", yiya "kwimiqondiso ekhethekileyo" ithebhu. Kuluhlu oluvula, labela loo nto "idash ende". Cofa kwi "Compai". Iziphumo ziya kufana njengakwinguqulo yangaphambili.

Le ndlela ilungile kuba ayizukuyimfuneko ukoyika okwenziwa kukuhamba okungalunganga kwempuku. Isimboli asiyi kutshintsha kunjalo kwifomula. Ukongeza, ibhetri enikezelwa ngale ndlela ibukeka ilunge ngakumbi kunemilinganiselo emfutshane efunyenwe kwikhibhodi. Eyona nto iphosakeleyo kolu khetho yimfuno yokwenza ukugqwetha okwethutyana, nto leyo ibandakanya ilahleko yethutyana.

Indlela yesi-4: Yongeza uphawu olongezelelweyo

Ukongeza, ikho enye indlela yokubeka umsele. Kuyinyani, olu khetho alukho mkelekile kubo bonke abasebenzisi, njengoko luthatha ubukho besisele, ngaphandle komqondiso "-", omnye uphawu.

1. Sibalaselisa iseli apho kufuneka ufaka ideshibhodi, kwaye usete umlinganiswa "'" "" "" "" "" ". Ibekwe kwiqhosha elifanayo njengeleta "e" kwisakhiwo se-cyrillic. Ke ngoko nangoko ngaphandle kwendawo ebeka uphawu "-".



2. Cofa kwiqhosha le-ENTER okanye ubalaselisa isikhombisi usebenzisa imouse nasiphi na isisele. Xa usebenzisa le ndlela, oku kubaluleke kakhulu. Njengoko ubona, emva kwezi zenzo, kufakwe idyokhwe ephepheni, kunye nomlinganiswa ongezelelweyo "'" "phawuleka kuphela kumgca wefomula ngexesha lokhetho lweseli.

Kukho inani leendlela zokufaka ibhetri, ukhetho oluphakathi komsebenzisi ngokwenza umsebenzi othile. Uninzi lwabantu kwinzame yokuqala engaphumelelanga ukubeka isimboli oyifunayo izama ukutshintsha ifomathi yeseli. Ngelishwa, oku akusoloko kuqiniswa. Ngethamsanqa, kukho ezinye iindlela zokwenza lo msebenzi: utshintsho komnye umtya usebenzisa iqhosha lokungena, ukusetyenziswa kwabalinganiswa ngeqhosha leteyiphu, ukusetyenziswa kophawu olongezelelweyo "'". Nganye kwezi ndlela zinezibonelelo zayo kunye nezinto ezingalunganga ezachazwe apha ngasentla. Inguqulelo yendalo iphela, eya kuthi ilungele ukufaka ufakelo lwe-Deadcking kwi-Prese kuzo zonke iimeko ezinokwenzeka, ayikho.