txheem
Feem ntau, cov neeg siv ua haujlwm hauv Excel spreadsheet editor yuav tsum tau ntxiv ib daim ntawv ua haujlwm tshiab rau ib daim ntawv teev lus. Tau kawg, koj tuaj yeem tsim ib daim ntawv tshiab, tab sis nws raug nquahu kom siv qhov kev xaiv no tsuas yog nyob rau hauv rooj plaub uas tsis tas yuav txuas ntau yam ntaub ntawv rau ib leeg. Qhov kev zov me nyuam muaj ob peb txoj hauv kev uas tso cai rau koj ntxiv ib daim ntawv rau ib daim ntawv teev lus. Cia peb xav txog txhua txoj hauv kev kom ntxaws ntxiv.
Txoj kev no suav hais tias yog qhov yooj yim tshaj plaws thiab yooj yim tshaj plaws los siv. Nws yog siv los ntawm feem ntau ntawm cov neeg siv ntawm cov spreadsheet editor. Qhov kev nthuav dav siab ntawm txoj kev tau piav qhia los ntawm qhov tseeb tias algorithm rau ntxiv cov ntawv ua haujlwm tshiab yog qhov yooj yim heev thiab nkag siab txawm tias cov neeg siv tshiab.
Koj yuav tsum nyem LMB ntawm lub cim tshwj xeeb hu ua "New Sheet", nyob rau sab xis ntawm cov ntawv ua haujlwm uas twb muaj lawm nyob rau hauv qab ntawm nplooj ntawv. Lub pob nws tus kheej zoo li ib qho me me ntxiv rau hauv qhov tsaus ntuj nti. Lub npe ntawm daim ntawv tshiab, tsim tshiab yog muab tso rau hauv. Lub npe ntawm daim ntawv tuaj yeem hloov kho.
Cov lus qhia ntxaws ntxaws rau kev kho lub npe yog raws li hauv qab no:
- Ob-nias LMB ntawm daim ntawv ua haujlwm tsim.
- Sau lub npe koj xav muab.
- Tom qab ua tiav tag nrho cov manipulations, nyem rau ntawm "Enter" khawm nyob rau ntawm cov keyboard.
- Npaj txhij! Lub npe ntawm daim ntawv ua haujlwm tshiab tau hloov lawm.
Cov ntawv qhia zaub mov tso cai rau koj los siv cov txheej txheem ntxiv rau daim ntawv ua haujlwm tshiab rau hauv daim ntawv nthuav dav hauv ob peb kauj ruam ceev. Cov lus qhia ntxaws ntxiv rau kev ntxiv zoo li no:
- Peb saib hauv qab ntawm daim ntawv nthuav qhia interface thiab pom ib qho ntawm cov nplooj ntawv muaj nyob ntawm daim ntawv.
- Peb nyem rau nws RMB.
- Cov ntawv qhia zaub mov me me tau tshwm sim ntawm qhov screen. Peb pom cov khoom hu ua "Insert sheet" thiab nyem rau ntawm nws LMB.
- Npaj txhij! Peb tau ntxiv ib daim ntawv ua haujlwm tshiab rau hauv daim ntawv.
Koj tuaj yeem pom tias txoj kev no, uas tso cai rau koj ntxiv ib daim ntawv rau ib daim ntawv siv cov ntawv qhia zaub mov, tsuas yog siv tau yooj yim raws li txoj kev sib tham yav dhau los. Daim ntawv ua haujlwm ntxiv los ntawm txoj kev no tuaj yeem hloov kho tib yam.
Ua tib zoo mloog! Siv cov ntawv qhia zaub mov, koj tuaj yeem tsis tsuas ntxig ib daim ntawv ua haujlwm tshiab, tab sis kuj tshem tawm cov uas twb muaj lawm.
Cov lus qhia ntxaws txog kev rho tawm ib daim ntawv ua haujlwm yog raws li hauv qab no:
- Peb pom ib qho ntawm cov nplooj ntawv muaj nyob ntawm cov ntaub ntawv.
- Nyem rau ntawm daim ntawv nrog txoj cai nas khawm.
- Cov ntawv qhia me me tau tshwm sim ntawm qhov screen. Peb pom ib lub caij hu ua "Delete", nyem rau ntawm nws nrog rau sab laug nas khawm.
- Npaj txhij! Peb tau tshem daim ntawv ua haujlwm ntawm daim ntawv.
Siv cov ntawv qhia zaub mov, koj tuaj yeem hloov npe, txav mus, luam thiab tiv thaiv daim ntawv ua haujlwm.
Ntxiv ib daim ntawv ua haujlwm siv cov cuab yeej Ribbon
Koj tuaj yeem ntxiv daim ntawv ua haujlwm tshiab rau hauv Excel daim ntawv nthuav qhia siv cov cuab yeej tshwj xeeb multifunctional nyob rau sab saum toj ntawm lub interface. Cov lus qhia ntxaws muaj raws li hauv qab no:
- Thaum pib, peb tsiv mus rau ntu "Tsev". Nyob rau sab xis ntawm lub cuab yeej ribbon, peb pom ib lub caij hu ua "Cells" thiab sab laug-nias ntawm lub xub icon nyob ib sab ntawm nws. Ib daim ntawv teev npe ntawm peb lub nyees khawm "Ntxig", "Delete" thiab "Format" tau tshwm sim. Nyem rau sab laug nas khawm ntawm lwm tus xub nyob ze ntawm lub pob "Insert".
- Lwm daim ntawv me me ntawm plaub yam tau nthuav tawm. Peb xav tau lub xeem kawg hu ua "Insert Sheet". Peb nyem rau ntawm nws LMB.
- Npaj txhij! Peb tau siv cov txheej txheem ntxiv rau daim ntawv ua haujlwm tshiab rau hauv daim ntawv nthuav dav. Nws yog tsim nyog sau cia tias, raws li nyob rau hauv cov kev sib tham yav dhau los, koj tuaj yeem hloov kho lub npe ntawm daim ntawv ua haujlwm tsim, nrog rau tshem tawm.
Tseem ceeb! Yog tias lub qhov rais spreadsheet tau nthuav dav rau nws qhov loj me, ces tsis tas yuav mus nrhiav "Cells" keeb. Nyob rau hauv rooj plaub no, lub pob "Insert Sheet", nyob rau hauv lub drop-down daim ntawv teev cov "Ntxig", nyob rau tam sim ntawd nyob rau hauv seem hu ua "Tsev".
Siv Spreadsheet Hotkeys
Excel spreadsheet muaj nws tus kheej tshwj xeeb kub yuam sij, kev siv uas yuav txo tau lub sij hawm nws yuav siv sij hawm mus nrhiav tau cov cuab yeej tsim nyog nyob rau hauv lub program menu.
Txhawm rau ntxiv ib daim ntawv ua haujlwm tshiab rau daim ntawv nthuav qhia, koj tsuas yog yuav tsum nias qhov tseem ceeb ua ke "Shift + F11" ntawm cov keyboard. Tom qab ntxiv daim ntawv ua haujlwm tshiab hauv txoj haujlwm no, peb yuav pom tam sim ntawd peb tus kheej hauv nws qhov chaw ua haujlwm. Tom qab ib daim ntawv ua haujlwm tshiab ntxiv rau hauv phau ntawv, nws lub npe tuaj yeem raug kho raws li saum toj no.
xaus
Cov txheej txheem ntxiv ib daim ntawv ua haujlwm tshiab rau hauv Excel daim ntawv yog ib qho kev ua haujlwm yooj yim, uas yog ib qho ntawm feem ntau thiab nquag siv los ntawm cov neeg siv daim ntawv. Yog tias tus neeg siv tsis paub yuav ua li cas ua cov txheej txheem no, ces nws yuav tsis muaj peev xwm ua tau zoo thiab siv tau nws txoj haujlwm. Kev muaj peev xwm ntxiv daim ntawv ua haujlwm tshiab rau hauv phau ntawv ua haujlwm yog qhov kev txawj ntse uas txhua tus neeg siv uas xav ua haujlwm sai thiab raug rau hauv daim ntawv yuav tsum muaj.