Jonga utshintsho kwifayile ye-Excel: isikhokelo osifunayo

Xa sabelana ngespreadsheets, kuyinto eqhelekileyo ukuzibuza ukuba umntu ngamnye uchukumise ntoni kwaye nini. Jonga izilungiso kwifayile ye-ExcelNamhlanje sineendlela ezininzi onokukhetha kuzo: Iphaneli yoMboniso yoTshintsho, iMbali yeNguqulo kwaye, kwiimeko eziqhelekileyo, igqala elithi "Track Changes".

Kweli nqaku sichaza yenziwa njani, yeyiphi imida ekukhethweni ngalunye, kwaye zeziphi ezinye iindlela ezikhoyo Ukuba usebenza ngaphandle kwelifu, kunye nezinye iingcebiso ezisebenzayo.

Yintoni "Bonisa utshintsho" kwi-Excel kwaye luluphi ulwazi olubonisayo?

Uphawu loMboniso loTshintsho lubeka embindini ingxelo yokuhlelwa kwamva nje kwincwadi. Iphaneli yayo ibonisa utshintsho olutsha phezulu, ikuvumela ukuba uchonge ngokweenkcukacha. ngubani owenza ulungiso, iseli echaphazelekayo, ixesha elichanekileyo, kunye nexabiso langaphambiliIluncedo ngakumbi xa abantu abaninzi behlela ifayile ekwabelwana ngayo kwaye ufuna ixesha elicacileyo.

Eli candelo lolawulo likuvumela ukuba ujonge kwakhona uhlengiso olwenziwe "ngobuninzi". Kwezi meko, I-Excel Ivelisa ikhadi elinentshukumo eninzi kwaye ibonelela ngofikelelo ku "Jonga iiNguquko" ngaphakathi kwelo khadi, ukuze ukwazi ukukhangela nzulu iinkcukacha zohlengahlengiso ngalunye lwamaqela ngaphandle kokuphulukana nomxholo.

Gcina ukhumbula ukuba i-Excel igcina umsebenzi wamva nje kule njongo, ibonelela ngokubonakala ukuya kuthi ga kubuninzi be malunga neentsuku ezingama-60Ukuba ufuna ukwandisa ixesha lokuhlola ukuba bekusenzeka ntoni ngaphambili, iya kuba lithuba leMbali yoHlelo, esiza kuthetha ngayo kamva. hamba uye kwiinguqulelo zangaphambili kwaye uzihlole ngaphandle kokumangalisa.

Jonga utshintsho kuyo yonke incwadi: amanyathelo akhawulezayo

Uphononongo olubanzi lwencwadi yomsebenzi kunye nokujonga uhlengahlengiso kwifayile ye-Excel, inkqubo ilula kakhulu kwaye ikuthatha ikuse kwiqela lolawulo nalo lonke uhlelelo olwenziwe kutshanje. Ngala manyathelo, uya kukwazi ukubona ngoko nangoko. yonke into eyenzekayo kwifayile:

1. Kwi Uphononongo thebhu, khetha Veza utshintsho ukuvula indawo yolawulo ngohlelo lwakutsha nje.
2. Qaphela ukuba utshintsho lubonakala lucwangcisiwe kunye nolona lwamva nje phezulu, lubonisa olona landelelwano lobalo-maxesha yokwenza.
3. Uya kukwazi ukuchonga ukuba ngubani otshintshe into kwaye kweyiphi iseli, kunye nomhla kunye nexesha, nto leyo eyenza kube lula. intsebenziswano yophicotho.
4. Ukuba kukho ukuhlelwa okuninzi, uya kufumana ikhadi elisebenza ngokwamaqela kunye neqhosha Bona utshintsho kwaye ujonge kulungiso ngalunye olubandakanyiweyo.

Hluza utshintsho ngokweshiti, uluhlu, okanye iseli ethile

Xa ufuna ukunciphisa ugxininiso lwakho, unokujonga utshintsho kwifayile ye-Excel kwiphepha elithile kuphela, uluhlu, okanye iseli enye. Olu luhluzo lukunceda ukuba uphande ngokweenkcukacha. kwenzeka ntoni kwindawo ethile kwincwadi ngaphandle kwengxolo eyongezelelweyo.

Ukucoca ngokukhawuleza kwiphepha: khetha iphepha, uluhlu, okanye iseli enye, emva koko cofa ekunene ukuvula imenyu yentsingiselo kwaye ukhethe. Veza utshintshoNgesi senzo, i-Excel ithintela indawo yolawulo ukuba ibe olo khetho.

Ungahluza kwakhona kwiqela lenjongo yotshintsho ngokwayo. Phezulu, uza kubona i icon yokucoca: ukuyikhetha kuya kukuvumela ukuba uchaze ukuba uyafuna na ukuhluza nge... Uluhlu okanye ngo IphephaUkuba ukhetha Uluhlu, chwetheza uluhlu okanye iseli kwibhokisi yokubhaliweyo kwaye uqinisekise nge icon yotolo ecaleni kwalo mhlaba ukusebenzisa i hluza ngoko nangoko.

Le ndlela yokucoca ikugcina ixesha elininzi xa uphanda iziganeko okanye xa kufuneka ugxininise indawo ebalulekileyo kwiphepha (umzekelo, uluhlu apho iitotali zibalwe khona okanye apho umntu atshintshe iimbekiselo).

Uphi umsebenzi othi "Bonisa iiNguqulelo" kwaye zithini iimfuno zokubhalisa yonke into?

Bonisa Utshintsho luyafumaneka kuzo zombini i-Excel ye-desktop kunye ne-Excel yewebhu, kwaye ibonisa kwiphaneli yayo ukuhlelwa okwenziwe kwi-Excel izicelo eziyixhasayo. ngokubambisanaOku kuthetha ukuba, ukubona eyona mbali ipheleleyo kwideshibhodi, bonke abasebenzisi kufuneka basebenzise i-app ehambelanayo ye-Excel kwaye basebenze kunye nefayile kwiindawo apho. gcina upapasho ngokubambisana esebenzayo (umzekelo, i-OneDrive okanye i-SharePoint).

Kuthekani ukuba ideshbhodi ibonakala ingenanto nangona uyazi ukuba bekukho umsebenzi? Izenzo ezithile zinokubangela ukuba i-Excel isuse loo log. Uya kubona ideshbhodi engenanto ukuba umntu, umzekelo, ehlelwe ngokuthenga kwexesha elinye okanye uguqulelo oludala lwe-Excel olungahambelani nokubhala ngokubambisana, okanye ukuba imisebenzi ibisetyenziswa loo nto. Azihambelani kunye nokushicilela ngokubambisana okanye ukuba ifayile i kwatshintshwa okanye ikopi yagcinwa, ukwaphula ukuqhubeka kokubeka iliso.

Iindaba ezimnandi zezokuba, ukusuka apho ukuya phambili, naluphi na utshintsho olutsha olwenzayo okanye omnye umntu kwii-apps ezihambelanayo ziya kufakwa kwakhona kwiphaneli yoTshintsho. Oku kubuyisela ukubonakala kwiziganeko ezilandelayo kwaye ikuvumela ukuba wenze njalo landela umkhondo ngaphandle kokwenza kwakhona uxwebhu.

Zeziphi iinguqu ezirekhodiweyo nezingaboniswanga kwiqela lolawulo

Iphaneli yoTshintsho ilungiselelwe iifomyula kunye namaxabiso eseli, kunye nemisebenzi efana nokushukuma, ukuhlela, ukufaka, okanye ukucima iiseli kunye noluhlu. Ke ngoko, uya kufumana ngokucacileyo zombini ukuhlelwa okukodwa kunye notshintsho lwesakhiwo oluchaphazelayo iibhloko zedatha.

Nangona kunjalo, ezinye iintshukumo aziboniswa okwangoku: uhlengahlengiso kwimizobo, iimilo, okanye ezinye izinto, iintshukumo, okanye izicwangciso kwi. iitafile zepivotOku kuquka utshintsho lokufomatha (imibala, iifonti, izimbo), ukufihla iiseli/uluhlu, kunye nokusebenzisa izihluzi. Gcina oku engqondweni, kuba olu "ungqimba olubonakalayo" alubonakali kwiqela lolawulo, eligxininisa kwimisebenzi ephambili. amanani kunye nokusebenza.

Ngaphaya koko, ukubonelela ngeyona mbali ipheleleyo inokwenzeka, i-Excel inokushiya izikhewu kumda wexesha ukuba utshintsho oluthile alukho. Ngenxa yoko, unokuqaphela "ukutsiba" xa uhlela, ngenxa yobume babo okanye isixhobo esisetyenzisiweyo, lungenziwa. irekhodi kwiqela lenjongo.

Kutheni amaxabiso angaphambili ngamanye amaxesha engekho kwamanye amangeno? Oku kunokwenzeka xa idatha iguqulwa kusetyenziswa ikhowudi (umzekelo, i-VBA okanye i-add-ins) okanye ukuba umntu uhlele incwadi yomsebenzi nge-Excel ngaphandle kokuhlaziya. inguqulelo yamva njeKwiimeko ezinjalo, ukulandeleka "kwexabiso phambi/kwexabiso emva" kunokulahleka ngenxa yeso senzo sithile.

Ulujonga njani utshintsho oludala: Imbali yenguqulelo

Iphaneli yotshintsho ibonisa olona tshintsho lwangoku; ukuba ufuna ukwandisa ixesha, sebenzisa i Imbali yenguquleloUkusuka kwiFayile> Ulwazi> Imbali yoguqulelo, unokuvula inguqulelo yangaphambili ukuze uyijonge kwaye, ukuba kuyimfuneko, uyibuyisele. Oku kuluncedo kakhulu xa uphanda iziganeko zangaphambili kuluhlu olubonisa utshintsho lwamaqweqwe.

Imbali yoguqulelo ayifani "nomlinganisi obonakalayo" phakathi kwamanqaku amabini ngexesha: injongo yayo kukuvumela ukukhangela kwiifayile zefayile, kunye nokukwazi ukuvula inguqulo yangaphambili kunye nokusebenza kuyo. Nangona kunjalo, ukudibanisa eli nqaku kunye noBonisa utshintsho kunokubonelela ngombono olungeleleneyo. ngokukhawuleza nakutshanje ngophicotho lwexesha elide.

Ukuba ifayile yakho ihlala kwiSharePoint, khumbula ukuba ulawulo loguqulelo lunemida eqwalaselweyo. Ngexesha lokucwangcisa, unokuseta inani eliphezulu leenguqulelo ofuna ukuzigcina, kwaye xa inkqubo ifikelela kumda, isusa inguqulelo yokugqibela. endala ukuvulela abasebatsha indawo. Ukuba ufuna i-leeway engaphezulu, kuyenzeka ukuba unyuse elo nani ukuya kuthi ga kumda wenkqubo, nto leyo ephucula ukukwazi ukubuyela emva kwixesha uphando olunzulu.

Kumaqela athembele kwiinguqulelo zembali, kuyacetyiswa ukuba uphonononge oku kucwangciswa rhoqo kwithala leencwadi leSharePoint kwaye ulungelelanise ukuhamba komsebenzi: utshintsho oluninzi lwemihla ngemihla, kokukhona lwenza ingqiqo ukwandisa inani iinguqulelo ezibanjiweyo ukuze ungalahlekelwa ngumkhondo oluncedo.

Ukuseta kwakhona iPheyini yoTshintsho: Nini kwaye njani

Kwi-Excel yewebhu, kukho ukhetho lokucima imbali yotshintsho oyibonayo kwiDashboard. Ibekwe phantsi kweFayile> Ulwazi, kwaye iqinisekisa ukuba iya... coca indawo yolawulo kubo bonke abasebenzisi bencwadi. Sisenzo esingenakuguqulwa kwaye, ke ngoko, kufuneka siqwalaselwe ngononophelo phambi kokuba siqhutywe ukuba ufuna ukugcina ubungqina intsebenziswano yakutshanje.

Nokuba ucima oko kungeno kwiqela lenjongo, usenako ukuvula okanye ukubuyisela iinguqulelo zangaphambili ngeMbali yoHlelo. Ngamanye amazwi, ususa "uluhlu lwesiganeko" kwiqela lenjongo, kodwa awuphulukani namandla okwenza buyela kumazwe angaphambili yefayile nje ukuba ezo nguqulelo zikhona kwindlela.

"Utshintsho loMkhondo" lwakudala kwi-Excel: ibonelela ngantoni kunye nendlela yokuyiphonononga

Kangangeminyaka, inkqubo ibibonisa inkqubo yemveli ethi "Track Changes" ngoku ethathwa njengelifa. Yayiyindlela elungileyo yokujonga uhlengahlengiso kwifayile ye-Excel. Kwiincwadi zokusebenza ezilungiselelwe olu phawu, ukugcinwa kunye nokwabelana ngohlelo ngalunye ngamanqaku asekhohlo kwiiseli (oonxantathu ababhlowu) kunye nezimvo ezivelelayo. inkcazo yotshintsho kunye nomsebenzisi onoxanduva. Nangona isekho kwiimeko ezithile, kwiindawo zangoku zokubhala ngokubambisana ithathelwe indawo nguMboniso iiNguqu.

Ukuba umbutho wakho usasebenzisa loo ndlela, ungadwelisa utshintsho kwiphepha elahlukileyo. Ukwenza oku, kwithebhu yokuphonononga, vula uTshintsho lweTrack kwaye ukhethe gxininisa utshintshoKhetha u-"Show changes in a new sheet" ukhetho kwaye uqinisekise ngokuthi Kulungile: I-Excel iyakongeza iphepha elibizwa ngokuba yi "History" nge Iinkcukacha zotshintsho ikhutshwe encwadini.

Ukuphononongwa kolu kuhlelwa kwakhona kwalawulwa kuPhononongo > Landela uTshintsho > Yamkela okanye Yale utshintsho. Apho ungazamkela okanye uzikhabe nganye nganye, okanye usebenzise u-"Yamkela Konke" okanye "Yala Konke" iinketho zokuziqhubekisa kwiibhetshi, ngokukwazi ukuvala nangaliphi na ixesha. buyela kwiphepha.

Le ndlela inexabiso kwiincwadi esele zidalwe kunye naloo nkqubo, kodwa ayinikezeli ngokudibanisa kunye namava okubhala ngokubambisana ukuba ilifu kunye nephaneli yoTshintsho lwePhaneli libonelela namhlanje, apho ulwazi luhambelana ngcono kunye ukuhlela ngokudibeneyo ngexesha langempela.

Ukuthelekisa iinguqulelo kunye nemida: into onokuthi uyilindele kwaye ungayilindelanga kwi-Excel

Endaweni yokujonga uhlengahlengiso kwifayile ye-Excel, abasebenzisi abaninzi bafuna ukwazi "ngokukrwaqula" ukuba yintoni etshintshileyo phakathi kwenguqulelo yokugqibela kunye nale yangoku ngaphandle kokuvula iifayile ezimbini ecaleni. Ngokwesiqhelo, i-Excel ayibandakanyi isixhobo somthonyama esenza lo msebenzi. Umahluko oneenkcukacha phakathi kwazo naziphi na iifayile ezimbini zasekuhlaleni. Inika uBonisa iiNguqu kwiincwadi ezibhalelwe kunye (inqaku lamva nje nelisebenzayo) kunye neMbali yenguqulelo ukuvula iinguqulelo zangaphambili kwaye, ukuba kufanelekile, zibuyisele.

Abanye abasebenzisi bakhankanya into eluncedo ebizwa ngokuba yiSpreadsheet Thelekisa (inxalenye yofakelo oluthile lweOfisi) yokuthelekisa iifayile ezimbini ezigciniweyo. Ukuyisebenzisa, udinga ikopi yoguqulelo lwangaphambili kwikhompyuter yakho; ayisiyo "iqhosha lomlingo" ngaphakathi kwe-Excel, kodwa sisixhobo esahlukileyo esithelekisa iincwadi zokusebenza kunye nokubonisa iziphumo. umahlukoIluncedo ukuba awusebenzi efini, nangona ifuna inyathelo elongezelelweyo lokugcina iinguqulelo zasekhaya.

Kuqhelekile ukufunda kwiiforamu ukuba "akukho ndlela yakudala, ekhawulezayo, kunye neyendalo yonke" yokuthelekisa nayiphi na inguqulelo kunye nale yangoku ngaphandle kokulungiselela izinto kwangaphambili. Kwaye iyavakala: ukurekhoda lonke utshintsho oluncinci, indawo yokugcina yokugcina kuya kufuneka igcine isixa esikhulu imethadathaOku kuya kwandisa kakhulu ubungakanani bayo kwaye kube nzima ukulawula kwayo, ngakumbi kwiincwadi ezihlaziywa yonke imihla.

Ukuba usebenza kwiWindows, iFayile Explorer ikuvumela ukuba wongeze iikholamu zolwazi (umhla wokudala, umhla wokulungisa, njl.njl.), kodwa ezi ziimetadata zomgangatho wefayile, hayi imbali utshintsho kwiseli nganyeOlunye ukhetho lwenkqubo yi Imbali yefayileethatha iikopi zeefayile ezilungisiweyo ukuze zibuyiselwe; ngembuyekezo, idla isithuba sedisk kwaye ayingombukeli we utshintsho lwegranular njenge.

Kushwankathelo lokusebenza: ukuba usebenzisana ne-Excel (OneDrive/SharePoint), sebenzisa Bonisa iiNguqu kwiinguqulelo zamva nje kunye neMbali yoguqulelo ixesha elide. Ukuba ukuhamba kwakho kusekhaya, gcina iinguqulelo kwaye, xa ufuna ukuthelekisa, cinga ukusebenzisa izixhobo zokuthelekisa ezifana ne-Spreadsheet Thelekisa ukufumana imephu yotshintsho. umahluko phakathi kweefayile.

I-ecosystem yokujonga utshintsho kwifayile ye-Excel inika izisombululo ezinamandla xa usebenza efini kunye no-co-authoring: iPheyini yeeNguqulelo zokuBonisa ikunika "apha kwaye ngoku," ngelixa i-Version History kunye ne-SharePoint izicwangciso zandisa ixesha elide. Kwiimeko zasekuhlaleni, uthelekiso lufuna ukugcina iikopi kunye nokuxhomekeka kwizinto eziluncedo zangaphandle. Ngokwazi ukuba yintoni na efakiweyo kwaye yintoni engeyiyo, kunye nokuqinisekisa ulungelelwaniso olufanelekileyo, unokuba nolawulo oluyinyani nolusebenzayo kwinkqubo. umkhondo we-Ediiminqweno kwi-spreadsheets zakho.

Inqaku elinxulumene nalo:

I-Ofisi ayiyi kuvulwa ngenxa ye-AppVIsvSubsystems64.dll: izisombululo eziqinisekisiweyo

UDaniel Terrasa

Umhleli okhethekileyo kwitekhnoloji nakwimiba ye-intanethi eneminyaka engaphezu kweshumi yamava kumajelo osasazo edijithali. Ndisebenze njengomhleli kunye nomdali womxholo we-e-commerce, unxibelelwano, ukuthengisa kwi-intanethi kunye neenkampani zentengiso. Ndibhale kwakhona kwiiwebhusayithi zezoqoqosho, ezemali kunye namanye amacandelo. Umsebenzi wam ukwangumnqweno wam. Ngoku, ngamanqaku am kwi Tecnobits, Ndizama ukuhlola zonke iindaba kunye namathuba amatsha ukuba ihlabathi lobuchwepheshe lisinika yonke imihla ukuphucula ubomi bethu.