Yog tias koj yog 9-5, tus kws tshaj lij dawb-dab tshos, muaj feem yuav, koj qhib ib qho ntawm Microsoft lub Office ntau daim ntawv thov ntau zaus hauv ib hnub; tej zaum txawm pib thiab xaus koj hnub ntawm ib tug ntawm lawv. Tawm ntawm txhua daim ntawv thov Office, Excel tau txais kev txiav txim siab tshaj plaws, thiab yog li ntawd. Thaum internet yog dej nyab nrog cov ntawv nthuav qhia, tsis muaj dab tsi piv rau Excel. Txhawm rau tswj hwm kev lag luam ntxiv, Microsoft kuj muaj cov vev xaib thiab cov ntawv thov mobile ntawm nws peb qhov kev siv ntau tshaj plaws (Word, Excel, thiab Powerpoint) tso cai rau cov chaw taws teeb nkag mus rau cov ntaub ntawv, kev sib koom ua ke tiag tiag, autosaving, thiab lwm yam.
Lub teeb yuag web-versions txawm li cas los xij tsis muaj tus lej ntawm cov yam ntxwv siab heev thiab yog li ntawd, cov neeg siv feem ntau rov qab mus rau cov ntawv thov desktop. Thaum muab cov ntaub ntawv los ntawm Excel lub vev xaib mus rau lwm daim ntawv thov lossis txawm tias Excel desktop tus neeg siv, cov neeg siv zoo li tau ntsib qhov yuam kev uas nyeem 'Rov qab cov ntaub ntawv. Tos ob peb vib nas this thiab sim txiav lossis luam dua'. Thaum xub thawj siab ib muag, nws yuav zoo li Excel tsuas yog ua cov ntaub ntawv pasted thiab cov ntaub ntawv yuav tshwm sim sai sai, 'Rov qab cov ntaub ntawv' nyob rau hauv cov lus yuam kev kuj qhia ib yam. Txawm li cas los xij, tos yuav ua rau koj tsis zoo thiab lub xov tooj ntawm tes yuav nthuav tawm cov lus yuam kev es tsis txhob siv cov ntaub ntawv.
Qhov hais tias kev luam theej tawm yuam kev los ntawm Excel lub vev xaib rau Excel daim ntawv thov desktop tau ua rau cov neeg siv tsis txaus siab rau ntau xyoo, Microsoft tau ua tsis tiav los muab kev kho kom ruaj khov rau nws. Qhov tsis muaj kev daws teeb meem tau yuam cov neeg siv nrhiav lawv tus kheej txoj hauv kev nyob ib puag ncig qhov yuam kev. Hauv qab no yog tag nrho cov kev txhim kho paub los daws qhov 'Retrieving Data. Tos ob peb lub vib nas this thiab sim txiav lossis luam dua 'kev ua yuam kev.
Cov ntsiab lus[ zais ]
- Txhim kho Retrieving Data. Tos ob peb feeb thiab sim txiav lossis luam dua yuam kev hauv Excel
- Txoj Kev 1: Deselect, Tos…Copy dua thiab paste
- Txoj Kev 2: Rub tawm cov ntaub ntawv Excel thiab qhib nws hauv Desktop app
- Txoj Kev 3: Sim lwm qhov browser
Txhim kho Retrieving Data. Tos ob peb feeb thiab sim txiav lossis luam dua yuam kev hauv Excel
Ua ntej, tsis txhob txhawj yog tias koj tau txais'Rov qab cov ntaub ntawv. Tos ob peb lub vib nas this thiab sim txiav lossis luam dua 'kev ua yuam kev, vim qhov no tsis yog qhov yuam kev loj thiab yuav coj koj ob peb feeb xwb los daws. Qhov yuam kev tshwm sim yog tias koj sim luam cov ntaub ntawv ua ntej online version ntawm cov ntaub ntawv excel tau ua tiav syncing. Peb qhov kev txhim kho uas cov neeg siv tau ua haujlwm yog deselecting thiab luam tawm cov ntsiab lus dua, rub tawm cov ntawv luam tawm offline thiab qhib nws hauv daim ntawv thov desktop Excel, lossis siv lwm qhov browser sib txawv rau tag nrho.
Txoj Kev 1: Deselect, Tos…Copy dua thiab paste
Ua cov haujlwm uas yuam kev cov lus qhia tsis tshua tau txais txoj haujlwm tiav. Txawm li cas los xij, qhov ntawd tsis yog qhov teeb meem nrog qhov yuam kev tshwj xeeb no. Excel hais kom koj tos ob peb feeb thiab mam li luam cov ntaub ntawv dua, thiab qhov ntawd yog qhov koj yuav tsum ua.
Yog li ntawd, mus tom ntej thiab tshem tawm txhua yam, muaj ib khob dej, lossis scroll los ntawm koj Instagram pub, nias Ctrl + C luam thiab paste nws siv Ctrl + V hauv daim ntawv thov xav tau. Tej zaum koj yuav tau rov ua qhov no ob peb zaug ua ntej koj ua tiav kev luam cov ntaub ntawv. Txawm li cas los xij, qhov no tsuas yog kev daws teeb meem ib ntus xwb, tshawb xyuas ob txoj hauv kev rau kev kho mus tas li.
Txoj Kev 2: Rub tawm cov ntaub ntawv Excel thiab qhib nws hauv Desktop app
Txij li thaum qhov yuam kev tsuas yog ntsib thaum luam lossis txiav cov ntaub ntawv los ntawm Excel lub vev xaib, cov neeg siv tuaj yeem rub tawm daim ntawv offline ntawm daim ntawv thiab qhib nws hauv Excel desktop app. Koj yuav tsum ntsib tsis muaj teeb meem hauv kev luam tawm cov ntaub ntawv los ntawm tus neeg siv khoom desktop.
1. Qhib lub Excel ntaub ntawv koj muaj teeb meem luam cov ntaub ntawv los ntawm hauv Excel web app.
2. Nyem rau Cov ntaub ntawv tam sim no nyob rau saum-sab laug.
3. Nyem rau Txuag li thiab los ntawm cov kev xaiv uas ua raws li, xaiv Download tau ib daim ntawv .
Tam sim no qhib cov ntaub ntawv rub tawm hauv Excel desktop tus neeg siv khoom thiab luam tawm cov ntaub ntawv los ntawm qhov ntawd. Yog tias koj tsis muaj lub khoos phis tawj desktop, koj tuaj yeem siv cov ntawv thov mobile muaj nyob ntawm Android thiab iOS no .
Txoj Kev 3: Sim lwm qhov browser
Qhov 'Retrieving Data…' yuam kev feem ntau ntsib thaum siv Excel web ntawm Internet Explorer lossis Microsoft Edge. Cov neeg siv tau muaj peev xwm mus txog qhov teeb meem los ntawm kev siv lub vev xaib sib txawv. Qhov yuam kev yog tsawg dua nyob rau hauv Google Chrome thiab Mozilla Firefox yog li koj tuaj yeem sim siv ib qho ntawm lawv.
Pom zoo:
- Yuav Ua Li Cas Xauv lossis Xauv Cells Hauv Excel?
- Yuav Ua Li Cas Hloov Kab lossis Kab hauv Excel
- Yuav Ua Li Cas Rov Qab Email Hauv Outlook?
- Phau Ntawv Qhia Kom Tsis Txaus Siab Cov Ntawv Sau Ntawv
Qhov ntawd yog txhua yam rau kab lus no, peb cia siab tias phau ntawv qhia no yuav pab tau thiab koj tuaj yeem ua tau kho Retrieving Data. Tos ob peb feeb yuam kev hauv Excel . Tom qab ua raws li cov lus qhia saum toj no, koj yuav tsum ua tiav kev luam cov ntaub ntawv los ntawm Excel mus rau qhov chaw koj xav tau.
Pete Mitchell Pete yog tus kws sau ntawv laus ntawm Cyber S. Pete nyiam txhua yam cuab yeej siv tshuab thiab tseem yog tus nyiam DIYer hauv siab. Nws muaj kaum xyoo dhau los ntawm kev sau ntawv yuav ua li cas-tos, nta, thiab thev naus laus zis qhia hauv internet.