Saib cov kev hloov pauv rau cov ntaub ntawv Excel: phau ntawv qhia koj xav tau

Thaum peb sib faib cov ntawv nthuav dav, nws yog ib txwm xav tsis thoob tias txhua tus neeg tau kov dab tsi thiab thaum twg. Saib cov kev hloov kho rau cov ntaub ntawv ExcelNiaj hnub no peb muaj ob peb txoj kev xaiv: lub Show Changes panel, Version History thiab, nyob rau hauv ntau classic scenarios, tus qub qub "Track Changes".

Hauv tsab xov xwm no peb piav qhia Yuav ua li cas, qhov kev txwv txhua qhov kev xaiv muaj, thiab cov kev xaiv twg muaj nyob Yog tias koj ua haujlwm sab nraum huab, ntxiv rau lwm cov lus qhia tswv yim.

"Show Changes" hauv Excel yog dab tsi thiab nws qhia cov ntaub ntawv dab tsi?

Qhov Qhia Hloov Hloov feature tseem ceeb hauv cov ntaub ntawv ntawm cov kev hloov kho tsis ntev los no hauv phau ntawv. Nws lub vaj huam sib luag qhia cov kev hloov tshiab tshaj plaws nyob rau saum toj, tso cai rau koj txheeb xyuas lawv kom meej. leej twg ua qhov kev hloov kho, qhov cuam tshuam ntawm tes, lub sijhawm caij nyoog, thiab tus nqi dhau losNws yog qhov tshwj xeeb tshaj yog thaum muaj ntau tus neeg kho cov ntaub ntawv sib koom thiab koj xav tau lub sijhawm meej meej.

Lub vaj huam sib luag no tseem tso cai rau koj los tshuaj xyuas cov kev hloov kho uas tau ua tiav "hauv ntau". Rau cov xwm txheej no, Excel Nws tsim ib daim npav nrog ntau qhov kev txiav txim thiab muab kev nkag mus rau "Saib Hloov" hauv daim npav ntawd, yog li koj tuaj yeem nkag mus tob rau hauv cov ntsiab lus ntawm txhua pab pawg hloov kho tsis poob cov ntsiab lus.

Nco ntsoov tias Excel khaws cov haujlwm tsis ntev los no hauv lub vaj huam sib luag no, muab kev pom pom txog qhov siab tshaj plaws txog 60 hnubYog tias koj xav txuas ntxiv lub sijhawm los tshuaj xyuas qhov uas tau tshwm sim ua ntej, nws yuav yog qhov tig ntawm Version Keeb Kwm, uas peb yuav tham txog tom qab. taug kev mus rau yav dhau los versions thiab tshuaj xyuas lawv yam tsis muaj kev xav tsis thoob.

Saib cov kev hloov pauv thoob plaws hauv phau ntawv: cov kauj ruam ceev

Rau kev nthuav dav ntawm phau ntawv ua haujlwm thiab saib kev hloov kho rau cov ntaub ntawv Excel, cov txheej txheem yooj yim heev thiab coj koj mus rau lub vaj huam sib luag nrog tag nrho cov kev hloov kho tsis ntev los no. Nrog cov kauj ruam no, koj yuav pom tam sim ntawd. txhua yam uas tau tshwm sim hauv cov ntaub ntawv:

1. Hauv Kev Tshawb Fawb tab, xaiv Qhia cov kev hloov pauv qhib lub vaj huam sib luag nrog kev hloov kho tsis ntev los no.
2. Nco ntsoov tias cov kev hloov pauv tshwm sim nrog qhov tsis ntev los no nyob rau saum toj, xav txog qhov tseeb chronological txiav txim ntawm kev tua.
3. Koj yuav tuaj yeem txheeb xyuas tus neeg hloov pauv dab tsi thiab hauv lub xov tooj twg, nrog rau hnub tim thiab sijhawm, uas ua rau nws yooj yim dua kev tshuaj xyuas kev sib koom tes.
4. Yog tias muaj kev hloov pauv ntau, koj yuav pom ib daim npav uas pab pawg ua haujlwm thiab lub pob rau Saib kev hloov thiab taug kev los ntawm txhua qhov kev hloov kho uas suav nrog.

Lim hloov los ntawm daim ntawv, ntau yam, lossis cov xov tooj tshwj xeeb

Thaum koj xav nqaim koj lub hom phiaj, koj tuaj yeem saib cov kev hloov pauv hauv Excel cov ntaub ntawv tsuas yog ib daim ntawv tshwj xeeb, ntau yam, lossis txawm tias ib lub xov tooj ntawm tes. Qhov kev lim dej no pab koj tshawb xyuas kom meej. dab tsi tshwm sim hauv ib cheeb tsam tshwj xeeb los ntawm phau ntawv tsis muaj suab nrov ntxiv.

Kom sai lim los ntawm daim ntawv: xaiv ib daim ntawv, ib tug ntau yam, los yog ib tug cell, ces right-click los qhib lub ntsiab lus teb zaub mov thiab xaiv Qhia cov kev hloov pauvNrog rau qhov kev txiav txim no, Excel txwv lub vaj huam sib luag rau uas xaiv.

Koj tseem tuaj yeem lim los ntawm Hloov Vaj Huam Sib Luag nws tus kheej. Nyob rau sab saum toj, koj yuav pom lub cim lim: xaiv nws yuav tso cai rau koj qhia seb koj xav lim los ntawm ... Rango o por HojaYog tias koj xaiv Range, ntaus qhov ntau lossis ntawm tes hauv lub thawv ntawv thiab paub meej nrog lub xub xub icon nyob ib sab ntawm daim teb kom siv cov lim tam sim ntawd.

Qhov kev lim dej no txuag koj ntau lub sijhawm thaum tshawb xyuas qhov xwm txheej lossis thaum koj xav tau tsom mus rau thaj chaw tseem ceeb ntawm daim ntawv (piv txwv li, qhov ntau qhov uas suav tag nrho lossis qhov twg ib tus neeg hloov cov ntaub ntawv).

Qhov "Show Changes" ua haujlwm nyob qhov twg thiab dab tsi yog qhov yuav tsum tau ua rau nws rau npe txhua yam?

Qhia Hloov pauv muaj nyob rau hauv Excel rau desktop thiab Excel rau lub vev xaib, thiab qhia txog hauv nws lub vaj huam sib luag cov kev hloov kho los ntawm Excel daim ntawv thov uas txhawb nqa nws. kev sib sauQhov no txhais tau hais tias, kom pom cov keeb kwm ua tiav tshaj plaws hauv dashboard, txhua tus neeg siv yuav tsum siv Excel sib xws app thiab ua haujlwm nrog cov ntaub ntawv hauv qhov chaw uas tuav kev tshaj tawm nquag (piv txwv li, OneDrive lossis SharePoint).

Yuav ua li cas yog lub dashboard zoo nkaus li khoob txawm tias koj paub tias muaj kev ua si? Qee qhov kev nqis tes ua tuaj yeem ua rau Excel kom tshem tawm lub log ntawd. Koj yuav pom lub dashboard dawb paug yog tias ib tug neeg, piv txwv li, kho nrog kev yuav khoom ib zaug lossis ib qho qub ntawm Excel tsis ua raws li kev sau ntawv, lossis yog tias cov haujlwm tau siv los ua qhov ntawd no son compatibles nrog co-publishing los yog cov ntaub ntawv yog hloov lossis ib daim qauv raug cawm, rhuav tshem qhov txuas ntxiv ntawm kev saib xyuas.

Cov xov xwm zoo yog tias, txij li qhov ntawd mus, txhua qhov kev hloov pauv tshiab uas koj lossis lwm tus ua los ntawm cov apps sib xws yuav raug nkag dua hauv Cov Hloov Hloov Vaj Huam Sib Luag. Qhov no restores visibility rau cov txheej xwm tom ntej thiab tso cai rau koj mus taug txoj kev tsis tas yuav rov ua cov ntaub ntawv.

Cov kev hloov pauv twg tau sau tseg thiab qhov twg tsis pom nyob rau ntawm lub vaj huam sib luag

Lub Vaj Huam Sib Luag Hloov yog npaj rau cov qauv thiab cov txiaj ntsig ntawm tes, nrog rau kev ua haujlwm xws li txav, txheeb xyuas, ntxig, lossis tshem tawm cov hlwb thiab ntau yam. Yog li ntawd, koj yuav pom meej pom ob qho tib si hloov kho thiab cov qauv kev hloov pauv uas cuam tshuam cov ntaub ntawv thaiv.

Txawm li cas los xij, qee qhov kev ua tsis tau tshwm sim tam sim no: kev hloov kho rau cov duab, duab, lossis lwm yam khoom, txav, lossis teeb tsa hauv cov rooj pivotQhov no suav nrog kev hloov pauv hloov pauv (xim, fonts, styles), zais cov hlwb / kab, thiab siv cov ntxaij lim dej. Khaws qhov no hauv siab, vim tias qhov "pob qhov muag" tsis cuam tshuam rau hauv vaj huam sib luag, uas tsom mus rau lub luag haujlwm tseem ceeb. tus lej thiab ua haujlwm.

Tsis tas li ntawd, txhawm rau muab cov keeb kwm ua tiav ntau tshaj plaws, Excel tuaj yeem tso qhov khoob hauv lub sijhawm yog tias qee qhov kev hloov pauv tsis muaj. Yog li ntawd, koj yuav pom tias "skips" thaum kho, vim lawv qhov xwm txheej lossis cov cuab yeej siv, tsis tuaj yeem ua. sau rau ntawm lub vaj huam sib luag.

Vim li cas cov nqi yav dhau los qee zaum ploj ntawm qee qhov kev nkag? Qhov no tuaj yeem tshwm sim thaum cov ntaub ntawv hloov kho siv cov lej (piv txwv li, VBA lossis ntxiv-ins) lossis yog tias ib tus neeg kho phau ntawv ua haujlwm nrog Excel yam tsis hloov kho nws. qhov tseeb tshaj plawsHauv cov xwm txheej zoo li no, qhov traceability ntawm "tus nqi ua ntej / tus nqi tom qab" yuav ploj mus rau qhov kev txiav txim tshwj xeeb.

Yuav ua li cas saib cov kev hloov pauv qub: Version keeb kwm

Lub Vaj Huam Sib Luag Hloov qhia cov kev hloov tshiab tshaj plaws; Yog tias koj xav tau ncua lub sijhawm, siv lub Keeb kwm ntawm cov versionLos ntawm Cov Ntaub Ntawv> Cov Ntaub Ntawv> Keeb Kwm Keeb Kwm, koj tuaj yeem qhib cov ntawv dhau los los saib ua ntej thiab, yog tias xav tau, rov qab kho nws. Qhov no tseem ceeb heev thaum tshawb fawb eventos anteriores mus rau qhov ntau yam uas Qhia hloov pauv.

Version keeb kwm tsis zoo ib yam li "visual comparator" ntawm ob lub ntsiab lus nyob rau hauv lub sij hawm: nws lub hom phiaj yog tso cai navigation los ntawm cov ntaub ntawv xeev, muaj peev xwm qhib ib tug yav dhau los version thiab ua hauj lwm rau nws. Txawm li cas los xij, kev sib txuas cov yeeb yam no nrog Kev Hloov Pauv tuaj yeem muab cov ntsiab lus sib luag. ceev thiab tsis ntev los no nrog rau kev tshawb xyuas ntev dua.

Yog tias koj cov ntaub ntawv nyob hauv SharePoint, nco ntsoov tias kev tswj hwm version muaj kev txwv. Thaum lub sijhawm teeb tsa, koj tuaj yeem teeb tsa tus lej siab tshaj plaws uas koj xav khaws cia, thiab thaum lub kaw lus nce mus txog qhov txwv, nws tshem tawm qhov kawg version. hlob tshaj ua chaw rau cov tshiab. Yog tias koj xav tau ntau dua leeway, nws muaj peev xwm ua kom tus lej ntawd nce mus txog qhov kev txwv, uas txhim kho lub peev xwm rov qab mus rau lub sijhawm. kev tshawb fawb dav dav.

Rau cov pab pawg uas vam khom cov keeb kwm yav dhau los, nws raug nquahu kom saib xyuas qhov kev teeb tsa no hauv lub tsev qiv ntawv SharePoint thiab hloov nws mus rau kev ua haujlwm: qhov kev hloov pauv niaj hnub ntau dua, qhov kev nkag siab ntau dua nws ua kom muaj ntau tus lej. tuav versions thiaj li tsis poob ib txoj kev muaj txiaj ntsig.

Resetting Qhov Hloov Pauv Hloov: Thaum twg thiab Yuav Ua Li Cas

Hauv Excel rau lub vev xaib, muaj kev xaiv los tshem tawm cov keeb kwm hloov pauv uas koj pom hauv Dashboard. Nws nyob hauv Cov Ntaub Ntawv> Cov Ntaub Ntawv, thiab lees tias nws yuav ... ntxuav lub vaj huam sib luag rau txhua tus neeg siv phau ntawv. Nws yog ib qho irreversible txiav txim thiab, yog li ntawd, nws yuav tsum tau ua tib zoo txiav txim siab ua ntej nqa tawm yog hais tias koj yuav tsum khaws cov pov thawj ntawm kev sib koom tes tsis ntev los no.

Txawm hais tias koj rho tawm qhov nkag ntawd los ntawm lub vaj huam sib luag, koj tseem tuaj yeem qhib lossis rov kho cov ntawv dhau los dhau los ntawm Version Keeb Kwm. Hauv lwm lo lus, koj tshem tawm "cov npe tshwm sim" ntawm lub vaj huam sib luag, tab sis koj tsis poob lub peev xwm rov qab mus rau lub xeev dhau los ntawm cov ntaub ntawv ntev npaum li cov versions muaj nyob rau hauv qhov system.

Classic "Track Changes" hauv Excel: nws muaj dab tsi thiab yuav tshuaj xyuas nws li cas

Tau ntau xyoo, qhov kev zov me nyuam tau nthuav tawm cov txheej txheem "Track Changes" uas tam sim no suav tias yog keeb kwm yav dhau los. Nws yog ib txoj hauv kev zoo los saib kev hloov kho rau cov ntaub ntawv Excel. Hauv phau ntawv ua haujlwm tau teeb tsa nrog qhov tshwj xeeb no, txuag thiab sib koom txhua qhov hloov kho cov cim sab laug hauv cov hlwb (xiav daim duab peb sab) thiab cov lus pom. piav qhia txog kev hloov thiab tus neeg siv lub luag haujlwm. Txawm hais tias nws tseem muaj nyob rau hauv cov xwm txheej tshwj xeeb, nyob rau hauv niaj hnub co-authoring ib puag ncig nws tau raug hloov los ntawm Qhia Hloov.

Yog tias koj lub koom haum tseem siv txoj hauv kev ntawd, koj tuaj yeem sau cov kev hloov pauv ntawm ib daim ntawv cais. Txhawm rau ua qhov no, los ntawm Kev Tshawb Fawb tab, qhib Cov Kev Hloov Pauv thiab xaiv tseem ceeb hloovXaiv qhov "Qhia cov kev hloov pauv hauv daim ntawv tshiab" thiab paub meej nrog OK: Excel yuav ntxiv ib daim ntawv hu ua "History" nrog rau cov Paub meej rau kev hloov muab rho tawm los ntawm phau ntawv.

Kev tshuaj xyuas ntawm cov kev hloov kho no kuj tau tswj hwm los ntawm Kev Ntsuam Xyuas> Kev Hloov Hloov> Txais lossis tsis lees txais kev hloov pauv. Nyob ntawd koj tuaj yeem lees txais lossis tsis lees txais lawv ib qho los ntawm ib qho, lossis siv qhov "Accept All" lossis "Reject All" cov kev xaiv los ua lawv hauv pawg, nrog lub peev xwm kaw txhua lub sijhawm. rov qab mus rau nplooj ntawv.

Txoj kev no muaj nuj nqis nyob rau hauv cov phau ntawv uas twb tau tsim nrog cov kab ke ntawd, tab sis nws tsis muaj kev sib koom ua ke thiab kev sib koom ua ke uas cov huab thiab Show Changes vaj huam sib luag muab hnub no, qhov twg cov ntaub ntawv zoo dua nrog rau kev koom tes sib kho nyob rau lub sijhawm tiag tiag.

Sib piv cov qauv thiab cov kev txwv: qhov koj tuaj yeem ua tau thiab tsis tuaj yeem xav tau los ntawm Excel

Ntau dua li saib kev hloov kho rau Excel cov ntaub ntawv, ntau tus neeg siv tsuas xav paub "ntawm ib nrais muag" dab tsi tau hloov pauv ntawm qhov kawg version thiab tam sim no yam tsis tau qhib ob cov ntaub ntawv ib sab. Hauv kev xyaum, Excel tsis suav nrog cov cuab yeej ib txwm ua haujlwm ua haujlwm no. ncauj lus kom ntxaws diff nruab nrab ntawm ob lub zos cov ntaub ntawv. Nws muab Qhia Hloov Hloov rau cov phau ntawv sau ua ke (ib qho tsis ntev los no thiab ua tau zoo heev) thiab Version Keeb Kwm los qhib cov ntawv dhau los thiab, yog tias muaj, restaurarlos.

Qee cov neeg siv hais txog cov khoom siv hu ua Spreadsheet Compare (ib feem ntawm qee qhov chaw ua haujlwm teeb tsa) rau kev sib piv ob cov ntaub ntawv khaws tseg. Txhawm rau siv nws, koj xav tau daim ntawv theej dhau los ntawm koj lub computer; nws tsis yog "khawm khawv koob" hauv Excel, tab sis ib qho cuab yeej cais uas sib piv cov ntawv ua haujlwm thiab qhia cov txiaj ntsig. diferenciasNws muaj txiaj ntsig yog tias koj tsis ua haujlwm hauv huab, txawm hais tias nws xav tau cov kauj ruam ntxiv ntawm kev khaws cov ntawv hauv zos.

Nws yog ib qho uas tau nyeem hauv cov rooj sab laj uas "tsis muaj haiv neeg, nrawm, thiab thoob ntiaj teb" los sib piv ib qho version nrog rau tam sim no yam tsis tau npaj cov khoom ua ntej. Thiab qhov ntawd ua rau muaj kev nkag siab: txhawm rau sau txhua qhov kev hloov pauv me me, cov ntaub ntawv khaws cia yuav tsum khaws cov nyiaj ntau heev. cov ntaub ntawv metadataQhov no yuav ua rau nws loj dua thiab ua rau nws nyuaj rau kev tswj hwm, tshwj xeeb tshaj yog nyob rau hauv cov phau ntawv uas tau hloov kho txhua hnub.

Yog tias koj ua haujlwm hauv Windows, File Explorer cia koj ntxiv cov ntaub ntawv kab ke (hnub tsim, hnub hloov kho, thiab lwm yam), tab sis cov no yog cov ntaub ntawv qib metadata, tsis yog keeb kwm ntawm hloov ntawm ib lub cellLwm qhov kev xaiv ntawm qhov system yog qhov Keeb kwm ntawm cov ntaub ntawvuas siv cov ntawv luam ntawm cov ntaub ntawv hloov kho kom lawv rov qab tau; rov qab, nws siv qhov chaw disk thiab tsis yog tus saib ntawm granular hloov como tal.

Hauv cov ntsiab lus ntawm kev ua haujlwm: yog tias koj koom nrog Excel (OneDrive / SharePoint), siv Qhia Hloov rau cov kev hloov pauv tsis ntev los no thiab Version Keeb Kwm rau lub sijhawm ntev dua. Yog tias koj qhov chaw ua haujlwm nyob hauv zos, txuag cov qauv thiab, thaum koj xav tau sib piv, xav txog kev siv cov cuab yeej sib piv xws li Spreadsheet Sib piv kom tau txais daim ntawv qhia kev hloov pauv. diferencias nruab nrab ntawm cov ntaub ntawv.

Lub ecosystem rau saib cov kev hloov pauv rau Excel cov ntaub ntawv muaj cov kev daws teeb meem zoo thaum ua haujlwm hauv huab thiab nrog kev sau ntawv: Show Changes pane muab rau koj "ntawm no thiab tam sim no," thaum Version Keeb Kwm thiab SharePoint nqis txuas ntxiv lub sijhawm. Hauv cov xwm txheej hauv zos, kev sib piv yuav tsum txuag cov ntawv luam thiab tso siab rau cov khoom siv sab nraud. Los ntawm kev paub txog dab tsi yog nkag mus thiab dab tsi tsis yog, thiab ua kom muaj kev tsim nyog, koj tuaj yeem muaj qhov tseeb thiab tswj tau zoo ntawm cov txheej txheem. taug qab Edintawv nyob rau hauv koj cov ntaub ntawv.

Tsab xov xwm cuam tshuam:

Chaw ua haujlwm yuav tsis qhib vim yog AppVIsvSubsystems64.dll: cov kev daws teeb meem pov thawj

Daniel Terrasa

Tus kws kho tshwj xeeb hauv kev siv thev naus laus zis thiab teeb meem hauv internet nrog ntau tshaj kaum xyoo ntawm kev paub hauv cov xov xwm sib txawv. Kuv tau ua haujlwm ua tus editor thiab tus tsim cov ntsiab lus rau e-lag luam, kev sib txuas lus, kev lag luam online thiab cov tuam txhab tshaj tawm. Kuv kuj tau sau rau ntawm kev lag luam, nyiaj txiag thiab lwm cov vev xaib. Kuv txoj hauj lwm kuj yog kuv lub siab nyiam. Tam sim no, dhau ntawm kuv cov ntawv hauv Tecnobits, Kuv sim tshawb nrhiav txhua yam xov xwm thiab lub cib fim tshiab uas lub ntiaj teb kev siv tshuab muab rau peb txhua hnub los txhim kho peb lub neej.