Qhia tawm cov ntaub ntawv Excel li cas

Cov txheej txheem:

Qhia tawm cov ntaub ntawv Excel li cas
Qhia tawm cov ntaub ntawv Excel li cas
Anonim

Yuav Paub

  • Sau npe rau OneDrive yog tias koj tsis tau muaj tus lej siv nyiaj.
  • Qhib phau ntawv ua haujlwm thiab xaiv Share > Sign In. Sau lub npe thiab xaiv OneDrive nplaub tshev, tom qab ntawd xaiv Txuag. Xaiv Share dua.
  • Nyob hauv Kev xaiv sib koom, xaiv Caw Tib Neeg thiab nkag mus rau cov neeg tau txais cov email chaw nyob. Kos Can Edit kom muab txoj cai kho kom raug.

Nrog Microsoft Excel phau ntawv ua haujlwm sib koom, koj tuaj yeem koom tes nrog lwm tus los ntawm kev ntxiv lossis hloov kho cov ntaub ntawv, qauv, thiab ua qauv ntawm ya los ntawm ntau qhov chaw thiab khoom siv. Nov yog yuav ua li cas muab cov ntaub ntawv Excel hauv Microsoft 365, Excel 2019, Excel 2016, thiab Excel Online.

Sau npe rau OneDrive

Yog tias koj siv Microsoft Office, koj tuaj yeem muaj tus lej OneDrive nquag. Yog tias tsis yog, lossis yog tias koj tsis paub meej, sau npe rau OneDrive ua ntej txuas ntxiv. Qhov kev zam tsuas yog yog tias koj npaj siab yuav muab cov ntaub ntawv Excel tuav ntawm lub tsev qiv ntawv SharePoint Online lossis sab hauv network, qhov twg, koj tsis xav tau OneDrive account.

Ua ntej koj tuaj yeem muab daim ntawv nthuav qhia rau kev sau ua ke, koj yuav tsum khaws nws hauv XLSX, XLSM, lossis XLSB hom.

Yuav ua li cas faib cov ntaub ntawv Excel hauv Microsoft 365 lossis Excel 2019

Qhia ib phau ntawv ua haujlwm Excel:

Cov qauv tshiab ntawm Excel tau hloov pauv Cov Ntawv Qhia Ua Haujlwm nrog cov kev pabcuam hu ua co-authoring. Nws tso cai rau kev sib koom tes zoo sib xws thiab muaj cov cuab yeej siv siab heev uas tsis muaj nyob rau hauv cov laus ntawm Excel.

  1. Qhib Excel phau ntawv koj xav qhia.
  2. Xaiv Share, nyob rau sab xis sab xis ntawm lub vijtsam thiab hauv qab ntawm Search Sheet bar.

    Image
    Image
  3. In the Share dialog box, xaiv Sign In.

    Image
    Image

    Yog tias koj nkag rau hauv koj tus account Microsoft, mus rau kauj ruam 6.

  4. Thaum raug ceeb toom rau koj cov ntaub ntawv pov thawj Microsoft account, ua raws li cov lus qhia ntawm lub vijtsam kom ua tiav cov txheej txheem authentication.

    Image
    Image
  5. Thaum kos npe rau hauv, rov qab mus rau lub ntsiab Excel qhov rai thiab xaiv Share dua.
  6. In the Lub Npe teb, sau ib lub npe rau phau ntawv qhia ua haujlwm.

    Image
    Image
  7. Xaiv qhov Place cov ntawv qhia zaub mov poob los xaiv qhov chaw faib cov ntaub ntawv, piv txwv li, OneDrive. Feem ntau, qhov no yog qhov nyiam qhov chaw tshwj tsis yog tias koj siv lub tsev qiv ntawv SharePoint lossis qhov chaw nyob hauv network.

    Image
    Image
  8. Xaiv Save.

    Image
    Image
  9. Cov ntaub ntawv uploads rau qhov chaw khaws cia koj xaiv hauv kauj ruam 7. Xaiv Share.
  10. Nyob hauv Kev xaiv xaiv cov npe pop-up, xaiv Caw Neeg.

    Koj tsis tas yuav muab phau ntawv ua haujlwm rau kev sib koom tes. Yog tias koj xav muab cov ntawv nyeem nkaus xwb, xaiv Xa daim ntawv.

    Image
    Image
  11. In the Caw Tib Neeg dialog, ntaus email chaw nyob ntawm cov neeg koj xav qhia phau ntawv ua haujlwm nrog. Cais txhua tus email chaw nyob nrog tus lej cim.

    Image
    Image

    Koj tuaj yeem ntaus cov npe los ntawm koj cov neeg sib cuag los ntawm email chaw nyob. Hauv qhov no, koj raug ceeb toom kom muab Excel nkag mus rau daim ntawv thov sib raug.

  12. Sau cov lus rau cov neeg tau txais, yog tias xav tau.
  13. The Can Khov kev xaiv, nrog rau lub thawv kos, yog neeg xiam oob qhab los ntawm lub neej ntawd rau kev ceev faj thiab hais tias cov neeg txais tsis tuaj yeem hloov kho cov ntaub ntawv Excel. Txhawm rau tshem tawm qhov kev txwv nyeem nkaus xwb, xaiv lub thawv kos kom pom cov cim kos.

    Image
    Image
  14. Xaiv Share. Koj cov neeg tau txais kev ceeb toom tias tau muab phau ntawv ua haujlwm rau lawv.

Yuav ua li cas Qhia cov ntaub ntawv hauv Excel Online

Ib yam li Excel rau Microsoft 365 thiab Excel 2019, lub vev xaib-raws li Excel siv cov kev sau ntawv sib koom ua ke los ntawm qhov uas tau siv los hu ua Shared Workbooks.

  1. Mus rau Excel Online hauv web browser thiab qhib phau ntawv ua haujlwm uas koj xav qhia.
  2. Xaiv Share, nyob rau sab xis sab xis ntawm lub qhov rais browser kom tso saib Caw Cov Neeg dialog box.

    Image
    Image
  3. Nyob hauv To teb, ntaus email chaw nyob ntawm cov neeg koj xav qhia phau ntawv ua haujlwm nrog, txhua qhov sib cais los ntawm tus lej cim.

    Image
    Image
  4. Nyob rau hauv Ntxiv daim ntawv ceev teb, sau cov lus cuam tshuam rau koj cov neeg tau txais.

    Image
    Image
  5. Xaiv Tus neeg txais tuaj yeem hloov kho.

    Image
    Image
  6. Ob daim ntawv qhia zaub mov tshwm. Thawj muaj cov kev xaiv hauv qab no: Cov neeg txais tuaj yeem hloov kho(default) thiab Cov neeg tau txais tsuas tuaj yeem saib. Yog tias koj xaiv qhov kawg, koj cov neeg txais yuav tau txais phau ntawv ua haujlwm nrog kev txwv kev nyeem nkaus xwb.

    Image
    Image
  7. Cov ntawv qhia zaub mov thib ob qhia seb koj cov neeg tau txais kev pab xav tau Microsoft account kom nkag mus rau cov ntaub ntawv. Xaiv qhov kev xaiv uas ua tau raws li koj xav tau.
  8. Xaiv Share. Koj cov neeg tau txais kev ceeb toom tias phau ntawv ua haujlwm tau muab qhia rau lawv.

Yuav Qhia Ib Cov Ntaub Ntawv hauv Excel 2016

Ua raws li Microsoft 365 cov lus qhia, raws li kev sib koom ua ke thiab cov kauj ruam zoo sib xws. Qhov sib txawv tseem ceeb yog Share khawm, uas tshwm nyob rau sab xis sab xis thiab sawv cev los ntawm lub taub hau thiab lub cev nrog rau lo lus Share.

Yog tias koj xav tau, koj tuaj yeem siv Daim Ntawv Qhia Ua Haujlwm. Ua li no, ntxiv cov kev xaiv tsim nyog rau Quick Access Toolbar los ntawm kev ua raws cov kauj ruam hauv qab no.

Tshwj tsis yog tias koj muaj qhov xav tau tshwj xeeb los ua kom muaj kev ua haujlwm ntawm Phau Ntawv Qhia Ua Haujlwm, xws li kev sib koom ntawm lub network txwv nrog cov kev cai tshwj xeeb, siv kev sau ntawv sib koom ua ke.

Ntxiv cov Khawm Phau Ntawv Qhia Ua Haujlwm hauv macOS

Txhawm rau ntxiv Cov Ntawv Qhia Ua Haujlwm hauv macOS:

  1. Xaiv Excel > Preferences.
  2. In the Excel Preferences dialog, xaiv Ribbon & Toolbar, nyob rau hauv Authoring ntu.
  3. Xaiv Quick Access Toolbar.
  4. Nyob hauv Xaiv cov lus txib los ntawm chaw, xaiv Review Tab.
  5. Nyob rau hauv daim ntawv teev cov kev xaiv, xaiv Qhia Phau Ntawv Qhia (Legacy) los qhia nws.
  6. Xaiv txoj hlua khi txoj cai (>) pom nyob ib sab ntawm Share Workbook (Legacy) kev xaiv kom nws txav mus rau daim ntawv teev npe Customize Quick Access Toolbar.
  7. Xaiv Txuag kom ua tiav cov txheej txheem. Tam sim no koj tuaj yeem pib cov txheej txheem sib koom los ntawm Excel toolbar.

Ntxiv cov Khawm Phau Ntawv Qhia Ua Haujlwm hauv Windows

Ua raws cov kauj ruam no txhawm rau ntxiv Cov Ntawv Qhia Ua Haujlwm rau Excel 2016 rau Windows:

  1. Select File > Options > Quick Access Toolbar.
  2. Xaiv Xaiv cov lus txib los ntawm txhawm rau nthuav nws, tom qab ntawd xaiv Txhua Cov Lus txib.
  3. Scroll down thiab xaiv Qhia Phau Ntawv Qhia (Legacy) txhawm rau qhia nws.
  4. Xaiv Ntxiv.
  5. Ntxiv txhua cov lus txib hauv qab no, ib zaug ib zaug: Txoj kev hloov pauv (Legacy), Tiv Thaiv Kev Sib Koom (Legacy), Sib piv thiab sib koom ua ke phau ntawv ua haujlwm.
  6. Tom qab cov khoom no ntxiv, xaiv OK rov qab mus rau lub ntsiab Excel qhov rai. Tam sim no koj tuaj yeem pib cov txheej txheem sib koom los ntawm Excel toolbar.

Pom zoo: