- Iyo "Show Shanduko" pani inoratidza ndiani, chii, kupi, uye rinhi, nekusefa neshizha kana renji.
- Kwenguva refu, shandisa Version History; gadzirisa shanduro mu SharePoint.
- Zvimwe zviito hazvina kunyorwa (mafomati, zvinhu, matafura epivot) uye pane miganhu.
- Kunze kwegore, chengetedza makopi uye funga Spreadsheet Enzanisa kuenzanisa mafaera.
Patinogovana maspredishiti, zvakajairika kushamisika kuti munhu wese akabata chii uye riini. Wona zvigadziriso kuExcel fairaNhasi tine sarudzo dzakati wandei: iyo Ratidza Shanduko mapaneru, iyo Nhoroondo Yevhezheni uye, mune zvimwe zvekare zviitiko, murwi "Track Shanduko".
Muchinyorwa chino tinotsanangura maitirwo azvo, zvipimo zvipi sarudzo imwe neimwe ine, uye ndedzipi dzimwe nzira dziripo Kana ukashanda kunze kwegore, pamwe nemamwe matipi anoshanda.
Chii chinonzi "Ratidza Shanduko" muExcel uye ruzivo rupi rwainoratidza?
Iyo Show Shanduko inoisa pakati rekodhi yezvino gadziridzwa mubhuku. Panera rayo rinoratidza shanduko nyowani kumusoro, zvichikutendera kuti uzvizivise zvakadzama. ndiani akagadzirisa, sero rakakanganiswa, nguva chaiyo, uye kukosha kwekareZvinonyanya kubatsira kana vanhu vakawanda vachigadzirisa faira yakagovaniswa uye iwe unoda yakajeka nguva yakatarwa.
Iri pani rinokutenderawo kuti uongorore magadzirirwo akaitwa "muzhinji". Panyaya idzi, Excel Iyo inogadzira kadhi ine chiitiko chakawanda uye inopa mukana we "Tarisa Shanduko" mukati meiyo kadhi, saka iwe unogona kuzama zvakadzama mu tsanangudzo yeimwe neimwe yakakamurwa gadziridzo pasina kurasikirwa nechirevo.
Ramba uchifunga kuti Excel inochengeta ichangoburwa chiitiko mune ino panhi, ichipa kuoneka kusvika pakukwira kwe anenge mazuva makumi maviriKana muchida kuwedzera nguva yekuongorora zvaiitika kare, ichave nguva yeVersion History, yatichataura nezvayo gare gare. famba kune dzakapfuura shanduro uye ongorora iwo pasina chero zvinoshamisa.
Ona shanduko mubhuku rese: nhanho dzekukurumidza
Kuti utarise yakazara yebhuku rebasa uye kuona kugadziridzwa kuExcel faira, maitiro acho ari nyore uye anokuendesa kupaneru nezvose zvichangobva kugadzirwa. Nematanho aya, unokwanisa kuona nekukurumidza. zvese zvakaitika mufaira:
- PaKuongorora tab, sarudza Ratidza shanduko kuti uvhure pani neshanduko dzichangoburwa.
- Ziva kuti shanduko dzinoonekwa dzakarongedzerwa neazvino kumusoro, zvichiratidza nhevedzano chaiyoiyo yokuverengwa kwenguva yekuurayiwa.
- Iwe unozogona kuona kuti ndiani akachinja chii uye musero ripi, pamwe chete nezuva uye nguva, izvo zvinoita kuti zvive nyore. Audit kubatana.
- Kana paine magadzirirwo akawanda, unowana kadhi rinoita mapoka uye bhatani Ona shanduko uye famba mukati meimwe neimwe inosanganisirwa shanduko.
Sefa shanduko neshizha, huwandu, kana sero chaiyo
Paunenge uchida kupfupisa kutarisa kwako, unogona kuona shanduko muExcel faira kune rakananga pepa, renji, kana kunyange sero rimwe chete. Uku kusefa kunokubatsira kuongorora zvakadzama. zvakaitika mune imwe nzvimbo kubva mubhuku pasina ruzha rwakawedzerwa.
Kusefa nekukurumidza kubva pabepa: sarudza shiti, renji, kana sero rimwe chete, wobva wadzvanya-kurudyi kuti uvhure menyu yemukati uye sarudza. Ratidza shandukoNechiito ichi, Excel inorambidza pani iyo sarudzo.
Iwe unogona zvakare kusefa kubva kune Shanduko panel pachayo. Pamusoro, iwe uchaona chiratidzo chesefa: kuisarudza kunokubvumira kuti utaure kana iwe uchida kusefa ne... Range kana kuti na HojaKana ukasarudza Range, nyora renji kana sero mubhokisi rezvinyorwa uye simbisa neiyo museve icon padivi pemunda iwoyo kuti uise sefa pakarepo.
Iyi nzira yekusefa inokuchengetera nguva yakawanda paunenge uchiongorora zviitiko kana paunoda kutarisisa nzvimbo yakaoma yebepa (somuenzaniso, uwandu hunoverengerwa hwerengedzo kana kuti apo mumwe munhu akachinja mareferensi).
"Show Shanduko" inoshanda kupi uye chii chinodiwa kuti inyore zvese?
Ratidza Shanduko inowanikwa muExcel yedesktop neExcel yewebhu, uye inoratidza mupaneru yayo magadzirirwo akaitwa kubva kuExcel maapplication anoitsigira. mubatanidzwaIzvi zvinoreva kuti, kuti uone nhoroondo yakazara kwazvo mudhibhodhi, vese vashandisi vanofanirwa kushandisa inowirirana Excel app uye kushanda nefaira munzvimbo dzine chengetedza kubatanidzwa-kutsikisa inoshanda (semuenzaniso, OneDrive kana SharePoint).
Ko kana dashboard ichiita kunge isina chinhu kunyangwe iwe uchiziva kuti pane chiitiko? Zvimwe zviito zvinogona kuita kuti Excel ibvise iyo log. Iwe uchaona dashboard isina chinhu kana mumwe munhu, semuenzaniso, akagadziridzwa nekutenga-nguva imwe chete kana yekare vhezheni yeExcel isina kuenderana nekunyora pamwe, kana mabasa akashandiswa izvozvo. no son compatibles ne-co-publishing kana kana faira iri yakatsiviwa kana kopi yakachengetwa, kuputsa kuenderera mberi kwekutarisa.
Nhau dzakanaka ndedzekuti, kubva panguva iyoyo zvichienda mberi, chero shanduko itsva iwe kana mumwe munhu waunoita kubva kune anowirirana maapplication anozoiswa zvakare muChanduko pani. Izvi zvinodzoreredza kuoneka kwezviitiko zvinotevera uye zvinokutendera iwe kuti udaro tevera nzira pasina kuitazve gwaro.
Ndedzipi shanduko dzakarekodhwa uye dzisina kuratidzwa pane pani
Iyo Shanduko panel inotarisa pane mafomula uye kukosha kwesero, pamwe nemashandiro akadai sekufambisa, kuronga, kuisa, kana kudzima maseru nemasarange. Naizvozvo, iwe unowana zvakajeka zvese zviri zviviri-imwe-yekugadziriswa uye shanduko yezvimiro zvinokanganisa data blocks.
Nekudaro, zvimwe zviito hazvisi kuratidzwa parizvino: kugadziridzwa kumifananidzo, maumbirwo, kana zvimwe zvinhu, mafambiro, kana marongero mukati. tablas dinámicasIzvi zvinosanganisira mafomati shanduko (mavara, mafonti, masitayipi), kuvanza maseru/masaranji, uye kushandisa mafirita. Ramba uchifunga izvi, nekuti iyi "sual layer" haina kuratidzwa mupaneru, iyo inotarisa pamabasa makuru. nhamba uye inoshanda.
Uyezve, kupa nhoroondo yakazara kwazvo inogoneka, Excel inogona kusiya mapeji mumutsara wenguva kana dzimwe shanduko dzisipo. Nekuda kweizvozvo, iwe unogona kuona "kusvetuka" kana kugadzirisa, nekuda kwechimiro chavo kana chishandiso chakashandiswa, chatadza kuitwa. rekodhi pane panel.
Sei tsika dzekare dzimwe nguva dzichishayikwa kubva kune mamwe manyorerwo? Izvi zvinogona kuitika kana data yakagadziridzwa uchishandisa kodhi (semuenzaniso, VBA kana kuwedzera-ins) kana mumwe munhu akagadzirisa bhuku rebasa neExcel asina kurivandudza. vhezheni yazvinoMumamiriro ezvinhu akadai, kuteedzera kwe "value before/value after" inogona kurasika pane ichochi chiitiko.
Maonero ekuchinja kwekare: Nhoroondo yeshanduro
Iyo Shanduko panel inoratidza shanduko dzazvino; kana iwe uchida kuwedzera nguva, shandisa iyo Historial de versionesKubva Faira> Ruzivo> Nhoroondo Yeshanduro, unogona kuvhura vhezheni yapfuura kuti utarise uye, kana zvichidikanwa, idzorere. Izvi zvinobatsira zvikuru pakutsvaga eventos anteriores kusvika kune iyo Ratidza shanduko inovhara.
Nhoroondo yevhezheni haina kufanana ne "muenzanisi wekuona" pakati pemapoinzi maviri munguva: chinangwa chayo kubvumira kufamba kuburikidza nefaira renyika, nekugona kuvhura yakapfuura vhezheni uye kushanda pairi. Kunyangwe zvakadaro, kubatanidza iyi ficha neRatidza Shanduko inogona kupa muyero wakaenzana. nekukurumidza uye munguva pfupi yapfuura nekuongorora kwenguva refu.
Kana faira yako ichigara muSharePoint, yeuka kuti shanduro yekutonga ine miganhu inogadziriswa. Panguva yekuseta, unogona kuseta huwandu hwehuwandu hweshanduro dzaunoda kuchengetedza, uye kana sisitimu yasvika pamuganho, inodzima iyo yekupedzisira vhezheni. oldest kuti vawane nzvimbo itsva. Kana iwe uchida imwe leeway, zvinokwanisika kuwedzera iyo nhamba kusvika kune system muganho, izvo zvinovandudza kugona kudzokera kumashure nenguva tsvakurudzo huru.
Kune zvikwata zvinovimba neshanduro dzenhoroondo, zvinokurudzirwa kuti nguva nenguva uongorore gadziriso iyi muraibhurari yeSharePoint uye igadzirise kuti ienderane nekufamba kwebasa: kunowedzera kuchinja kwezuva nezuva, ndiko kuwedzera pfungwa kwazvinoita kuwedzera huwandu hwe dzakanyimwa shanduro kuitira kuti usarase nzira inobatsira.
Kugadzirisazve Shanduko Pane: Rini uye Sei
MuExcel yewebhu, pane sarudzo yekudzima nhoroondo yekuchinja yaunoona muDashboard. Inowanikwa pasi peFaira> Ruzivo, uye ichisimbisa kuti icha… chenesa panel kune vese vashandisi vebhuku. Icho chiito chisingadzokerike uye, naizvozvo, chinofanira kunyatsotariswa usati wachiita kana uchida kuchengetedza humbowo kubatana kuchangobva kuitika.
Kunyangwe ukadzima icho chinyorwa kubva papaneru, unogona kuvhura kana kudzoreredza shanduro dzakapfuura kuburikidza neNhoroondo Yeshanduro. Mune mamwe mazwi, iwe unobvisa "rondedzero yezviitiko" kubva papaneru, asi iwe haurasikirwe nekugona dzokera kumatunhu apfuura yefaira chero bedzi iwo mavhezheni aripo pane system.
Classic "Track Shanduko" muExcel: zvainopa uye maitiro ekudzokorora
Kwemakore, chirongwa ichi chaive nechinyakare "Track Changes" system yave kunzi senhaka. Yakanga iri nzira yakanaka yekuona kugadziridzwa kuExcel faira. Mumabhuku ekushanda akagadziridzwa nechinhu ichi, kuchengetedza uye kugovera ega ega mareki eruboshwe mumaseru (blue triangles) uye pop-up comments. tsananguro yeshanduko uye mushandisi ane hanya. Kunyangwe ichiripo mune chaiwo mamiriro, munzvimbo dzemazuva ano dzekunyora yakatsiviwa neRatidza Shanduko.
Kana sangano rako richiri kushandisa nzira iyoyo, unogona kunyora shanduko papepa rakasiyana. Kuti uite izvi, kubva paOngororo tebhu, vhura Track Shanduko uye sarudza Simbisa shandukoSarudza iyo "Ratidza shanduko mupepa idzva" sarudzo uye simbisa neOK: Excel ichawedzera pepa rinonzi "Nhoroondo" ne Details for shanduko yakatorwa mubhuku.
Ongororo yezvigadziriso izvi zvakare yakatungamirirwa kubva Ongororo> Tevera Shanduko> Gamuchira kana Kuramba Shanduko. Ikoko iwe unogona kuzvigamuchira kana kuvaramba chimwe nechimwe, kana kushandisa "Gamuchira Zvese" kana "Ramba Zvese" sarudzo kuti uzvigadzirise mumabhechi, nekugona kuvhara chero nguva. dzokera kupeji.
Iyi nzira ine kukosha mumabhuku ayo akatogadzirwa neiyo sisitimu, asi haipe iyo yekubatanidza uye yekunyora-yekunyora iyo gore neiyo Show Changes pani inopa nhasi, uko ruzivo rwakanyatsoenderana ne kushandira pamwe munguva chaiyo.
Kuenzanisa shanduro uye zvisingakwanisi: zvaunogona uye zvausingatarisiri kubva kuExcel
Panzvimbo pekuona kugadziridzwa kuExcel faira, vashandisi vazhinji vanongoda kuziva "pakungotarisa" chii chachinja pakati pekupedzisira vhezheni neizvino pasina kuvhura mafaera maviri padivi-padivi. Mukuita, Excel haisanganisire chishandiso chemuno chinoita basa iri. Detailed diff pakati pemafaira maviri emuno. Inopa Ratidza Shanduko yemabhuku akanyorwa pamwe chete (ichangoburwa uye inoshanda chaizvo) uye Shanduro Nhoroondo kuvhura dzakapfuura shanduro uye, kana zvichibvira, vadzoreredze.
Vamwe vashandisi vanotaura chishandiso chinodaidzwa kuti Spreadsheet Compare (chikamu chezvimwe zvimisikidzo zveHofisi) yekuenzanisa mafaera maviri akachengetwa. Kuti uishandise, unoda kopi yevhezheni yapfuura pakombuta yako; haisi "bhatani remashiripiti" mukati meExcel, asi chishandiso chakasiyana chinofananidza mabhuku ebasa uye chinoratidza mhedzisiro. mutsaukoZvinobatsira kana ukasashanda mugore, kunyangwe zvichitoda danho rekuwedzera rekuchengeta shanduro dzemuno.
Zvakajairika kuverenga mumaforamu kuti "hapana yemuno, inokurumidza, uye yepasirese nzira" yekuenzanisa chero shanduro neyazvino pasina kugadzirira zvinyorwa zvisati zvaitika. Uye izvo zvine musoro: kurekodha mutsauko diki wega wega, iyo dura yaizofanira kuchengetedza yakakura kwazvo metadataIzvi zvaizowedzera kukura kwayo uye kuomesa manejimendi ayo, kunyanya mumabhuku anogadziridzwa zuva nezuva.
Kana iwe ukashanda muWindows, File Explorer inokutendera kuti uwedzere makoramu eruzivo (zuva rekusika, zuva rekugadzirisa, nezvimwewo), asi aya ifaira-level metadata, kwete nhoroondo ye shanduko paseroImwe sarudzo yehurongwa ndeye Nhoroondo yefairaiyo inotora makopi emafaira akagadziridzwa kuitira kuti adzorerwe; mukudzoka, inopedza disk nzvimbo uye haisi muoni we granular shanduko saizvozvo.
Muchidimbu chekushanda: kana uri kunyora pamwe neExcel (OneDrive/SharePoint), shandisa Ratidza Shanduko dzeshanduko dzichangoburwa uye Shanduro Yenhoroondo kwenguva refu. Kana mafambiro ako epanzvimbo, chengetedza shanduro uye, paunoda kuenzanisa, funga kushandisa maturusi ekuenzanisa seSpreadsheet Compare kuti uwane mepu yekuchinja. mutsauko pakati pemafaira.
Iyo ecosystem yekuona shanduko kuExcel faira inopa mhinduro dzine simba kana uchishanda mugore uye pamwe nekunyora-pamwe: iyo Ratidza Shanduko pane inokupa iwe "pano uye izvozvi," nepo Shanduro Yenhoroondo uye SharePoint marongero achiwedzera nguva. Mumamiriro ezvinhu emunharaunda, kuenzanisa kunoda kuchengetedza makopi uye kuvimba nezvinhu zvekunze. Nekuziva chakadzikwa uye chii chisiri, uye nekuona kurongeka kwakakodzera, unogona kuve nekutonga kwechokwadi uye kwakanaka pamusoro pekuita. nhoroondo yeEditions mumaspredishiti ako.
Mharidzo inyanzvi mune tekinoroji uye internet nyaya ine anopfuura makore gumi echiitiko mune akasiyana dhijitari media. Ndakashanda semupepeti uye mugadziri wezvemukati we e-commerce, kutaurirana, online kushambadzira uye kushambadzira makambani. Ndanyorawo pane zvehupfumi, mari uye mamwe masekete mawebhusaiti. Basa rangu ndirowo shungu dzangu. Zvino, kuburikidza nezvinyorwa zvangu mu Tecnobits, Ndinoedza kuongorora nhau dzose nemikana mitsva iyo nyika yetekinoroji inotipa zuva rega rega kuvandudza hupenyu hwedu.