Lapho usebenza kudokhumenti e-Excel, kwesinye isikhathi udinga ukusetha ideshi ende noma elifushane. Kungafunwa, kokubili njengophawu lwezimpawu embhalweni, nangesimo sedeshi. Kodwa inkinga ukuthi asikho isibonakaliso esinjalo kukhibhodi. Uma uqhafaza isithonjana kukhibhodi ebukeka njengedeshi, sithola ideshi elifushane noma Susa. Ake sibheke ukuthi ungasimisa kanjani lesi sinhlamvu esingenhla esitokisini ku-Microsoft Excel.
Funda futhi:
Ungayenza kanjani ideshi ende eZwini
Ungayifaka kanjani ideshi ku-Esquel
Izindlela Zokufaka Dash
Ku-Excel kunezinketho ezimbili zemeshi: ubude obude nokufushane. Lesi sakamuva sibizwa nge- "average" kweminye imithombo, okungokwemvelo uma siqhathaniswa nesibonakaliso "-" (hyphen).
Lapho uzama ukusetha ideshi ende ngokucindezela ukhiye "-" kukhibhodi esiyitholayo "-" - uphawu ejwayelekile Susa. Senzani?
Eqinisweni, azikho izindlela eziningi kakhulu zokufaka ideshi ku-Excel. Kukhawulelwe izinketho ezimbili kuphela: iqoqo lezinqamuleli zekhibhodi kukhibhodi nokusetshenziswa kwezinhlamvu ezikhethekile.
Indlela yoku-1: faka inhlanganisela yokhiye
Labo basebenzisi abakholelwa ukuthi ku-Excel, njengaseZwini, ungafaka udeshi ngokuthayipha kukhibhodi "2014"bese ucindezela inhlanganisela yokhiye I-Alt + X, elinde ukudumazeka: kumprosesa wethebula le ndlela ayisebenzi. Kepha elinye iqhinga liyasebenza. Bamba ukhiye Alt futhi, ngaphandle kokuyikhulula, sithayipha kukhiphedi yezinombolo "0151" ngaphandle kwezingcaphuno. Lapho nje sesikhipha ukhiye Alt, kuvela isikhathi eside kuselula.
Uma ubambe inkinobho Alt, thayipha kunani leselula "0150"bese sithola ideshi elifushane.
Le ndlela isendaweni yonke futhi ayisebenzi e-Excel kuphela, kodwa naseZwini, nakweminye imibhalo, itafula nabahleli be-html. Iphuzu elibalulekile ukuthi izinhlamvu ezifakwe ngale ndlela aziguqulwanga kwifomula, uma ususa isikhombisi esitokisini sendawo yazo, uyihlelele kwenye into yeshidi, njengoba kwenzeka nophawu Susa. Okusho ukuthi, lezi zinhlamvu zingumbhalo ocacile, hhayi izinombolo. Sebenzisa amafomula njengesibonakaliso Susa ngeke basebenze.
Indlela 2: iwindows izinhlamvu ezikhethekile
Ungase futhi uxazulule inkinga ngokusebenzisa iwindi lezinhlamvu elikhethekile.
- Khetha iseli ofuna ukufaka kulo ideshi, bese uqhubekela kwithebhu Faka.
- Bese uchofoza inkinobho "Symbol"etholakala kwibhulokhi yamathuluzi "Izimpawu" ekhasethini. Leli yibhulokhi lesokudla kunazo zonke ku-iribhoni kuthebhu Faka.
- Ngemuva kwalokho kwaqhamuka iwindi "Symbol". Iya kuthebhu yayo "Izinhlamvu ezikhethekile".
- Ithebhu yezinhlamvu ezikhethekile iyavula. Owokuqala ohlwini yilapho Ideshi Elide. Ukusetha lolu phawu kuseli elikhethwe ngaphambilini, khetha leli gama bese uchofoza inkinobho Namathiselaetholakala ezansi kwewindi. Ngemuva kwalokho, ungavala iwindi lokufaka izinhlamvu ezikhethekile. Sichofoza isithonjana sokuvala iwindi elijwayelekile ngendlela yesiphambano esimhlophe esikweleni ebomvu, esisekhoneni eliphezulu kwesokudla sewindi.
- Udeshi omude uzofakwa kushidi esitokisini esivele sakhethwa ngaphambili.
Udeshi omfushane ufakwa efasiteleni lesimpawu usebenzisa i-algorithm efanayo.
- Ngemuva kokuya kuthebhu "Izinhlamvu ezikhethekile" amawindi wophawu khetha igama Udeshi omfushaneisendaweni yesibili ohlwini. Bese uchofoza inkinobho ngokulandelana Namathisela nangesithonjana sokuvala iwindi.
- Udeshi omfushane ufakwa entweni eshidiweyo ekhethiwe ngaphambili.
Lezi zinhlamvu zifana ngokuphelele nalezo esizifakile ngendlela yokuqala. Inqubo yokufaka kuphela ehlukile. Ngakho-ke, lezi zinhlamvu nazo azikwazi ukusetshenziswa kumafomula futhi ziyizinhlamvu zemibhalo ezingasetshenziswa ngesimo sezimpawu zokuloba noma amachashazi kumaseli.
Sithole ukuthi amachashazi amade futhi amafushane ku-Excel angafakwa ngezindlela ezimbili: ngokusebenzisa isinqamuleli sekhibhodi kwikhibhodi besebenzisa iwindi lezinhlamvu elikhethekile, ngokuya kulo ngenkinobho kubambo. Izinhlamvu ezitholakala ngokusebenzisa lezi zindlela zifana ngokuphelele, zinokubhalwa kokufana okufanayo nokusebenza. Ngakho-ke, inqubomgomo yokukhetha indlela iyindlela elula yomsebenzisi. Njengoba umkhuba ukhombisa, abasebenzisi abavame ukufaka amachaphaza kumadokhumenti bakhetha ukukhumbula inhlanganisela yokhiye, njengoba le ndlela ishesha. Labo abasebenzisa lolu phawu lapho besebenza e-Excel ngezikhathi ezithile bakhetha ukwamukela inketho enembile besebenzisa iwindi lesimboli.
