Cov wikiHow no qhia koj yuav ua li cas rov qab thiab kho Microsoft Excel cov ntaub ntawv tsis raug ntawm lub Windows lossis Mac computer.
Kauj ruam
Txoj Kev 1 ntawm 5: Kho Cov Ntaub Ntawv
Kauj Ruam 1. Nco ntsoov tias koj siv lub khoos phis tawj Windows
Koj tsuas tuaj yeem kho Excel cov ntaub ntawv ntawm Windows versions ntawm Microsoft Excel.
Yog tias koj siv Mac, sim ib qho ntawm lwm txoj hauv kev hauv kab lus no
Kauj ruam 2. Qhib Excel
Lub cim qhov program zoo li lub thawv ntsuab nrog "X" hauv nws.
Kauj Ruam 3. Nyem Qhib Lwm Phau Ntawv Qhia
Qhov kev xaiv no tshwm nyob ib sab ntawm daim nplaub tshev icon nyob rau sab laug sab laug ntawm lub qhov rais.
Kauj Ruam 4. Nyem Xauj
Lub cim icon no nyob nruab nrab ntawm nplooj ntawv. Tom qab ntawd, Cov Ntaub Ntawv Explorer qhov rai yuav qhib.
Kauj Ruam 5. Xaiv cov ntawv Excel xav tau
Mus rau daim nplaub tshev uas muaj cov ntawv Excel tsis raug, tom qab ntawv nyem rau cov ntawv xaiv nws.
Kauj Ruam 6. Nyem rau "Menu" icon
Lub xub xub cim no yog nyob rau sab xis ntawm " Qhib " Cov ntawv qhia zaub mov nco-down yuav tshwm tom qab ntawd.
Kauj Ruam 7. Nyem Qhib thiab Kho…
Qhov kev xaiv no yog nyob hauv qab ntawm cov ntawv qhia zaub mov nco-down.
Yog hais tias qhov kev xaiv " Qhib thiab Kho… "Tsis tuaj yeem xaiv (pom hauv xim tsis pom kev), nco ntsoov xaiv cov ntawv Excel thiab sim dua. Yog nws tseem tsis tuaj yeem xaiv, cov ntaub ntawv kho tsis tau.
Kauj Ruam 8. Nyem Kho thaum raug hais kom ua
Qhov kev xaiv no nyob hauv lub qhov rai pop-up. Windows yuav sim kho cov ntawv.
Yog tias qhov kev xaiv tsis muaj, nyem " Extract Cov Ntaub Ntawv, ces xaiv " Hloov mus rau qhov muaj nuj nqis "los yog" Rov qab Cov Qauv " Cov ntaub ntawv uas tseem tuaj yeem raug cawm yuav rov qab los.
Kauj Ruam 9. Tos kom cov ntawv qhib
Cov txheej txheem no tuaj yeem siv ob peb feeb yog tias koj cov ntaub ntawv Excel loj txaus.
Yog tias cov ntaub ntawv tseem tsis tuaj yeem qhib, rov ua cov txheej txheem dua thiab nyem " Extract Cov Ntaub Ntawv "(tsis muaj" Kho ") Thaum hais kom ua.
Kauj ruam 10. Txuag cov ntawv
Tom qab kho cov ntaub ntawv raug qhib, nyem Ctrl+S, ob-nias qhov kev xaiv " Lub PC no ", Xaiv qhov chaw khaws tseg, sau lub npe cov ntaub ntawv, thiab nyem" Txuag ”.
Nco ntsoov tias koj siv lub npe cov ntaub ntawv sib txawv dua li cov npe Excel tsis zoo
Txoj Kev 2 ntawm 5: Hloov Cov Ntaub Ntawv Hom ntawm Windows Computer
Kauj Ruam 1. Nkag siab qhov tseem ceeb ntawm cov hom ntaub ntawv
Qee zaum daim ntawv Excel tsim los ntawm lub khoos phis tawj lossis cov ntawv ua ntej ntawm Excel dhau los ua tsis ruaj khov thaum qhib ntawm lub khoos phis tawj lossis hloov kho dua tshiab ntawm Excel program. Ib qho ntxiv, Excel cov ntaub ntawv tseem tuaj yeem khaws cia hauv ntau hom ntaub ntawv. Los ntawm kev hloov pauv Excel cov ntaub ntawv hom rau "xlsx" (lossis "xls" rau cov haujlwm nrog rau cov ntawv ua ntej), qhov teeb meem ntawm cov ntaub ntawv tsis zoo tuaj yeem daws tau.
Kauj Ruam 2. Qhib “Start” menu
Nyem lub logo Windows nyob rau hauv kaum-sab laug ntawm qhov screen.
Kauj Ruam 3. Qhib Qhov File Explorer program
Nyem rau daim nplaub tshev icon uas tshwm nyob rau hauv kaum sab laug ntawm "Start" window.
Kauj Ruam 4. Nyem rau Saib tab
Cov ntawv no yog nyob rau sab saum toj ntawm File Explorer window. Qhov toolbar yuav tshwm hauv qab no tab.
Kauj Ruam 5. Kos rau lub thawv "Cov ntaub ntawv npe txuas ntxiv"
Lub npov no nyob hauv ntu "Qhia/zais" toolbar. Tom qab ntawd, koj tuaj yeem pom cov hom ntawv txuas ntxiv ntawm qhov kawg ntawm cov npe ntaub ntawv, suav nrog cov ntaub ntawv Excel.
Kauj Ruam 6. Xaiv cov ntawv Excel
Mus rau phau ntawv teev npe qhov twg Excel cov ntaub ntawv koj xav rov qab, tom qab ntawv nyem rau daim ntawv xaiv nws.
Kauj Ruam 7. Nyem Tsev
Cov ntawv no yog nyob rau sab saud sab laug ntawm File Explorer window. Lub toolbar yuav tshwm tom qab.
Kauj Ruam 8. Nyem Rename
Qhov kev xaiv no nyob hauv ntu "Npaj" toolbar ntu. Thaum nyem, lub npe Excel cov ntaub ntawv yuav raug cim.
Kauj Ruam 9. Hloov hom ntawv
Hloov qhov txuas ntxiv uas tshwm tom qab lub sijhawm kawg ntawm lub npe nrog xlsx, tom qab ntawv nyem Enter.
- Piv txwv, yog tias daim ntawv muaj npe "Spreadsheet1.docx", hloov nws mus rau "Spreadsheet1.xlsx".
- Yog tias cov ntaub ntawv twb muaj "xlsx" txuas ntxiv, sim siv "xls" lossis "html".
Kauj Ruam 10. Nyem Yog thaum tau txais kev tshoov siab
Cov kev hloov pauv yuav raug lees paub thiab cov ntaub ntawv txuas ntxiv yuav raug hloov pauv.
Kauj Ruam 11. Sim qhib cov ntawv
Ob npaug nias rau cov ntawv kom qhib nws. Yog tias cov ntawv tuaj yeem qhib hauv (lossis lub vev xaib yog tias koj xaiv "html" ua qhov txuas ntxiv), cov ntaub ntawv tau ua tiav tiav.
- Yog tias koj xaiv qhov "html" txuas ntxiv, koj tuaj yeem hloov lub vev xaib mus rau hauv Excel daim ntawv los ntawm kev rub cov ntawv "html" mus rau Excel lub cim program, thiab khaws cov ntawv qhib ua "xlsx" tshiab.
- Yog tias cov ntaub ntawv tseem tsis qhib, txav mus rau txoj hauv kev Windows tom ntej.
Txoj Kev 3 ntawm 5: Hloov Cov Ntaub Ntawv Hom ntawm Mac Computer
Kauj Ruam 1. Nkag siab qhov tseem ceeb ntawm cov hom ntaub ntawv
Qee zaum daim ntawv Excel tsim los ntawm lub khoos phis tawj lossis ua ntej Excel version ua tsis ruaj tsis khov thaum qhib hauv computer lossis hloov kho tshiab ntawm Excel program. Ib qho ntxiv, Excel cov ntaub ntawv tseem tuaj yeem khaws cia hauv ntau hom ntaub ntawv. Los ntawm kev hloov pauv Excel cov ntaub ntawv hom rau "xlsx" (lossis "xls" rau cov haujlwm nrog rau cov ntawv ua ntej), qhov teeb meem ntawm cov ntaub ntawv tsis zoo tuaj yeem daws tau.
Kauj Ruam 2. Qhib Finder
Nyem rau lub ntsej muag xiav lub ntsej muag uas tshwm hauv koj lub khoos phis tawj lub Dock.
Kauj Ruam 3. Xaiv cov ntawv Excel
Mus rau daim nplaub tshev uas khaws cov ntaub ntawv Excel, tom qab ntawv nyem rau cov ntaub ntawv uas koj xav rov qab.
Kauj Ruam 4. Nyem Cov Ntaub Ntawv
Cov ntawv qhia zaub mov xaiv no yog nyob rau sab saud sab laug ntawm koj lub computer screen. Thaum nyem, cov ntawv qhia zaub mov nco-down yuav tshwm.
Kauj Ruam 5. Nyem Tau Cov Ntaub Ntawv
Qhov kev xaiv no yog nyob hauv cov ntawv qhia zaub mov nco-down " Cov ntaub ntawv " Lub qhov rai pop-up yuav qhib tom qab.
Kauj Ruam 6. Nthuav ntu "Npe & Txuas Ntxiv" yog tias tsim nyog
Yog tias koj tsis pom lub npe cov ntaub ntawv lossis txuas ntxiv hauv pawg no, nyem rau daim duab peb sab icon rau sab laug ntawm "Npe & Txuas Ntxiv" nqe lus kom pom cov npe ntawv thiab txuas ntxiv.
Kauj Ruam 7. Hloov hom ntawv
Hloov qhov txuas ntxiv uas tshwm tom qab lub sijhawm kawg ntawm lub npe cov ntaub ntawv nrog xlsx, tom qab ntawv nyem Rov qab.
- Piv txwv, yog tias daim ntawv muaj npe "Spreadsheet1.txt", hloov nws mus rau "Spreadsheet1.xlsx".
- Yog tias cov ntaub ntawv twb muaj "xlsx" txuas ntxiv, sim siv "xls" lossis "html" txuas ntxiv.
Kauj Ruam 8. Nyem Siv.xlsx thaum hais kom ua
Kev xaiv yuav raug lees paub thiab hom ntawv yuav raug hloov.
Kauj Ruam 9. Sim qhib cov ntawv
Nyem ob npaug rau cov ntawv kom qhib nws. Yog tias cov ntaub ntawv tuaj yeem qhib hauv Excel (lossis lub web browser yog tias koj xaiv qhov "html" txuas ntxiv), cov ntaub ntawv tau ua tiav zoo.
- Yog tias koj xaiv qhov "html" txuas ntxiv, koj tuaj yeem hloov pauv lub vev xaib mus rau Excel daim ntawv los ntawm kev rub cov ntawv "html" mus rau Excel lub cim program, tom qab ntawd khaws cov ntawv qhib ua "xlsx" tshiab.
- Yog tias cov ntaub ntawv tseem tsis qhib, txav mus rau Mac txoj hauv kev tom ntej.
Txoj Kev 4 ntawm 5: Rov Rov Los Cov Ntaub Ntawv Ib Ntus ntawm Windows Computer
Kauj Ruam 1. Nkag siab qhov txwv ntawm txoj kev no
Zoo li feem ntau ntawm Microsoft Office cov khoom, Microsoft Excel yuav cia li khaws cov ntaub ntawv rov ua dua. Qhov no txhais tau tias koj tuaj yeem rov kho ib feem ntawm cov ntaub ntawv lossis ib feem ntawm cov ntawv Excel tsis raug. Txawm li cas los xij, Excel tsis tas yuav khaws cov ntaub ntawv raws sijhawm thiab nws muaj peev xwm uas koj yuav tsis tuaj yeem rov qab tau tag nrho cov ntawv no.
Kauj Ruam 2. Qhib “Start” menu
Nyem lub logo Windows nyob rau hauv kaum-sab laug ntawm qhov screen.
Kauj Ruam 3. Ntaus lub pc no
Tom qab ntawd, lub khoos phis tawj yuav tshawb rau qhov program "PC no".
Kauj Ruam 4. Nyem rau PC no
Nws yog lub khoos phis tawj saib lub cim nyob rau sab saud ntawm "Pib" qhov rai. Tom qab ntawd, lub qhov rai "PC no" yuav tshwm.
Kauj Ruam 5. Nyem ob npaug rau lub computer hard drive
Feem ntau nws tau sau lo lus "OS (C:)" thiab tshwm nyob rau hauv "Devices and drives" nqe lus nyob hauv nruab nrab ntawm nplooj ntawv.
Kauj Ruam 6. Nyem ob npaug rau daim ntawv "Cov neeg siv"
Cov ntawv no nyob nruab nrab ntawm daim nplaub tshev hard drive.
Kauj Ruam 7. Nyem ob npaug rau tus neeg siv ntawv tais ceev tseg
Cov npe no muaj npe tom qab ib feem lossis tag nrho koj lub npe siv hauv computer.
Kauj ruam 8. Nyem ob npaug rau "AppData" nplaub tshev
Cov ntawv no nyob hauv ntu "A" yog li muaj lub sijhawm zoo koj yuav pom nws nyob rau sab saum toj ntawm cov ntaub ntawv tshawb xyuas qhov rai.
Yog tias daim ntawv tsis tuaj yeem pom, nyem rau tab " Saib ", Tom qab ntawd khij lub npov" Cov khoom zais "hauv ntu" Qhia/zais "kom pom" AppData "nplaub tshev.
Kauj ruam 9. Nyem ob npaug rau daim ntawv "Local"
Qhov kev xaiv no yog nyob rau sab saum toj ntawm daim nplaub tshev.
Kauj ruam 10. Scroll cia thiab ob npaug nias rau “Microsoft” nplaub tshev
Cov ntawv no nyob hauv ntu "M".
Kauj Ruam 11. Nyem ob npaug rau daim ntawv "Chaw Haujlwm"
Cov ntawv no nyob hauv ntu "O" ntawm "Microsoft" nplaub tshev.
Kauj ruam 12. Nyem ob npaug rau daim ntawv "UnsavedFiles"
Daim nplaub tshev no nyob rau sab saum toj ntawm lub qhov rais.
Kauj Ruam 13. Xaiv cov ntawv Excel
Saib rau Excel cov ntawv cim nrog tib lub npe zoo li cov ntaub ntawv Excel tsis zoo, tom qab ntawv nyem rau ntawm cov ntawv xaiv nws.
Yog tias koj tsis pom ib daim ntawv twg, qhov rov ua dua ntawm daim ntawv Excel tsis raug cawm
Kauj Ruam 14. Hloov Excel cov ntaub ntawv txuas ntxiv
Hloov nws:
- Nyem " Saib ”.
- Khij lub npov "Cov ntaub ntawv npe txuas ntxiv".
- Nyem " Tsev ”.
- Nyem " Hloov npe ”.
- Hloov qhov.tmp txuas ntxiv nrog.xlsx.
- Nias qhov Enter.
- Nyem " Yog lawm 'thaum kev ceeb toom.
Kauj Ruam 15. Qhib cov ntawv Excel
Nyem ob npaug rau cov ntaub ntawv hloov npe tsis ntev los no los qhib nws.
Kauj Ruam 16. Txuag cov ntawv
Tom qab cov ntaub ntawv rov qab tau qhib, nyem Ctrl+S qhov tseem ceeb ua ke, ob npaug nias rau " Lub PC no ", Xaiv cov npe khaws cia, sau lub npe cov ntaub ntawv, thiab nyem rau" Txuag ”.
Nco ntsoov tias koj xaiv lub npe cov ntaub ntawv sib txawv dua li lub npe yav dhau los siv rau cov ntawv Excel tsis raug
Txoj Kev 5 ntawm 5: Rov Rov Qab Cov Ntaub Ntawv Ib Ntus ntawm Mac Computer
Kauj Ruam 1. Nkag siab qhov txwv ntawm txoj kev no
Zoo li feem ntau ntawm Microsoft Office cov khoom, Microsoft Excel yuav cia li khaws cov ntaub ntawv rov ua dua. Qhov no txhais tau tias koj tuaj yeem rov kho ib feem ntawm cov ntaub ntawv lossis ib feem ntawm cov ntawv Excel tsis raug. Txawm li cas los xij, Excel tsis tas yuav khaws cov ntaub ntawv raws sijhawm thiab nws muaj peev xwm uas koj yuav tsis tuaj yeem rov qab tau tag nrho cov ntawv no.
Kauj ruam 2. Nyem Mus
Cov ntawv qhia zaub mov no yog nyob rau sab saum toj ntawm qhov screen. Thaum nyem, cov ntawv qhia zaub mov nco-down yuav qhib.
Yog tias koj tsis pom qhov kev xaiv " Mus ", Qhib Finder lossis thawj zaug nyem lub desktop rau cov kev xaiv kom tshwm.
Kauj Ruam 3. Tuav tus yuam sij Xaiv
Tom qab ntawd, koj tuaj yeem pom daim nplaub tshev " Tsev qiv ntawv "hauv cov ntawv qhia zaub mov nco" Mus ”.
Kauj Ruam 4. Nyem Lub Tsev Qiv Ntawv
Qhov kev xaiv no yog nyob hauv cov ntawv qhia zaub mov nco-down " Mus " Cov ntawv " Tsev qiv ntawv "Zais yuav raug qhia.
Kauj Ruam 5. Qhib cov ntawv "Ntim"
Nyem ob npaug rau "Ntim" nplaub tshev uas nyob hauv ntu "C" ntawm "Library" nplaub tshev.
Kauj Ruam 6. Nyem rau kab ntawv tshawb fawb
Nws nyob rau sab xis-sab xis ntawm lub qhov rais.
Kauj Ruam 7. Nrhiav “Microsoft Excel” nplaub tshev
Ntaus com.microsoft.excel thiab nias Rov qab.
Kauj Ruam 8. Nyem rau Cov Thawv tab
Cov ntawv no yog nyob rau sab xis ntawm "Tshawb nrhiav:" nqe lus nyob rau sab saum toj ntawm lub qhov rai Finder.
Kauj Ruam 9. Qhib "com.microsoft.excel" nplaub tshev
Ob npaug nias rau daim nplaub tshev kom qhib nws.
Kauj ruam 10. Qhib "Cov Ntaub Ntawv" nplaub tshev
Kauj Ruam 11. Qhib daim ntawv "Library"
Kauj Ruam 12. Qhib qhov "Nyiam" nplaub tshev
Yog tias koj tsis pom daim nplaub tshev no, los so kom txog thaum koj pom nws.
Kauj Ruam 13. Qhib "AutoRecovery" nplaub tshev
Ib daim ntawv teev cov ntaub ntawv khaws tseg ntawm Excel cov ntaub ntawv yuav raug tso tawm kom pom.
Kauj Ruam 14. Saib rau ib ntus ntawm cov ntaub ntawv Excel tsis zoo
Cov ntawv ib ntus ntawm cov ntaub ntawv muaj ib feem lossis tag nrho cov npe hauv cov npe.
Yog tias koj tsis tuaj yeem pom cov ntawv ib ntus ntawm cov ntaub ntawv koj xav tau, nws tsis tau txais kev txhawb nqa los ntawm Microsoft Excel
Kauj Ruam 15. Xaiv cov ntawv Excel
Nyem rau cov ntawv kom xaiv nws.
Kauj Ruam 16. Nyem Cov Ntaub Ntawv
Cov ntawv qhia zaub mov xaiv no yog nyob rau sab saud sab laug ntawm koj lub computer screen. Cov ntawv qhia zaub mov nco-down yuav tshwm tom qab ntawd.
Kauj Ruam 17. Xaiv Qhib Nrog
Nws yog nyob rau sab saum toj ntawm cov ntawv qhia zaub mov nco-down " Cov ntaub ntawv " Cov ntawv qhia zaub mov pop-out yuav tshwm tom qab ntawd.
Kauj Ruam 18. Nyem rau Excel
Nws nyob hauv cov ntawv qhia zaub mov pop-out. Cov ntawv ib ntus ntawm daim ntawv yuav qhib hauv Microsoft Excel.
Cov ntawv ib ntus no yuav tsis muaj qee qhov kev hloov pauv tsis ntev los no uas koj tau ua yav dhau los rau hauv daim ntawv Excel qub
Kauj Ruam 19. Khaws daim ntawv
Nias Command+S qhov tseem ceeb ua ke, sau lub npe cov ntaub ntawv, xaiv qhov chaw cia khoom hauv "Qhov twg" ntawv qhia zaub mov, thiab nyem " Txuag ”.
Lub tswv yim
- Cov khoos phis tawj Windows feem ntau sim kho cov ntawv ua haujlwm tsis raug Excel thaum koj qhib lawv.
- Koj tuaj yeem qhib cov ntaub ntawv Excel tsis zoo los ntawm kev ua kom muaj kev nyab xeeb ntawm koj lub computer. Yog tias daim ntawv tuaj yeem qhib hauv hom ntawd, cov ntaub ntawv yuam kev lossis kab mob tuaj yeem yog qhov ua rau cov ntaub ntawv tsis qhib ib txwm muaj.
- Muaj ntau txoj haujlwm them nyiaj rov qab cov ntaub ntawv uas tuaj yeem siv los rov qab cov ntaub ntawv tsis raug Excel. Stellar Phoenix Excel Kho yog ib qho piv txwv thiab muaj rau Windows thiab Mac khoos phis tawj.
