Qhov wikiHow no qhia koj li cas los tsim thiab khaws cov npe kev cai tshiab ntawm Excel txhawm rau kom ua tiav sau kab thiab kab, siv Mac lossis Windows PC.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Tsim Cov Npe Tshiab
Kauj Ruam 1. Qhib Microsoft Excel ntawm koj lub computer
Excel yog cov cuab yeej spreadsheet ntawm Microsoft Office cov khoom tsim khoom. Nws muaj nyob ntawm ob lub Windows thiab Mac operating systems.
Kauj Ruam 2. Tua tawm Excel's Custom Lists editor
Yuav ua li cas koj qhib Custom Lists editor yuav txawv nyob ntawm koj lub operating system thiab software version ntawm Excel.
- Rau "Excel 2010" lossis tom qab software ntawm Windows, ua ntej, nyem rau ntawm Cov ntaub ntawv menu nyob rau sab saum toj ntawm koj lub vijtsam. Tom qab ntawd, nyem Kev xaiv, Advanced, thiab General, feem. Ntawm no, nyem Kho Kho Cov Cai.
- Txog "Excel 2007" ntawm Windows, nyem rau Microsoft Office khawm nyob rau sab saud sab laug ntawm koj lub vijtsam. Nws zoo li cov plaub fab xim nyob hauv ib lub voj voog. Tom qab ntawd, nyem Kev xaiv Excel, Nrov, Cov kev xaiv sab saum toj rau ua haujlwm nrog Excel, feem. Ntawm no, nyem Kho Kho Cov Cai.
- Rau "Excel rau Mac", nyem rau ntawm Excel cov ntawv qhia zaub mov nyob rau sab saud sab laug. Tom qab ntawd, nyem Nyiam thiab Cov Cai Sau, feem. Qhov no yuav qhib tus editor.
Kauj Ruam 3. Xaiv TSHIAB LIST hauv lub thawv "Cov npe tshwj xeeb"
Koj yuav pom ib daim ntawv teev tag nrho koj cov npe hauv Custom Lists editor. Nyem TSHIAB LIST nyob rau sab saum toj ntawm Custom List box los tsim cov npe tshiab.
Kauj Ruam 4. Nyem rau ntawm lub box "List entries"
Nov yog lub npov thib ob hauv Custom Lists editor tom ntej ntawm Lub thawv Custom lis. Ntawm no, koj tuaj yeem pom txhua daim ntawv teev npe nkag thaum koj xaiv cov npe los ntawm lub npov Custom List.
Lub npov no yuav tsis muaj dab tsi thaum koj xaiv TSHIAB
Kauj Ruam 5. Ntaus cov npe nkag rau koj daim ntawv teev npe tshiab
Yog tias koj daim ntawv teev npe tshiab luv, koj tuaj yeem ua tus kheej sau cov npe nkag lub thawv nrog nkag.
Ntaus ↵ Sau rau ntawm koj cov keyboard tom qab txhua qhov nkag
Kauj Ruam 6. Nyem rau lub cim xaiv lub xovtooj ntawm ib sab ntawm lub pob Ntshuam
Lub pob no cia koj xaiv ntau yam ntawm cov cell, xws li kab lossis kab, los ntawm koj daim ntawv nthuav qhia txhawm rau siv cov ntaub ntawv no rau koj cov npe nkag. Qhov kev xaiv no tuaj yeem muaj txiaj ntsig rau cov npe ntev nrog ntau qhov nkag mus rau tus kheej nkag.
- Ntawm Windows, lub pob no zoo li lub ntsej muag taw qhia taw qhia.
- Ntawm Mac, nws yog xim liab, kab pheeb ces kaum sab hauv lub thawv duab plaub.
Kauj Ruam 7. Nyem Ntshuam
Lub pob no yuav ntshuam tag nrho cov ntaub ntawv los ntawm cov kab ke uas tau xaiv, thiab ntsaws nws rau hauv Cov Npe nkag lub thawv.
Kauj Ruam 8. Nyem Ntxiv
Lub pob no yuav tsim koj daim ntawv teev npe tshiab.
Kauj ruam 9. Nyem OK
Nws yuav txuag koj qhov kev hloov pauv, thiab txiav tawm Cov Cai Lists editor. Tam sim no koj tuaj yeem siv koj daim ntawv teev npe tshiab.
Yog tias koj nyob ntawm Mac, koj yuav tsis muaj khawm OK ntawm no. Hauv qhov no, kaw lub npov sib tham los ntawm txhaj lub pob "X" liab nyob rau sab saud sab laug ntawm Custom List
Txoj Kev 2 ntawm 2: Siv Koj Cov Npe Tshiab
Kauj Ruam 1. Ntaus hauv ib qho ntawm koj daim ntawv teev npe nkag hauv lub cell
Qhov no tuaj yeem yog ib qho nkag los ntawm cov npe kev cai.
Kauj Ruam 2. Nias Sau rau ntawm koj cov keyboard
Kauj Ruam 3. Nyem rau ntawm tes
Xaiv lub xov tooj ntawm tes nrog koj daim ntawv teev npe nkag hauv nws los ntawm txhaj rau ntawm tes. Qhov no yuav hais txog cov ciam teb ntawm tes.
Kauj Ruam 4. Nyem thiab luag tus AutoFill tuav hauv txhua txoj kev
Tus kov zoo li me me, cov duab plaub fab nyob hauv kaum sab xis-sab xis ntawm lub xovtooj. Nws yuav cia li sau koj daim ntawv nrog rau qhov seem ntawm koj cov kev cai teev npe nkag.
