txheem
Ntau tus neeg siv tshiab tshiab ntawm Excel tau paub txog qhov teeb meem uas nws tsis yooj yim los tso cov ntaub ntawv ntau hauv cov hlwb, tsis muaj qhov twg los sau ntawv rau koj tus kheej yav tom ntej. Qhov tseeb, ua qhov no yam tsis tau ua txhaum txoj cai dav dav ntawm lub rooj yog qhov yooj yim heev. Nov yog cov ntawv sau rau.
Ua haujlwm nrog Sau Ntawv
Cov ntawv sau yog cov tshuaj ntxiv rau cov hlwb uas tau xaiv. Feem ntau lawv yog cov ntawv nyeem thiab muaj cov lus qhia tshwj xeeb los ntawm ib tus kws sau ntawv ntawm lub rooj. Ntxiv nrog rau cov ntawv nyeem, koj tuaj yeem ntxiv cov duab rau hauv daim teb uas tshwm. Txawm li cas los xij, txhawm rau txhawm rau txuas cov lus xav lossis duab rau hauv lub xov tooj ntawm tes, koj yuav tsum kawm paub yuav ua li cas los tsim cov ntawv sau yooj yim, saib thiab kho lawv.. Tom qab ntawd, koj tuaj yeem mus rau qhov chaw siab tshaj.
creation
Cov txheej txheem ntawm kev tsim cov ntawv yog qhov yooj yim heev thiab muaj ob peb kauj ruam:
- Xaiv ib lub xovtooj ntawm lub rooj nrog tus nas. Txoj nyem rau nws.
- Los ntawm cov ntawv qhia zaub mov uas tshwm, xaiv "Insert Note" muaj nuj nqi.
- Tom qab ntawd, ib daim teb dawb yuav tshwm rau ntawm sab ntawm lub xov tooj uas tau xaiv. Cov kab saum toj kawg nkaus yuav raug nyob los ntawm lub neej ntawd username.
Koj tuaj yeem sau cov ntaub ntawv xov xwm hauv qhov chaw dawb. Txhawm rau nkaum cov lus pom, koj yuav tsum tau nyem rau ntawm lub xov tooj ntawm tes, xaiv "Hide Comment" muaj nuj nqi. Tom qab ntawd, nws yuav muaj rau kev nyeem ntawv ntawm qhov txuas uas tau qhia los ntawm lub ces kaum liab.
Review
Koj tuaj yeem saib cov lus rau cov hlwb sib txawv los ntawm hovering tshaj lawv txhua tus nrog tus nas cursor. Tom qab ntawd, cov ntawv nyeem nrog daim ntawv pops tuaj yeem. Txhawm rau ua kom cov lus teb ploj mus, koj yuav tsum txav tus cursor mus rau lwm qhov chaw.
Cov kws tshaj lij tawm tswv yim! Yog tias lub rooj loj, thiab nws muaj ntau cov ntawv khi rau cov hlwb sib txawv, koj tuaj yeem hloov ntawm lawv los ntawm "Tshawb xyuas" tab. Rau qhov no, cov nyees khawm "Previous" thiab "Next" yog npaj.
editing
Feem ntau muaj cov xwm txheej thaum nws tsim nyog hloov cov ntsiab lus ntawm lub qhov rais rau cov lus pom ntxiv. Koj tuaj yeem ua qhov no los ntawm kev ua raws li ob peb kauj ruam:
- Thaum xub thawj nyem rau ntawm lub xov tooj ntawm tes nrog cov ntawv zais nrog tus nas khawm sab xis.
- Hauv cov npe uas tshwm sim, xaiv "Kho kom raug ceeb toom" muaj nuj nqi.
- Lub qhov rais yuav tsum qhib los ntawm qhov koj tuaj yeem hloov kho cov ntawv nyeem, ntxiv cov duab rau nws, nce lossis txo cov lus teb.
Koj tuaj yeem ua kom tiav qhov teeb tsa los ntawm txhaj rau qhov twg hauv lub rooj sab nraud rau cov ntawv sau ntxiv.
Lwm qhov kev xaiv rau kev kho cov lus ntawm tes yog los ntawm Kev Tshawb Fawb tab. Ntawm no koj yuav tsum nrhiav ib txheej ntawm cov cuab yeej rau sau ntawv thiab nyem rau ntawm "Kho" khawm.
Ntxiv ib daim duab
Ib qho ntawm cov yam ntxwv ntxim nyiam ntawm cov ntawv sau hauv Excel yog qhov sib ntxiv ntawm cov duab uas yuav tshwm sim thaum koj hla lub hlwb xaiv. Txhawm rau ntxiv cov duab, koj yuav tsum ua ntau yam haujlwm:
- Thaum xub thawj, koj yuav tsum tau ntxiv ib qho kev kos npe ntxiv rau hauv lub xov tooj uas tau xaiv.
- Mus rau daim ntawv kho cov txheej txheem, coj tus nas cursor mus rau ib qho ntawm cov ciam teb ntawm tes. Nws yog ib qho tseem ceeb kom coj nws mus rau qhov chaw uas lub icon nrog plaub xub yuav tshwm sim, uas diverge nyob rau hauv ntau cov lus qhia.
- Koj yuav tsum tau right-click ntawm no icon, xaiv qhov "Note Format" muaj nuj nqi los ntawm cov ntawv qhia zaub mov uas tshwm.
- Lub qhov rais rau kev kho cov ntaub ntawv yuav tsum tshwm sim ua ntej tus neeg siv. Koj yuav tsum nrhiav "Colors and Lines" tab thiab hloov mus rau nws.
- Nyem rau ntawm daim ntawv teev npe hu ua "Color", nyob rau hauv qab ntawm daim ntawv teev npe uas tshwm, xaiv "Fill Methods" muaj nuj nqi.
- Lub qhov rais tshiab yuav tsum tshwm nyob rau hauv uas koj yuav tsum mus rau lub "Drawing" tab. Hauv lub tab no, nyem rau ntawm lub pob nrog tib lub npe.
- Lub qhov rais "Insert Images" yuav tshwm sim, uas koj yuav tsum xaiv ib qho ntawm peb txoj kev xaiv: upload ib daim duab los ntawm OneDrive, tshawb rau cov duab siv Bing, upload duab los ntawm lub computer. Txoj kev yooj yim tshaj plaws yog upload los ntawm lub computer uas cov ntaub ntawv nyob.
- Thaum xaiv cov duab, nws yuav cia li hloov mus rau lub qhov rais dhau los uas cov duab xaiv yuav pom. Ntawm no koj yuav tsum khij lub npov nyob ib sab ntawm lub luag haujlwm "Kua qhov proportions ntawm daim duab."
- Tom qab txhaj rau "OK" khawm, lub qhov rais thawj daim ntawv formatting yuav qhib. Nyob rau theem no, koj yuav tsum khi daim ntawv nrog daim duab mus rau qhov pib xaiv ntawm tes. Txhawm rau ua qhov no, koj yuav tsum mus rau "Kev Tiv Thaiv" tab, uncheck lub thawv nyob ib sab ntawm "Protected object".
- Tom ntej no, koj yuav tsum mus rau lub "Properties", kos lub thawv nyob ib sab ntawm cov khoom rau txav thiab hloov khoom ua ke nrog cov hlwb. Nyem rau ntawm lub pob "OK".
Txhawm rau nthuav daim duab, nws yog qhov yuav tsum tau ncab cov ntawv sau dav dav hauv ntau qhov kev qhia.
Rov sau ib lub ceeb toom
Tshem tawm ib qho kev kos npe ntxiv yog yooj yim dua li txhim kho ib qho tshiab lossis kho nws. Txhawm rau ua qhov no, right-click ntawm lub xov tooj ntawm tes nrog cov lus piav qhia ntxiv. Los ntawm cov ntawv qhia zaub mov pop-up, qhib qhov "Delete note" hais kom ua.
Qhov thib ob txoj hauv kev kom tshem tawm ib daim ntawv lo ntxiv rau lub xov tooj ntawm tes uas tau xaiv yog los ntawm "Tshawb Xyuas" muaj nuj nqi. Ua ntej xaiv qhov kev xaiv no, koj yuav tsum kos lub xov tooj ntawm tes nrog tus nas. Thaum kawg, nyem rau ntawm lub pob rho tawm cov ntaub ntawv ntxiv.
Yuav ua li cas kos npe rau hauv Excel
Yog tias nyob rau hauv ib daim ntawv Excel sib koom tag nrho cov kev hloov kho ntxiv ntawm cov hlwb raug sau los ntawm cov neeg siv sib txawv yam tsis muaj tus kheej kos npe, nws yuav nyuaj heev los nrhiav tus sau ntawm qee qhov nkag. Lub npe ntawm daim ntawv tso cai rau koj los npaj cov ntaub ntawv. Txhawm rau tso nws saum toj ib qho kev hloov kho rau lub xov tooj ntawm tes, koj yuav tsum ua ntau yam haujlwm:
- Xaiv ib qho ntawm cov ntawv qhia zaub mov tseem ceeb "Cov ntaub ntawv".
- Mus rau "Chaw".
- Mus rau "General" tab.
- Ib daim teb pub dawb yuav tshwm rau hauv qab ntawm nplooj ntawv, uas koj yuav tsum nkag mus rau lub npe ntawm tus neeg siv uas tau tawm lus tawm ntawm lub xov tooj ntawm tes.
Yuav ua li cas nrhiav tau ib daim ntawv hauv Excel
Yog tias cov ntaub ntawv loj heev, tej zaum yuav muaj qhov xwm txheej uas koj xav tau sai sai nrhiav cov lus qhia tshwj xeeb. Ua tau. Cov lus qhia txhawm rau nrhiav qhov yuav tsum tau piav qhia lossis daim ntawv lo:
- Mus rau "Tsev" tab.
- Mus rau ntu "Nrhiav thiab xaiv".
- Nyem rau ntawm "Settings" khawm.
- Nrhiav qhov kev xaiv los xaiv "Search Scope".
- Teeb tus nqi rau Note.
- Nyem rau ntawm "Nrhiav Txhua" khawm.
Tom qab ntawd, ib daim ntawv teev cov hlwb raws li cov txheej txheem yuav tshwm sim ua ntej tus neeg siv.
Qhia thiab zais ib daim ntawv
Yog tias koj xav tau, koj tuaj yeem zais tag nrho cov ntawv kom lawv tsis pom meej thaum nyeem cov ntaub ntawv tseem ceeb, lossis lov tes taw cov haujlwm zais yog tias nws tau qhib ua ntej. Txhawm rau ua qhov no, koj yuav tsum ua raws li ob peb kauj ruam yooj yim:
- Mus rau qhov chaw dav dav ntawm "Cov ntaub ntawv" tab, tom qab ntawd "Options", mus rau ntu "Advanced".
- Nrhiav qhov "Screen" seem.
- Kos lub npov nyob ib sab ntawm qhov "Notes and indicators" function.
- Nyem rau ntawm lub pob "OK". Tom qab ntawd, cov ntawv zais yuav ib txwm tso tawm. Txhawm rau zais lawv tag nrho, koj yuav tsum kos lub npov nyob ib sab ntawm "Tsis muaj ntawv sau, tsis muaj qhov ntsuas" ua haujlwm.
Cov kws tshaj lij tawm tswv yim! Excel muaj qhov kev xaiv los tso saib cov lus qhia ib leeg xwb. Txhawm rau ua kom cov yam ntxwv no, koj yuav tsum nyem rau ntawm lub xov tooj ntawm tes nrog cov lus piav qhia ntxiv, nyem rau ntawm "Show Notes" khawm. Yog li ntawd lawv yuav raug tso tawm mus tas li tsuas yog nyob rau ntawm cov cell xaiv. Los ntawm tib cov ntawv qhia zaub mov, koj tuaj yeem zais cov lus piav qhia luv luv hauv qhov chaw xav tau.
Luam ib daim ntawv mus rau lwm lub hlwb
Yog tias daim ntawv twb tau tsim lawm, koj tuaj yeem luam nws mus rau lwm lub xovtooj kom tsis txhob sau cov ntawv ntxiv. Txhawm rau ua qhov no, ua raws li cov lus qhia yooj yim:
- Txoj cai-nias los xaiv lub xov tooj ntawm tes hauv cov ntaub ntawv uas txuas nrog cov lus piav qhia luv luv lossis hloov kho.
- Los ntawm cov ntawv qhia zaub mov pop-up, xaiv "Copy" muaj nuj nqi.
- Nrhiav lub xovtooj ntawm tes uas koj xav khi daim ntawv theej, xaiv nws los ntawm txhaj rau sab laug nas khawm.
- Mus rau "Tsev" tab, tom qab ntawd xaiv "Clipboard", nyem rau ntawm lub pob "Paste".
- Ib daim ntawv teev cov lus txib yuav tshwm nyob rau hauv pem hauv ntej ntawm tus neeg siv. Lub ntsiab lus txaus siab yog "Passe Tshwj Xeeb". Tom qab txhaj rau nws, ib lub qhov rais cais rau cov chaw yuav tshwm sim, qhov twg koj yuav tsum tau kos lub thawv nyob ib sab ntawm cov ntawv sau. Nws tseem yuav txuag tau cov kev hloov pauv los ntawm txhaj rau "OK".
Yuav sau ib daim ntawv sau li cas
Yog tias koj tsis ua qee yam kev hloov kho, los ntawm lub neej ntawd, Excel cov ntaub ntawv raug luam tawm yam tsis muaj ntawv sau tseg. Txhawm rau ntxiv lawv rau cov ntawv luam tawm, koj yuav tsum teeb tsa qhov program:
- Mus rau ntu "Page Layout".
- Mus rau "Page Setup" tab, tom qab ntawd nyem "Print Headers".
- Lub qhov rais uas muaj ib tus neeg rau kev luam ntawv yuav qhib. Tawm tsam lo lus "Notes", koj tuaj yeem ntxiv lawv rau hauv daim ntawv luam tawm lossis tso qhov kev txiav txim no tso tseg.
Cov kws tshaj lij tawm tswv yim! Thaum ntxiv cov ntawv luam tawm, muaj ob txoj hauv kev los tso saib lawv ntawm cov ntawv luam tawm. Yog tias koj xaiv "Thaum kawg ntawm daim ntawv" - lawv yuav tshwm sim nyob rau hauv qab ntawm nplooj ntawv. Koj tuaj yeem xaiv qhov kev xaiv "Raws li ntawm ib daim ntawv" - cov ntawv yuav raug luam tawm raws li lawv tshwm hauv cov ntawv hluav taws xob ntawm cov ntaub ntawv.
Hloov cov username thaum tsim cov ntawv
Thaum ua haujlwm hauv Excel nrog kev sib koom qhib, thaum koj tsim cov ntawv, lawv tsis tau muab lub npe ntawm tus neeg siv uas tso lawv. Txhawm rau hloov nws mus rau koj lub npe menyuam yaus, koj yuav tsum ua raws li ob peb kauj ruam:
- Nyob rau sab laug ces kaum, nyem rau ntawm "Cov ntaub ntawv" tab.
- Mus rau "Settings", "General" section.
- Xaiv "Username" los ntawm cov ntawv qhia zaub mov uas tshwm.
- Ib daim teb dawb yuav qhib rau pem hauv ntej ntawm tus neeg siv, uas yuav tsum tau sau lub npe xav tau.
Piv txwv ntawm kev siv cov ntawv hauv Excel
Txhawm rau nkag siab tias cov lus hais ntxiv ntawm tes muaj txiaj ntsig zoo li cas hauv Excel daim ntawv nthuav qhia tuaj yeem ua tau, nws raug nquahu kom xav txog ob peb yam piv txwv los ntawm kev paub ntawm lwm tus neeg siv:
- Thaum cov neeg ua haujlwm ntawm ib lub tuam txhab muaj ib qho kev ua haujlwm zoo uas tau sau tseg hauv Excel cov ntaub ntawv, cov npoj yaig ua haujlwm ntawm tib nplooj ntawv hauv kev hloov pauv tuaj yeem tawm lus raws li kev hloov pauv, muab cov lus qhia, sib pauv cov ntaub ntawv.
- Qhov chaw ntawm cov duab - yog tias lub rooj muaj cov ntaub ntawv hais txog qee tus neeg, cov duab ntawm txhua yam khoom, yog tias nws txhawj txog lawv qhov chaw cia, muag.
- Kev piav qhia rau cov qauv uas yuav ua kom yooj yim rau kev suav ntxiv, kev suav.
Yog tias koj tawm lus hauv txoj kev yog - kom lawv tshwm sim thaum lub sijhawm thiab tsis cuam tshuam nrog lwm tus neeg siv txoj haujlwm, koj tuaj yeem ua kom muaj txiaj ntsig zoo ntawm kev ua haujlwm ntsig txog cov ntxhuav hauv Excel.
Video tutorials ntawm sau ntawv hauv Excel
Cov lus qhia saum toj no yuav pab koj nkag siab txog cov hauv paus ntawm kev tsim, kho, saib, kev teeb tsa qib siab ntawm cov lus rau cov hlwb hauv Excel spreadsheet. Txawm li cas los xij, yog tias koj ntsib teeb meem, teeb meem nrog qee yam kev ua ntawm cov ntawv sau, nws raug nquahu kom saib cov yeeb yaj kiab kev cob qhia. Lawv muaj cov lus qhia step-by-step rau kev ua haujlwm ntau yam nrog cov lus pom ntawm tes.
xaus
Tsim, kho thiab saib cov lus ntawm ntau lub hlwb hauv Excel tsis nyuaj li nws yuav zoo li thaum xub thawj siab ib muag. Nws yuav muaj txiaj ntsig zoo kom muaj cov txuj ci zoo li no tsis yog rau cov neeg ua haujlwm hauv cov koom haum loj xwb, ua raws qee yam uas siv cov ntxhuav, tab sis kuj rau tib neeg siv uas ua haujlwm hauv Excel rau lawv tus kheej. Peb yuav tsum tsis txhob hnov qab tias nyob rau hauv daim ntawv teb koj muaj peev xwm ntxiv tsis tau tsuas yog cov ntawv nyeem, tab sis kuj cov duab, uas zoo heev tsub kom lawv pab tau nyob rau hauv kev ua hauj lwm.