Yuav ua li cas ntxiv daim duab kos npe hauv Excel

Txoj 1: editing ntxiv thaiv

Thawj txoj kev yog qhov yooj yim, vim nws yog raws li kho qhov rov qab ua daim duab kos duab. Nws pom tam sim ntawd tom qab tsim qee cov duab lossis lwm hom ntawm cov qauv, thiab nws yuav tsim nyog yuav tsum tau hloov ob peb kho kom hloov.

1. Tom qab tsim daim duab, nyem rau ntawm qhov "daim duab Title" uake.



Yog tias tom qab tsim cov duab kos, nws lub npe tsis tau ntxiv los yog koj tau raug tshem tawm, siv cov hauv qab no tau muab cov kev xaiv lwm yam kev xaiv tau nthuav tawm hauv kev nthuav dav.

Txoj Kev 2: Cov Cuab Yeej "Ntxiv Cov Ntawv Teev"

Ntau cov neeg siv thaum ua haujlwm nrog Excel ntsib lub "tsim" cuab tam, tsim los hloov cov duab kos thiab lwm yam kev tso cov ntsiab lus. Nws tuaj yeem siv rau ntxiv lub npe rau tsawg dua ib feeb.

1. Ua ntej, qhia cov qauv tsim nws tus kheej kom cov tab uas yog lub luag haujlwm tswj hwm nws tshwm rau sab saum toj.



2. Txav mus rau tus tsim qauv tab.



3. Ntawm sab laug yog "txheej txheem txheej txheem" ​​thaiv, qhov chaw koj yuav tsum tau xa cov ntawv qhia zaub mov kom poob qis "ntxiv cov duab kos".



4. Txav tus cursor rau "daim duab npe" taw tes thiab xaiv ib qho ntawm cov kev xaiv rau nws cov kev sib tshooj.



5. Tam sim no koj pom cov teeb ua qauv thiab koj tuaj yeem hloov kho nws los ntawm kev hloov pauv tsis tsuas yog cov lus sau, tab sis kuj yog cov qauv ntawm nws cov zaub.



Tib txoj kev muaj feem xyuam thiab rau lub npe ntawm cov axes, tsuas yog nyob rau hauv tib cov ntawv qhia hnub tim yuav tsum xaiv lwm yam, txuas ntxiv yog nqa tawm hauv tib txoj kev.

Txoj Kev 3: Lub Npe Nkawv Npe

Cov kev xaiv tshwj xeeb rau cov neeg siv ua haujlwm nrog cov rooj uas lub npe ntawm daim duab kos npe rau lub npe ntawm cov kem lossis cov hlua uas qee zaum hloov pauv. Nyob rau hauv cov ntaub ntawv no, uas siv cov kev ua-nyob rau hauv Excel functionality, koj muaj peev xwm tsim ib tug cia li daim duab lub npe muab rau cov cell thiab hloov raws li nws lub editing.

1. Yog tias daim duab kos npe tsis yog txhua, siv cov kev xaiv dhau los los tsim nws.



2. Tom qab ntawd, qhia nws rau kev kho kom raug, tab sis tsis haum rau lub ntsiab lus.



3. Nyob rau hauv txoj kab rau nkag mus rau cov mis, sau ib tug kos npe rau =, uas yuav txhais tau hais tias thaum pib ntawm lub automated lub npe.



4. Nws tseem raug nyob tsuas mus nias rau qhov ntawm tes, lub npe uas koj xav kom muab daim duab nws tus kheej. Nyob rau hauv cov mis tswv yim kab, qhov kev hloov no yuav tam sim ntawd tshwm sim - nias ENTER tseem ceeb rau nws siv.



5. Kos yuav ua li cas daim duab lub npe yog dynamically hloov, editing no cell.



Nws yog ib qho tseem ceeb rau inscribe ib tug kos npe rau = nyob rau hauv ib txoj hlua rau txawv qauv, thiab tsis thaiv lub npe ntawm daim ntawv, vim hais tias cov syntax ntawm qhov kev pab cuam tsuas tsis ua hauj lwm thiab khi automation yuav tsis ua hauj lwm.