Yuav ua li cas ntxig, kho, lossis tshem tawm cov lus hauv Excel

Cov txheej txheem:

Yuav ua li cas ntxig, kho, lossis tshem tawm cov lus hauv Excel
Yuav ua li cas ntxig, kho, lossis tshem tawm cov lus hauv Excel
Anonim

Thaum koj muab daim ntawv Excel nrog rau lwm tus neeg, cov lus nug lossis kev txhawj xeeb txog nws cov ntsiab lus tuaj yeem tshwm sim qee zaus. Tsis txhob xa email, tsuas yog ntxiv cov lus qhia rau lwm tus pom.

Txhua tus uas siv daim ntawv nthuav qhia tuaj yeem teb rau cov lus lossis txawm tias tshem tawm. Tag nrho cov lus pom tau cim nrog tus neeg siv lub npe, hnub tim, thiab lub sijhawm sau. Cov lus sib txawv ntawm Excel cov ntawv, uas zoo ib yam li muab daim ntawv nplaum daj rau hauv cov ntaub ntawv. Lwm tus neeg siv tsis tuaj yeem teb cov lus ceeb toom hauv Excel tab sis lawv tuaj yeem nqa cov kev sib tham me me uas siv cov lus pom.

Cov lus qhia hauv qab no tsom rau txoj hauv kev yooj yim tshaj plaws los ntxiv, kho, thiab tshem tawm cov lus hauv Windows lossis ntawm Mac; scroll rau hauv qab ntawm kab lus no rau Excel rau cov lus qhia hauv Android.

Cov ntaub ntawv no hauv kab lus no siv rau Excel 2019, 2016, Excel rau Mac, Excel rau Android, thiab Excel 365.

Inserting, Editing, or Deleting a Comment in Excel for Windows or macOS

Yuav ua li cas ntxiv ib qho lus

Txoj kev yooj yim tshaj plaws los tsim cov lus pom uas lwm tus tuaj yeem teb tau yog ua raws cov kauj ruam no:

  1. Nyob hauv ib daim ntawv qhib, nyem rau ntawm lub xovtooj uas koj xav ua cov lus pom.
  2. Click New Comment in the menu pane.

    Image
    Image
  3. In Pib sib tham, ntaus cov lus koj xav ua.
  4. nias tus xub ntsuab los tso koj cov lus.

    Image
    Image
  5. Txhawm rau tawm cov lus pom, nyem qhov twg ntawm daim ntawv nthuav qhia.

Tej zaum koj yuav pom tias thaum koj nyem lub xub ntsuab, cov lus pom tau pom lub thawv teb. Qhov ntawd yog qhov uas lwm tus nyeem tuaj yeem teb rau cov lus pom. Lawv tsuas ntaus ntawv hauv lawv cov lus teb thiab nyem lub xub ntsuab uas zoo nkaus li tshaj tawm lawv cov lus teb rov qab rau koj. Cov lus teb rov qab los ntawm cov lus no yog hu ua Reply Thread.

Nyob hauv qee cov qauv ntawm Excel, suav nrog Excel 2016, koj tuaj yeem siv Ribbon los tawm lus. Tsuas yog nyem lub xovtooj ntawm qhov koj xav tawm tswv yim, nyem Saib Xyuas ntawm Ribbon, thiab tom qab ntawd nyem Cov Lus Qhia Tshiab lossis Insert Comment.

Hauv Web version ntawm Excel, koj tuaj yeem chij cov lus qhia rau tus nyeem ntawv tshwj xeeb los ntawm kev ntaus tus @ cim ua raws li tus neeg siv lub npe. Qee zaum cov npe poob qis ntawm cov neeg siv kuj muaj nyob rau hauv qhov version no.

Yuav teb li cas rau ib nqe lus

Tau teb rau cov lus pom uas lwm tus tau tso rau koj, koj tuaj yeem nyem rau ntawm lub xov tooj thiab nkag teb tam sim rau hauv lub thawv teb lossis koj tuaj yeem nyem nyem rau ntawm lub xovtooj uas cov lus pom nyob thiab siv Cov Lus Teb box los ntawm muaj.

Txhua lub xovtooj nrog cov lus txuas rau nws yog cim nrog me me, xim xim nyob rau sab xis sab xis. Cov xim yuav txawv raws li koj qhov kev teeb tsa Excel.

How to Edit a Comment

Koj tuaj yeem ntxiv cov lus qhia ntxiv rau cov xov uas koj tau pib lossis koj tuaj yeem hloov kho cov lus koj twb tau tshaj tawm lawm. Txhawm rau hloov cov lus koj tau ua, ua raws cov kauj ruam no:

  1. Click lub cell uas muaj cov lus pom.

  2. Tsiv koj tus nas hla cov lus pom thiab koj yuav pom cov kev xaiv Kho kom raug tshwm sim.
  3. Click Edit.

    Image
    Image
  4. Tau cov kev hloov pauv uas koj yuav tsum ua.
  5. Click Save.

Yog tias koj txiav txim siab ib nrab ntawm koj qhov kev hloov pauv uas koj qhov kev hloov kho tsis tsim nyog, tsuas yog nyem Ncua tseg.

Yuav ua li cas Delete a Comment

Txhua tus neeg tuaj yeem tshem tawm cov lus pom hauv daim ntawv nthuav qhia, tsis yog tus neeg uas pib cov lus qhia. Thaum cov lus tsis xav tau ntxiv lawm, nyem nyem rau ntawm lub cell uas nws nyob thiab nyem Delete Comment los ntawm cov ntawv qhia zaub mov.

Image
Image

Yuav ua li cas Qhia lossis Hide All Comments

Muaj ntau txoj hauv kev uas koj tuaj yeem tshaj tawm thiab teb rau cov lus hauv Excel. Lub Ribbon muaj tag nrho cov lus txheeb xyuas uas tso cai rau koj los qhib Cov Lus Qhia rau sab xis ntawm daim ntawv nthuav qhia. Koj tuaj yeem yooj yim thaws los ntawm cov lus los tawm tswv yim siv ntu ntawm Ribbon lossis ntxiv thiab tshem tawm cov lus. (Tsuas nco ntsoov tias koj tau xaiv lub xovtooj ntawm tes ua ntej koj siv ib qho ntawm Ribbon commands.)

Image
Image

Cov tshuaj xyuas tab kuj tso cai rau koj los qhia lossis zais cov lus. Txhawm rau pom tag nrho cov lus pom hauv daim ntawv nthuav qhia, mus rau Review > Qhia Cov Lus QhiaTxhawm rau zais tag nrho cov lus pom, siv tib cov lus qhia thiab cov lus pom yuav ploj mus. Cov cim ntshav hauv cov lus hais, txawm li cas los xij, yuav tshwm sim ib txwm.

Inserting, editing, or delete a comment on Android

Yuav ua li cas ntxiv ib qho lus

Txhawm rau ntxiv cov lus pom hauv Excel rau Android, koj yuav tsum xub ua haujlwm nyob rau hauv Kev Tshawb Xyuas pane hauv daim ntawv nthuav qhia. Txhawm rau ua qhov no, ua raws cov kauj ruam no:

  1. Qhib cov ntawv nthuav qhia ntawm koj lub Android.
  2. Caws lub xovtooj uas koj xav ua kom pom.
  3. Coj mus rhaub cov xub nyob rau hauv qab sab xis ntawm koj lub vijtsam kom qhib cov ntawv qhia zaub mov pane.
  4. Tap Review nyob rau hauv cov ntawv qhia zaub mov nyob rau sab laug ntawm lub Menu pane. Qhov no yuav qhia tau lwm cov lus txib; coj mus rhaub ob lub xub qhib rau tag nrho cov ntawv qhia zaub mov ntawm kev xaiv thiab nrhiav Review.

    Image
    Image
  5. Tau koj cov lus pom siv cov keyboard onscreen.

    Image
    Image
  6. Coj mus rhaub tus xub rau sab xis ntawm koj cov lus los tso nws.

Yuav teb li cas rau ib nqe lus

Txhawm rau teb cov lus pom hauv Excel rau Android spreadsheets, ua raws cov kauj ruam no:

  1. Caws lub xovtooj ntawm qhov chaw saib.
  2. Tau koj cov lus hauv lub Reply lub thawv.

    Image
    Image
  3. Caw tus xub los tso saib.

Yuav ua li cas Delete a Comment Xov

Txhawm rau rho tawm cov lus hais hauv Excel rau Android cov ntawv nthuav qhia, coj mus rhaub peb kab kab rov tav nyob rau saum cov xov thiab coj mus rhaub Delete xov.

Pom zoo: