Koj puas muaj ob daim ntawv rau ib qhov haujlwm uas koj xav sib piv ib sab? Cov wikiHow no yuav qhia koj li cas los sib piv Excel cov ntawv hauv tib phau ntawv siv koj lub khoos phis tawj.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Saib Cov Ntawv Los Ntawm Ib Sab
Kauj Ruam 1. Qhib koj phau ntawv ua haujlwm hauv Excel
Koj tuaj yeem qhib qhov program (los ntawm koj Start Menu lossis Applications folder) thiab qhib koj phau ntawv ua haujlwm los ntawm txhaj File> Qhib los ntawm cov ntawv qhia zaub mov tseem ceeb toolbar lossis koj tuaj yeem nyem rau ntawm phau ntawv ua haujlwm cov ntaub ntawv hauv File Explorer lossis Finder thiab nyem rau Qhib Nrog> Excel.
Kauj Ruam 2. Nyem rau View menu
Koj yuav tsum pom qhov no hauv qhov toolbar ribbon saum koj daim ntawv lossis saum koj lub vijtsam.
Kauj Ruam 3. Nyem Qhov rai Tshiab
Qhov no tseem yog lub cim ntawm ntau lub qhov rais.
Kauj Ruam 4. Nias Alt+Tab ↹ kom pom lub qhov rai tshiab
Koj tuaj yeem khaws cia Alt nyuaj siab thiab nias Tab mus ncig los ntawm qhov nquag thiab qhib qhov rais ntawm koj lub computer. Tso ob qho tib si thaum koj muaj lub qhov rai tseem ceeb uas koj xav pom.
Kauj Ruam 5. Nyem qhib daim ntawv thib ob
Tam sim no koj yuav tsum pom ob daim ntawv ntawm koj lub qhov rais thiab nias Alt + Tab hloov ntawm lawv.
Yog tias koj xav pom lawv ib sab-ib-sab, koj tuaj yeem kho qhov loj ntawm lub qhov rais los ntawm kev rub thiab poob ib lub ces kaum ntawm lub qhov rais
Txoj Kev 2 ntawm 2: Siv Cov Qauv los Nrhiav Qhov Sib Txawv
Kauj Ruam 1. Qhib koj phau ntawv ua haujlwm hauv Excel
Koj tuaj yeem qhib qhov program (los ntawm koj Start Menu lossis Applications folder) thiab qhib koj phau ntawv ua haujlwm los ntawm txhaj File> Qhib los ntawm cov ntawv qhia zaub mov tseem ceeb toolbar lossis koj tuaj yeem nyem rau ntawm phau ntawv ua haujlwm cov ntaub ntawv hauv File Explorer lossis Finder thiab nyem rau Qhib Nrog> Excel.
Txhawm rau siv cov mis no kom raug, cov ntawv yuav tsum nyob hauv tib phau ntawv ua haujlwm
Kauj ruam 2. Nyem rau ntxiv (+) los tsim ib daim ntawv tshiab
Koj yuav pom lub cim no hauv qab ntawm koj lub vijtsam, nyob ib sab ntawm koj cov ntawv tab uas twb muaj lawm.
Kauj Ruam 3. Nkag mus rau tus lej sib piv rau hauv lub xov tooj ntawm tes dawb paug
Cov mis sib piv yog "= YOG (Sheet1! A1 Sheet7! A1," Sheet1: "& Sheet1! A1 &" vs Sheet7: "& Sheet7! A1," ")" thiab koj yuav tsum sau cov mis ntawd rau hauv A1, thawj lub xovtooj ntawm daim ntawv.
Cov mis no piv cov ntawv 1 txog Ntawv 7 Yog tias koj xav sib piv cov ntawv sib txawv, hloov cov npe ntawv hauv cov mis
Kauj Ruam 4. Luag qhov pib-tuav tuav hla qhov koj xav tau
Koj yuav tsum tau sau nws tus kheej ntau npaum li daim ntawv no raws li koj xav sib piv hauv lwm daim ntawv.
Piv txwv li, yog tias cov ntaub ntawv hauv lwm daim ntawv los ntawm A1 txog G27, rub qhov pib sau nws tus kheej kom puv qhov ntawd
Kauj Ruam 5. Nrhiav qhov sib txawv uas tau teev tseg
Cov xov tooj ntawm tes uas zoo ib yam ntawm ob daim ntawv yuav nyob tas li vim cov xov tooj sib txawv nrog cov ntaub ntawv yuav raug teev tseg.