Yuav Ua Li Cas Hloov Cov Kev Xaiv Hauv Excel

Cov txheej txheem:

Yuav Ua Li Cas Hloov Cov Kev Xaiv Hauv Excel
Yuav Ua Li Cas Hloov Cov Kev Xaiv Hauv Excel

Video: Yuav Ua Li Cas Hloov Cov Kev Xaiv Hauv Excel

Video: Yuav Ua Li Cas Hloov Cov Kev Xaiv Hauv Excel
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Tej zaum
Anonim

Microsoft Office Excel cov ntawv tshaj xo yog qhov siv dav ua daim ntawv thov niaj hnub no. Tom qab txhim kho qhov tshiab version ntawm cov program no, feem ntau nws yuav tsum tau hloov nws lub chaw txhawm rau coj lawv mus rau daim ntawv ib txwm siv. Kev nkag mus rau cov kev nkag mus hauv cov phiaj xwm hauv cov kho cov ntawv xov xwm hloov tshiab tau teeb ua ntau txoj kev.

Yuav ua li cas hloov cov kev xaiv hauv Excel
Yuav ua li cas hloov cov kev xaiv hauv Excel

Tsim nyog

Microsoft Office Excel cov ntawv teev lus tshaj tawm

Cov Lus Qhia

Kauj ruam 1

Nthuav qhov "Cov ntaub ntawv" ntu hauv cov ntawv qhia zaub mov. Yog tias koj siv tus qauv ntawm Excel 2010, tom qab rau qhov no koj yuav tsum nyem lub khawm ntsuab nyob rau sab saud sab sauv ntawm daim ntawv thov lub qhov rai. Hauv xyoo 2007, hloov nws, hauv kwv yees li ntawm tib qhov chaw, muaj ntau qhov khawm loj uas tsis muaj cov cim npe, uas cov chaw tsim khoom hu Microsoft Chaw Haujlwm hauv txhua cov ntaub ntawv. Koj tuaj yeem qhib cov zaub mov no hauv lwm txoj kev - nias lub alt="Duab" qhov tseem ceeb thiab qhov kev zov me nyuam yuav tso cov tsiaj ntawv ntawm Lav Xias Lav Xias rau txhua cov ntawv qhia. Nias tus yuam sij nrog tus ntawv sib haum yuav qhib cov ntawv qhia zaub mov cuam tshuam nrog nws, tsab ntawv "F" yog muab rau "Cov Ntawv".

Kauj ruam 2

Xaiv Xaiv yog tias koj siv Excel 2010 - nov yog kab thib ob los hauv qab ntawm cov ntawv qhia zaub mov tseem ceeb. Hauv Excel 2007, cov khoom no hloov lub pob nrog cov ntawv "Excel Xaiv" nyob rau hauv qab yog kaum hauv qab ntawm cov ntawv qhia zaub mov nco - nyem nws. Ob qho ntawm cov kev ua no qhib cov txheej txheem teeb tsa ua haujlwm nplooj, uas tau muab faib ua ntu, cov npe uas tau muab tso rau ntawm nws sab laug.

Kauj ruam 3

Yog tias koj siv daim ntawv tseem ceeb tshaj ntawm Microsoft Excel (piv txwv, Excel 2003), tom qab ntawd saib rau yam khoom uas xav tau hauv seem "Cov Cuab Yeej" ntawm daim ntawv thov zaub mov. Nws hu ua "Tsis Tshaj Xo" thiab qhib qhov chaw teeb tsa cais nyias nyias, ua los ntawm kaum plaub tus tab.

Kauj ruam 4

Muaj ntau lub chaw ntawm lub pob ntawm cov ntawv sau tuaj yeem hloov pauv yam tsis siv nplooj ntawv chaw. Piv txwv li, txhawm rau hloov cov nplooj ntawv qhib ua haujlwm pib nplai, tsuas yog yob lub log nas thaum tuav cia Ctrl yuam. Qhov nce (los yog tsawg dua) teev hauv txoj kev no yuav tau txais kev cawm tshwj xeeb los ntawm daim ntawv thov thiab siv rau lwm zaus koj pib Excel.

Pom zoo: