Ib daim ntawv Excel yog ib txoj hauv kev yooj yim rau kev nkag mus rau hauv cov ntaub ntawv Excel thiab saib cov ntaub ntawv kab hauv ib daim ntawv ua haujlwm yam tsis muaj scrolling hauv daim ntawv. Cov ntaub ntawv sau cov kab ntawv kab hauv kab ntawv kom pom tag nrho cov kab ntawv tuaj yeem pom ib zaug. Cov ntaub ntawv tseem raug siv los tshawb nrhiav cov ntaub ntawv thiab kho cov ntaub ntawv uas twb muaj lawm.
Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, 2010; thiab Excel rau Microsoft 365.
Ntxiv cov ntaub ntawv nkag daim ntawv Icon rau Quick Access Toolbar
Thawj kauj ruam ntawm kev siv cov ntaub ntawv nkag mus yog ntxiv daim ntawv icon rau Quick Access Toolbar. Qhov no yog kev ua haujlwm ib zaug. Thaum ntxiv, daim ntawv icon tseem muaj nyob rau ntawm Quick Access Toolbar.
Lub Quick Access Toolbar yog siv los khaws cov shortcuts rau nquag siv nta hauv Excel. Nws tseem yog qhov uas koj tuaj yeem ntxiv cov shortcuts rau Excel nta uas tsis muaj nyob rau ntawm ribbon.
Txhawm rau ntxiv daim ntawv icon rau Quick Access Toolbar:
- Xaiv tus Kho kom haum Quick Access Toolbar dropdown xub.
-
Choose Ntau Commands.
Image -
In the Excel Options dialog box, nco ntsoov tias lub Quick Access Toolbar tab raug xaiv.
- Xaiv tus Xaiv cov lus txib los ntawm tus xub poob thiab xaiv Txhua Cov Lus txib.
-
Scroll los ntawm cov npe tsiaj ntawv ntawm cov lus txib thiab xaiv Form.
Image - Select Ntxiv.
-
Xaiv OK ntxiv rau Daim ntawv khawm rau Quick Access Toolbar.
Image - Koj yuav pom Form khawm ntawm sab xis kawg ntawm Quick Access Toolbar.
Ntxiv cov npe hauv Database teb
Daim ntawv nkag cov ntaub ntawv yog ib qho ntawm Excel cov cuab yeej tsim cov ntaub ntawv. Txhawm rau siv daim ntawv, muab cov kab ntawv kab lus siv rau hauv koj cov ntaub ntawv, nyem rau daim ntawv icon, thiab Excel ua li ntawd.
Txoj hauv kev yooj yim tshaj los ntxiv cov npe teb rau hauv daim ntawv yog ntaus lawv rau hauv cov ntawv ua haujlwm. Daim ntawv tuaj yeem suav nrog txog 32 kab lus.
Txhawm rau ua raws li cov lus qhia no, qhib ib daim ntawv ua haujlwm Excel dawb thiab nkag mus rau kab ntawv cov ntaub ntawv mus rau hauv cov hlwb A1 txog E1 raws li qhia hauv daim duab hauv qab no:
Qhib daim ntawv nkag cov ntaub ntawv
Tom qab koj daim ntawv ua haujlwm muaj cov kab ntawv kab lus, nws yog lub sijhawm qhib cov ntaub ntawv nkag.
- Xaiv tes A2 ua kom nws lub cev muaj zog.
-
Mus rau Quick Access Toolbar thiab xaiv Form.
Image -
Nyob hauv lub thawv ceeb toom, xaiv OK.
Image -
Daim ntawv uas muaj tag nrho cov kab ntawv kab lus tshwm rau ntawm qhov screen.
Image - Tam sim no koj npaj siv daim foos los sau cov ntaub ntawv.
Ntxiv cov ntaub ntawv nrog rau daim ntawv
Ntxiv cov ntaub ntawv rau hauv daim ntawv ua haujlwm tsuas yog ib qho teeb meem ntawm kev ntaus cov ntaub ntawv hauv daim foos kom raug.
Ntxiv cov ntaub ntawv thawj zaug rau hauv daim ntawv ua haujlwm los ntawm kev nkag mus rau cov ntaub ntawv rau hauv daim foos teb ntawm ib sab ntawm cov ncauj lus kom raug:
- StudentID: SA267-567
- Lub Npe: Jones
- Initial: B.
- hnub nyoog: 21
- Program: Lus
Nias tab kom txav ntawm thaj chaw mus rau qhov chaw. Xaiv New ntxiv cov ntaub ntawv rau hauv daim ntawv ua haujlwm thiab tshem tawm cov teb rau cov ntaub ntawv thib ob.
Ntxiv cov ntaub ntawv thib ob rau hauv daim ntawv ua haujlwm:
- StudentID: SA267-211
- Lub Npe: Williams
- Initial: J.
- Hnub nyoog: 19
- Program: Science
Xaiv New thaum koj ua tiav ntxiv cov ntaub ntawv.
Thaum nkag mus rau cov ntaub ntawv zoo sib xws xws li cov tub ntxhais kawm tus lej ID (tsuas yog cov lej tom qab sib txawv), siv daim theej thiab muab tshuaj txhuam kom nrawm cov ntaub ntawv nkag.
Txhawm rau ntxiv cov ntaub ntawv seem rau hauv cov ntaub ntawv qhia, siv daim ntawv nkag mus rau cov ntaub ntawv qhia hauv daim duab hauv qab no rau hauv hlwb A4rau E11.
Siv daim ntawv cov ntaub ntawv cuab yeej
Raws li cov ntaub ntawv ntxiv tau ntxiv rau hauv daim ntawv ua haujlwm, nws yog ib qho tseem ceeb kom muaj kev ncaj ncees ntawm cov ntaub ntawv. Khaws cov ntaub ntawv tshiab thiab muaj feem cuam tshuam los ntawm kev kho cov ntaub ntawv yuam kev, hloov kho cov ntaub ntawv, tshem tawm cov ntaub ntawv tsis siv, thiab tshem tawm cov ntaub ntawv sib npaug.
Daim ntawv nkag cov ntaub ntawv muaj ntau yam cuab yeej uas ua kom yooj yim nrhiav, kho, thiab tshem tawm cov ntaub ntawv los ntawm cov ntaub ntawv. Cov cuab yeej no pom nyob rau sab xis ntawm daim ntawv thiab suav nrog:
- Nrhiav Prev thiab Nrhiav Tom ntej: Scroll rau pem hauv ntej thiab rov qab los ntawm daim ntawv ua haujlwm ib zaug.
- Delete: Rho tawm cov ntaub ntawv los ntawm daim ntawv ua haujlwm.
- Restore: Undo hloov pauv rau cov ntaub ntawv. Restore ua haujlwm thaum cov ntaub ntawv tso tawm hauv daim ntawv. Thaum lwm cov ntaub ntawv nkag mus lossis daim ntawv raug kaw, Restore yuav tsis ua haujlwm.
- Criteria: Tshawb nrhiav daim ntawv ua haujlwm rau cov ntaub ntawv raws li cov qauv tshwj xeeb, xws li lub npe, hnub nyoog, lossis txoj haujlwm.
Nrhiav cov ntaub ntawv siv ib lub npe teb
Ntawm no yog yuav ua li cas siv cov ntaub ntawv nkag mus tshawb cov ntaub ntawv rau cov ntaub ntawv siv ib kab lus, xws li Lub Npe, Hnub Nyoog, lossis Txoj Haujlwm.
-
Nyob rau hauv daim ntawv sau npe, xaiv Criteria.
Image Thaum koj xaiv Criteria, daim ntawv teb raug tshem tawm ntawm daim ntawv; tsis muaj cov ntaub ntawv raug tshem tawm ntawm daim ntawv ua haujlwm.
- Muab tus cursor rau hauv Program lub thawv ntawv thiab ntaus Arts txhawm rau tshawb nrhiav rau txhua tus tub ntxhais kawm cuv npe hauv Arts program.
-
Xaiv Nrhiav Tom ntej
Image -
Cov ntaub ntawv rau thawj cov ntaub ntawv uas phim cov txheej txheem tshawb nrhiav tshwm hauv daim ntawv.
Image Txhawm rau hloov pauv cov ntaub ntawv, tshem tawm cov ntawv uas twb muaj lawm thiab sau cov ntaub ntawv raug.
- Xaiv Nrhiav Tom ntej txhawm rau tso tawm cov ntaub ntawv ntxiv uas haum rau kev tshawb nrhiav.
Tshawb nrhiav cov ntaub ntawv siv ntau lub npe teb
Daim ntawv kuj tseem siv tau los tshawb nrhiav cov ntaub ntawv siv ntau yam. Piv txwv li, txhawm rau tshawb nrhiav cov tub ntxhais kawm uas muaj hnub nyoog 18 xyoo thiab kawm hauv Arts program. Tsuas yog cov ntaub ntawv uas phim ob qho tib si tso rau hauv daim ntawv.
- Xaiv Criteria.
- Muab tus cursor rau hauv Hnub nyoog lub thawv ntawv thiab ntaus 18.
-
Muab tus cursor rau hauv Program ntawv lub thawv thiab ntaus Arts.
Image - Xaiv Nrhiav Tom ntej.
- Cov ntaub ntawv rau thawj cov ntaub ntawv uas phim cov txheej txheem tshawb nrhiav tshwm hauv daim ntawv.
- Xaiv Nrhiav Tom ntej txhawm rau tso tawm cov ntaub ntawv ntxiv uas haum rau kev tshawb nrhiav.
