Ua ntej koj hais kom koj cov neeg koom tes los tshuaj xyuas koj cov ntawv ua haujlwm Excel, qhib Excel rov qab taug qab rau koj phau ntawv qhia ua haujlwm. Thaum koj siv cov keeb kwm kev hloov pauv hauv Excel, koj yuav pom leej twg hloov pauv rau daim ntawv ua haujlwm lossis phau ntawv ua haujlwm, thiab cov kev hloov pauv uas lawv tau ua. Tom qab koj pab neeg ua tiav qhov kev tshuaj xyuas, sib piv koj cov ntaub ntawv qub nrog cov neeg tshuaj xyuas cov ntaub ntawv hloov pauv. Tom qab ntawd, lees txais lossis tsis lees txais lawv cov kev hloov pauv, thiab kaw Cov Kev Hloov Pauv kom ua tiav cov ntaub ntawv.
Cov lus qhia hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, thiab Excel 2016.
Koj puas tuaj yeem taug qab kev hloov pauv hauv Excel?
Thaum koj xav kom koj pab neeg los tshuaj xyuas thiab kho koj phau ntawv ua haujlwm Excel, koj muaj ob txoj kev xaiv. Yog tias txhua tus neeg hauv koj pab neeg siv Excel rau Microsoft 365, kev sib koom ua ke yog ib txoj hauv kev yooj yim thiab ceev los tshuaj xyuas cov ntaub ntawv. Yog tias koj xav tau cov ntaub ntawv ntau ntxiv txog kev hloov kho lossis yog tias koj pab neeg ua haujlwm nrog cov ntawv qub ntawm Excel, siv cov cuab yeej cuab tam Hloov Pauv Hloov Pauv.
Koj yuav tsis pom qhov kev xaiv los taug qab cov kev hloov pauv hauv Excel rau Microsoft 365 thiab Excel 2019 ntawm Excel Ribbon. Koj tsuas yog pom cov kev hloov pauv cov lus txib hauv Kev Tshawb Xyuas tab ntawm Excel 2016 thiab cov laus dua. Cov kev xaiv muaj nyob rau hauv cov ntawv tshiab ntawm Excel, tab sis koj yuav tsum tau ntxiv cov kev hloov pauv hloov pauv mus rau ib pab pawg tshiab hauv Kev Tshawb Fawb tab.
Microsoft xav kom koj siv cov ntawv sau ua ke ntawm Excel, uas hloov Cov Ntawv Qhia Ua Haujlwm. Nrog kev sib koom ua ke, koj yuav pom cov kev hloov pauv uas lwm tus ua hauv lub sijhawm tiag tiag, thiab txhua tus neeg cov kev hloov pauv yuav txawv xim. Txawm li cas los xij, kev sau ntawv sib koom tsis taug qab cov kev hloov pauv, thiab koj tsis tuaj yeem tsis lees txais cov kev hloov pauv kom rov qab mus rau koj cov ntaub ntawv qub. Co-authoring tsuas yog muaj nrog Microsoft 365 subscription.
Txhim kho cov kev hloov pauv hauv Newer Versions ntawm Excel
Txhawm rau pab kom cov keeb kwm hloov pauv hloov pauv hauv Windows:
-
Mus rau File tab thiab xaiv Options.
Image -
In the Excel Options dialog box, xaiv Customize Ribbon.
Image -
Xaiv tus Xaiv cov lus txib los ntawm poob xub thiab xaiv Txhua cov lus txib.
Image -
Xaiv tus Customize the Ribbon poob xub thiab xaiv Main Tabs.
Image -
Ntawm thiab nthuav qhia Review qeb.
Image -
Xaiv New Group.
Image -
Ua kom paub tseeb tias Pab Pawg Tshiab nkag mus yog tseem ceeb, tom qab ntawd xaiv Rename.
Image -
Nyob rau hauv Rename dialog box, sau lub npe zaub rau pab pawg. Piv txwv li, sau Track Changes.
Image - Xaiv OK txhawm rau siv qhov hloov pauv thiab kaw Rename dialog box.
-
In the Excel Options dialog box, mus rau All Commands daim ntawv, tom qab ntawd xaiv txhua yam hauv qab no:
- Sib piv thiab sib sau ua ke phau ntawv ua haujlwm (Legacy)
- Tiv Thaiv Kev Sib Koom (Legacy)
- Share Workbook (Legacy)
- Txoj kev hloov pauv (Legacy)
Tom qab koj xaiv txhua lo lus txib, xaiv Ntxivtxhawm rau ntxiv cov lus txib ntawd rau hauv Kev Tshawb Xyuas tab.
Image - Xaiv OK siv koj cov kev hloov pauv thiab kaw Excel Options dialog box.
-
Plaub txoj kev hloov pauv cov lus txib tshwm nyob rau ntawm Review tab hauv pab pawg tshiab uas koj tsim.
Image
Yuav ua li cas qhib Kev Hloov Hloov hauv Excel
Tom qab koj tau nkag mus rau tag nrho cov ntaub ntawv hauv daim ntawv ua haujlwm, tig rau Txoj Kev Hloov Pauv ua ntej ua Excel phau ntawv ua haujlwm rau kev tshuaj xyuas.
-
Mus rau Review tab thiab xaiv Track Changes > Highlight Changes.
Image - In the Highlight Changes dialog box, xaiv lub Track hloov thaum kho kos lub thawv.
- Xaiv lub Thaum kos lub thawv thiab teeb tsa rau Txhua.
- Xaiv lub Who kos lub thawv thiab teeb rau Txhua tus.
-
Xaiv qhov Highlight hloov ntawm qhov screen kos lub thawv.
Image - Xaiv OK.
-
Nyob ntawm Review tab, xaiv Share Workbook.
Image -
Nyob hauv Share Workbook dialog box, mus rau Editing tab thiab xaiv lub Siv cov phau ntawv qub qub feature es tsis txhob ntawm qhov tshiab co-authoring experience check box.
Image - Xaiv OK.
-
Ntawm Review tab, xaiv Tiv thaiv Phau Ntawv Qhia.
Image -
Nyob hauv Tiv thaiv Phau Ntawv Qhia Ua Haujlwm dialog box, xaiv lub Siv nrog kev hloov pauv kos lub thawv.
Image - Xaiv OK.
Share the Workbook
Thaum koj phau ntawv qhia ua haujlwm tau npaj los tshuaj xyuas, xa cov ntaub ntawv mus rau qhov chaw uas koj pab neeg tuaj yeem nkag mus. Piv txwv li, upload phau ntawv ua haujlwm mus rau qhov chaw SharePoint, OneDrive folder, lossis Dropbox.
Txoj Kev Hloov Hloov Cov yam ntxwv tsis ua haujlwm nrog cov ntawv ua haujlwm uas muaj cov rooj. Cov ntxhuav yuav tsum tau hloov mus rau ntau yam.
Tom qab phau ntawv ua haujlwm raug xa mus, ceeb toom rau koj cov neeg koom tes tias cov ntaub ntawv npaj txhij rau lawv tshuaj xyuas. Ib txoj hauv kev los ua qhov no yog siv Share feature hauv Excel.
Yog tias koj tsis muaj qhov chaw teeb tsa uas nkag tau rau txhua tus neeg tshuaj xyuas, email cov ntaub ntawv ua haujlwm rau txhua tus neeg tshuaj xyuas.
Yuav ua li cas saib thiab lees txais kev hloov pauv
Tom qab tag nrho koj cov neeg tshuaj xyuas tau muaj sijhawm los tshuaj xyuas thiab kho cov ntawv ua haujlwm, nws yog lub sijhawm lees txais lossis tsis lees txais cov kev hloov pauv no.
-
Mus rau Review tab thiab xaiv Track Changes > Accept or Reject Changes.
Image -
Nyob rau hauv Xaiv Hloov Txais lossis Tsis lees txais dialog box, tshem lub Qhov twg checkbox kom lees txais lossis tsis lees txais cov kev hloov pauv rau tag nrho phau ntawv ua haujlwm.
Image - Xaiv OK.
-
Rau txhua qhov kev hloov pauv, xaiv ib qho Accept lossis Reject.
Image
Yuav ua li cas tig tawm kev hloov pauv
Thaum koj ua tiav nrog qhov kev tshuaj xyuas thiab tsis xav mus txuas ntxiv mus taug qab cov kev hloov pauv hauv phau ntawv ua haujlwm, kaw qhov Track Changes feature.
-
Mus rau Review tab thiab xaiv Track Changes > Highlight Changes.
Image -
In the Highlight Changes dialog box, clear all the check boxes.
Image - Xaiv OK.
