Imida yeseli ye-Excel-sisombululo esisebenzayo

/ Ndiyinyusa njani i-cell padding kwi-Excel?

Indawo eyongezelelweyo phakathiiseliisicatshulwa kunye nasekhohlo okanye ekuneneiseliumda, cofa 'Ekhohlo (Indent)' okanye 'Ekunene (Indent).' Cofa kwindawo ethi 'Distributed (Indent)' ukuze ulinganeizithubaphakathi kokubhaliweyo kunye nefayile ye-iseliimida kumacala omabini. Kwibhokisi 'ye-Indent', khetha ubungakanani bokongezwa kwakhoizithuba.NgoJanuwari 9. 2020

Yonke incwadi yomsebenzi yahlukile kwi-Excel.

Oku kuthetha ukuba unokufuna ukutshintsha izinto ezithile, ezinje: Umzekelo, ubungakanani kunye nokubekwa kweeseli zakho ukuze zilungele idatha osebenza nayo. Umzekelo, le kholamu yaphinde yacwangciswa, kodwa ayonelanga ngokwaneleyo - uninzi lweeteksti zisanqunyulwa. Ndizokunyusa ububanzi kancinci ngokubeka i-mymouse ngaphezulu komgca okwintloko yentloko, emva koko ucofe kwaye uyihudulele ngasekunene.

Oku kuya kulungelelanisa ngokuzenzekelayo ububanzi ukuze bulingane ngokuchanekileyo nemixholo yeeseli. Cofa nje kabini kumgca endaweni yokurhuqa. Ngoku ikholamu bubungakanani obugqibeleleyo bokubhaliweyo.

Imigca isebenza ngendlela efanayo. Ungazilungelelanisa ngesandla okanye uhlengahlengise ngokuzenzekelayo ubungakanani kubude besicatshulwa sakho. Ngamanye amaxesha kuyanceda ukukhulisa ubungakanani bazo zonke iiseli ngaxeshanye.

Kulo mzekelo ndifuna ukuseta yonke imigca yam ukuya kubude obufanayo. Ukwenza oku, cofa indawo ethi KhethaAll kwikona ephezulu ngasekhohlo. Emva koko utshintshe ubungakanani bomqolo (nokuba yeyiphi) ... kwaye utshintsho luyasetyenziswa kwiphepha elipheleleyo lomsebenzi.

Okulandelayo ndifuna ukongeza omnye umgca kolu luhlu. Ndingathanda ukuyifaka phakathi komgca 4 kunye nomgca 5. Ukongeza umgca omtsha, konke okufuneka ukwenze kukukhetha umgca wesihloko esingezantsi apho umgca omtsha unokuvela khona.

Emva koko ucofe Faka ... umyalelo.

Inkqubo iyafana nokufaka ikholamu entsha. Khetha ngokulula ikholamu esiya ngasekunene kwendawo oyifunayo. Cofa kwi-Insert ... myalelo kunye nekholamu iya kuvela ngasekhohlo.

Ukucima iikholamu kunye nemiqolo kulula. Kuqala khetha ikholamu okanye umqolo ofuna ukuwucima ... emva koko ucofe cima umyalelo.

Ikholamu okanye umqolo uyacinywa, ohambisa ezinye iiseli kwaye ngokuzenzekelayo ugcwalise isikhewu. Khumbula, kukho umahluko phakathi kokucima nokucima: ukucima iiseli kuzisusa kwiphepha lakho lokusebenzela; ukuzicima kususa imixholo yazo. Ungasa kwakhona ikholamu okanye umqolo kwindawo eyahlukileyo.

Kulo mzekelo sihambisa ikholamu. Konke okufuneka ukwenze kukukhetha ikholamu oyifunayo emva koko ucofe i Sika myalelo. Emva koko, khetha ikholamu ngasekunene kwikholamu ofuna ukuhambisa kuyo ikholamu.

Kwiribhoni, cofa Fakela… imenyu ehlayo, emva koko ukhethe Faka iiseli ezisikiweyo. Enye indlela eluncedo yokulungisa idatha kwakhona kukufihla iikholamu ezithile okanye imiqolo. Umzekelo, andidingi kubona ezi kholamu zintathu ngoku; Ndikhetha ukugxila kwiidilesi ze-imeyile zabathengi.

Ukuba sicofa ngeqhosha lasekunene le mouse ... emva koko ukhethe Fihla kwimenyu ... iikholamu zifihliwe okwexeshana.

Ukuyibonisa, khetha iikholamu ngapha nangapha kwendawo efihliweyo ... emva koko ucofe ekunene kwakhona ... kwaye ukhethe Veza ...

Okulandelayo, ndifuna ukujonga ukophuka komgca. Le yindlela yokujongana neeseli ezinombhalo ongaphezulu kunokuba zinokubonisa. Umzekelo, ndifuna ukuphinda ndenze ubungakanani kwakhona kwikholamu yam yedilesi malunga nesiqingatha sobukhulu obukhoyo ngoku, kodwa ndisawubona umxholo.

Singakwenza oku ngomyalelo osongelayo kwiRibhoni. Njengoko ubona, isicatshulwa siboniswa kwimigca eliqela. Ngoku ukuthintela ukugqitywa-ngokudibanisa iiseli kumqolo ongaphezulu ukuze isihloko sephepha lam lomsebenzi sigxile kwiseli enye enkulu.

Ukwenza oku, khetha iiseli ofuna ukuzidibanisa, emva koko ucofe umyalelo wokudibanisa kunye neziko. Oko kugqibelele. Ukufikelela kwiinketho ezininzi zokudibanisa, vula imenyu ehlayo apha.

Ungadibana wenze imigca edityanisiweyo endaweni yeseli enye enkulu (xa uneeseli ezininzi ezikhethiweyo). Unokudibanisa ngaphandle kokufaka okanye ukwahlula iiseli zakho kwakhona. Kukho ukubuyela umva ekusebenziseni ukudibanisa umyalelo, nangona kunjalo.

Ukuba ufuna ukudibanisa iiseli ezininzi, nganye inedatha, Hlanganisa ukugcina nje imixholo yeseli ephezulu yasekhohlo kwaye ulahle yonke enye into. Ke kuya kufuneka ulumke xa usebenzisa le nto ...

Eyona ndlela ifanelekileyo yokufunda ukudibanisa iiseli, ukusonga isicatshulwa, kunye nokusebenza neekholamu kunye nemigca kukuziqhelanisa. Ngexesha elizayo usebenzisa i-Excel, jonga iindlela zokwenza ngcono iphepha lokusebenzela kwidatha yakho.

Yintoni umgama weseli?

Inkqubo ye-umda weselingumgama phakathi kweiseliumda kunyeiseliimixholo kwaye icacisiwe kuwo omane amacala eiseli(okanye itafileiselikwi-HTML ebonisiweyo). Inkqubo ye-ukushiyana kweselingumgama phakathi kweiiselikwaye icacisiwe kwiphepha lonke (okanye itafile kwi-HTML ebonisiweyo).

Nje ukuba iitafile zakho zibonakale zintle kwaye zinemibala, njengoko sisenza kwifayile yetafile yedatha, inemibala kodwa ingekho ngaphezulu, sinokufuna ukuqala ukuvavanya ukulungelelaniswa komxholo kwiseli nganye okwangoku.

Ngokuzenzekelayo, ulungelelwaniso lugcinwa kuzo zonke iiseli zethu. Umxholo ulungelelaniswe ngasekhohlo. Ngoku unokuhlengahlengisa ulungelelwaniso ukusuka kwiribhoni eqhelekileyo yasekhaya apho sabona khona ulungelelwaniso lomhlathi kwaye sinokuthi sikubeke kwaye siyakubeka iiseli esizikhethileyo embindini.

Singaya ngasekunene kwaye sinokulungelelaniswa nangona uhlala esiseleni unolwazi oluncinci kwaye ulungelelwaniso alusebenzi ncam liziko lasekhohlo nelasekunene okanye singaya kwizixhobo zeetafile iibhendi kunye nawe Uyakuqaphela ukuba ulungelelwaniso lukhetho olunokukhetha ngaphezulu kokunene ekhohlo nasekunene. Sineziko eliphezulu kunye nezantsi kuba sinako ukulawula ukuphakama komgca. Ke ukuba bendizakuthatha yonke imigca yam apha umzekelo, yonyusa nje ukuphakama kwayo kancinci, uyakubona ukuba isicatshulwa sihlala sinje nge-topof yeseli, ngoko ke ulungelelwaniso olungagqibekanga, nangona luthe tyaba lumile nkqo, luphezulu kwaye ngamanye amaxesha ufuna ukuzisa ifonti kunye nesicatshulwa kunye nomxholo phantsi kancinci.

Ke ukuba ndizikhetha zonke ezi seli kwakhona kwaye ndiye kukhetho lokulungelelanisa, ukuseta okungagqibekanga apha kuhleli phezulu kwaye kushiyeke kakuhle ndingathanda ukulungelelanisa iziko kunye nokushiya kwaye uyabona ukuba isicatshulwa sise nkqo embindini, ngoku nayiphi na kwezi inokutshintsha ubume bayo obuthe tyaba, umzekelo ipesenti yehlabathi. Masibhale umgca ngokuthe tye kodwa silungelelanise ngokuthe nkqo zonke ezi seli zichaphazelekayo ndinokufuna ukuzisa ezi seli kancinci kwaye ndifuna ukwenza ngokufanayo nabemi. Masizilungelelanise ngokuchanekileyo kodwa sizibeke ngokuthe nkqo kwaye emva koko sizise le seli kancinci ngoku kunye nokulawula ulungelelwaniso lomxholo wakho wokubhaliweyo ngokuthe tye, iziko lasekhohlo nasekunene kwaye ngokuthe nkqo kwiziko eliphezulu nasezantsi, sinokufuna ukunika iseli nganye Umoya othile wokuphefumla uyabona ukuba nangona ezi seli zilungelelaniswe ngokuchanekileyo asifikeleli emaphethelweni kwaye ziyafana neeseli ezilungelelaniswe ngasekhohlo ezingafikeleli ngokupheleleyo emphethweni.

Oku kungenxa yemiphetho yeseli. Imida ilawulwa kwicandelo elifanayo elincinci leqela lokulungelelanisa kwaye siyabona ukuba ngokungagqibekanga imida ephezulu neyasezantsi ayinayo imida, ke konke ukuba umgca unganyukela kumqolo ophezulu, kodwa kukho isuntswana lasekhohlo kwaye kwicala lasekunene lasekunene kuthintela isicatshulwa ukuba siye ekunene ukuya ekhohlo kunye nesicatshulwa sihambe ekunene ukuba ndibeka oko ku-zero kwaye ke kulungile uya kubona ukuba sifumana isicatshulwa sicofa ekunene ukuya ekhohlo nasekunene ukuya ekunene, ke u-0 akulunganga, yiyo loo nto okungagqibekanga kungu-0, ke ukuba ndiyashenxisa ukuba siza kubuyela kuseto olungagqibekanga kodwa emva koko ndinokuzilungelelanisa kwakhona kwimida yeseli, mhlawumbi ufuna ukuya phezulu ukuze ubone isicatshulwa oza kusinika umoya omncinci wokuphefumla, kwaye emva koko sinendawo ethe kratya phakathi kokuqulathiweyo kunye nelungelo kunye nemixholo kwicala lasekhohlo leseli nganye, ukuze imida yeseli kunye ne-txtalignment isivumele ukwenza itafile ukuba ibonakale ngakumbi, njengaxa sifaka umbala omncinci, hayi ngaphezulu nangaphezulu kwaye silawula imida yethu, i-ve Ukulungelelaniswa kwe-rtical kusivumela ukuba sitshintshe umda weseli ukuze umphezulu weseli ube nomda omncinci. Masiye kwindawo efanayo yokufumana ixabiso, hayi ezisibhozo zilungile, kwaye uyabona ukuba oku kwehlisa imixholo ngaphakathi kweseli ngaphandle kokwenza inketho yokugweba ethe nkqo.

Sidibanise nje umda ophezulu ukuze le ibeyenye indlela yokufumana iziphumo ezifanayo ezibonisa ukuba isicatshulwa asizinzanga ngokuthe nkqo kodwa sishenxise nje kancinci phezulu ngelixa sikweli qela lolungelelwaniso, sinokuphanda Okwangoku isicatshulwa sethu sihamba ukusuka ekhohlo ukuya ekunene, ukuba ucofa kwicala lesicatshulwa uya kubona ukuba iyahamba, kodwa kuphela yiseli ebesiyikhethile njalo lo mfo sele eye ngokuthe nkqo phantsi ukuba i cofa kuyo kwakhona emva koko inyuke ngokuthe nkqo ukuba ndiyayicofa kwakhona iphinde ibuye ngokuthe tye, ebonakala ngathi iyaphambana kwaye iyabhanxa ngoku, kodwa inokuba luncedo kakhulu kwaye sitshintshe nje ukuphakama kwesi sitrato ukuyibuyisa ukuba Ndongeza ikholamu apha ngasekhohlo. Ukudibanisa zonke iiseli kunye onke amanyathelo esiwagwebileyo.

Hlanganisa zonke ezi seli kwaye uzifake apha buqu ngo-2013 ke into endinokuyenza kukutshintsha isicatshulwa, ukutshintsha loo ndlela yokubhaliweyo ukuze ijikeleze kwaye ngoku ikwicala layo oko kuthetha ukuba ndinokunciphisa loo nto, kuyacaca ubesembindini, kakuhle olutshintsha ulungelelwaniso apha, kwaye uyabona zonke ezi zijikelezile ngokunjalo. Ngoku ukuba kukho indibaniselwano yemizamo eyenziwayo yokudibanisa, ukutshintsha ulungelelwaniso lokubhaliweyo, kunye nokulungelelanisa ngaphakathi kweseli ngokwayo utshintshe ngasekhohlo ukuze ufake ubeko ngasekhohlo udibanise zonke ezi seli kunye nabemi 2013 kwaye utshintshe indlela yokubhaliweyo ejikeleze umdlalo uye ngasekunene uyabona lutshintsho nje olujikajika kukhetho lokutshintsha ulungelelwaniso luhleli kwisilayidi esiphakathi ubungakanani befonti ukuyenza emva koko imxinwa ikholamu nditshintshe ububanzi bekholamu, ndatshintsha ulungelelwaniso lombhalo, ulwalathiso lombhalo lutshintshile lwaza lwadibanisa iiseli ukuya Yenza ikholamu encinci entle esezantsi ngasekhohlo ethi ijikeleze kakuhle itafile kwaye iyenze ibonakale ngakumbi

Uwutshintsha njani umda weseli kwi-Excel?

Ukulungelelanisa imida yeseli kufuneka utshintshe ububanzi bekholamu yonke. Zonke iiseli ezikulo kholamu ziya kuba nobubanzi obulinganayo. Unokufomatha okubhaliweyo kwiseli ukuze uhlengahlengise ubungakanani bayo kunye nokubonakala kwayo. Isicatshulwa esibanzi ngakumbi kunekholamu siya kuphuphuma kwisisele esingenanto ekunene.

Ndingawutshintsha njani umda wetafile?

Awunakho ukutshintsha imida yazo zonke iiseli ukuya kwezo zeseli apho imida itshintshiwe khona ngencoko yencoko yababini yeSeli, ngokujonga kwakhona ibhokisi 'Efana nencoko yonke yencoko yetafile'. Kuya kufuneka ngokuqinisekileyo ungayiqwalaseli loo bhokisi ukuze ukwazi ukutshintsha imida yeseli ethile.

Umsebenzi wolungelelwaniso ngokuthe nkqo kwi-Excel cell margins?

Jonga iifomathi zeAccounting kunye nezeNombolo ezibandakanya ukusetyenziswa kwe _ (kunye _). Ukulungelelana nkqo kuya kwenziwa ngaphambili ngolungelelwaniso olumi nkqo kunye nohlengahlengiso lokuphakama komqolo. Ngaba le mpendulo iluncedo?

uphawu lwecandelwana

Ndilwenza njani utshintsho kububanzi beseli kwi-Excel?

Ukulungelelanisa imida yeseli kufuneka utshintshe ububanzi bekholamu yonke. Zonke iiseli ezikulo kholamu ziya kuba nobubanzi obulinganayo. Unokufomatha okubhaliweyo kwiseli ukuze uhlengahlengise ubungakanani bayo kunye nokubonakala kwayo.