Sijhawm thiab cim sau ntawv tuaj yeem ua qhov sib cais kaum. Hauv txhua lub tebchaws hais lus Askiv, ib lub sijhawm yog siv xws li kev sib cais, thiab hauv tebchaws Lavxias, kev sau siab. Qhov no feem ntau cuam tshuam nrog qhov yuav tsum tau hloov lub sijhawm nrog commas hauv qhov spreadsheet editor Microsoft Office Excel.
Nws yog qhov tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Yog tias qhov taw tes tau tsim los ua tus zauv sib cais hauv qhov chaw ntawm koj daim ntawv teev xwm txheej, koj tuaj yeem hloov qhov no hauv ib ntu ntawm Excel cov chaw teeb tsa. Txhawm rau nws, qhib daim ntawv thov zaub mov. Qhov no tuaj yeem ua tiav los ntawm nias tus yuam sij Alt, thiab tom qab nws - "F" khawm. Hauv Excel 2010 cov ntawv qhia zaub mov, Cov Kev Xaiv raug tso rau hauv cov kab ntawv tseem ceeb ntawm cov lus txib, thiab hauv Excel 2007, Excel Xaiv khawm yog nyob hauv qab-sab xis ntawm cov ntawv qhia zaub mov.
Kauj ruam 2
Xaiv kab "Advanced" hauv kab ntawv sab laug ntawm lub chaw teeb tsa thiab hauv seem "Editing xaiv" nrhiav kab "Siv cov kev cais tawm". Yog tias muaj tus cim hauv npov hauv ib sab ntawm daim ntawv lo no, tom qab ntawd daim teb uas yuav tsum muaj "Separator ntawm tus lej sib ntxiv thiab ntu feem" tsis tuaj yeem hloov kho. Tshem nws, muab lub comma rau hauv kab ntawv sau thiab nyem khawm lawv xav kom hloov mus rau lub chaw teeb tsa.
Kauj ruam 3
Yog tias koj xav hloov lub comma hauv cov xovtooj tshwj xeeb hauv ib daim ntawv txheeb, muaj ob peb txoj hauv kev los ua qhov no. Ua ntej, xaiv lub xov tooj uas xav tau, tom qab ntawd tig mus rau qhov kho kom raug - nias tus yuam sij F2 lossis nyem ob lub xovtooj ntawm no. Tsiv tus cursor txav taw tes thiab hloov nws nrog lub chaw. Tib yam tuaj yeem ua tsis yog hauv lub xovtooj ntawm tes, tab sis nyob rau hauv tus qauv bar - muaj, ib tus nias yog txaus los qhib lub hom hloov.
Kauj ruam 4
Txhawm rau hloov tag nrho txhua lub sijhawm nrog kev sau suab hauv txhua lub hlwb ntawm daim ntawv nthuav dav, siv Nrhiav thiab Hloov Cov Lus Sib Tham. Txhawm rau hu nws, muaj "cov yuam sij kub" Ctrl + H thiab cov khoom "Hloov" rau hauv daim ntawv teev xaiv ntawm lub pob "Nrhiav thiab xaiv" - nws tau muab tso rau hauv pab pawg ntawm cov lus txib "kho" ntawm "Tab" Tsev ".
Kauj ruam 5
Hauv kab ntawv "Nrhiav" ntawm "Nrhiav thiab Hloov" cov lus teb, muab lub sijhawm, thiab lub chaw nyob rau hauv "Hloov nrog" teb. Yog tias nws txaus los thov cov haujlwm no nkaus xwb rau ntawm daim ntawv tam sim no, nyem "Hloov tag nrho" khawm thiab Excel yuav pib ua cov lus txib. Txhawm rau hloov tag nrho cov nplooj ntawv ntawm daim ntawv qhib, nias lub pob "Xaiv", teeb tsa tus nqi "hauv phau ntawv" hauv cov ntawv teev cia nyob ib sab ntawm kab ntawv "Tshawb nrhiav", thiab tsuas yog tom qab ntawd nyem rau ntawm "Hloov tag nrho" khawm Cov.
