Daim ntawv khej los yog daim ntawv yog ib nplooj ntawv hauv ib qho ntaub ntawv tsim nrog ib daim ntawv tshaj tawm hauv electronic xws li Excel lossis Google los xij. Ib phau ntawv yog lub npe muab rau cov ntaub ntawv Excel thiab muaj ib lossis ntau ntau daim ntawv khom nqi. Lub sij hawm ntawv tshaj tawm no feem ntau yog siv rau kev ua hauj lwm, thaum twg, raws li tau hais, nws yog qhov tseeb dua rau ntawm lub koos pij tawj ntawm nws tus kheej.
Yog li, hais nruj me ntsis, thaum koj qhib ib qho kev tshaj tawm hauv khoos phis ntawv nws ua haujlwm ua haujlwm tsis muaj ntaub ntawv muaj ib lossis ntau ntau daim ntawv rau koj siv.
Cov Lus Qhia Cov Lus Qhia
Ib daim ntawv khij siv los khaws, tswj, thiab saib cov ntaub ntawv .
Lub chaw sau cia rau cov ntaub ntawv hauv daim ntawv ua hauj lwm yog cov duab qes-zoo li cov txheej txheem hauv ib kab sib chaws hauv txhua daim ntawv.
Qee lub hlwb ntawm cov ntaub ntawv raug txheeb xyuas thiab sib sau ua ke siv cov ntawv sau ntsug thiab kab rov tav kab ntawm ib daim ntawv ua haujlwm uas tsim lub xov tooj ntawm tes - xws li A1, D15, lossis Z467.
Cov lus qhia ua haujlwm rau cov qauv versions ntawm Excel muaj xws li:
- 1.048,576 teev rau ib daim ntawv ua haujlwm;
- 16,384 kab ib kab ntawv;
- 17, 179, 869, 184 lub hlwb ib daim ntawv;
- tsuas yog ib daim ntawv rau cov ntaub ntawv tshiab (vim);
- ib qho kev txwv ntawm tus nab npawb ntawm cov ntaub ntawv. Qhov no tsuas yog siv los ntawm lub cim xeeb muaj nyob hauv lub computer.
Rau Google los xij:
- Muaj ntau tshaj 256 ntawm ib daim ntawv.
- Qhov siab tshaj plaws ntawm cov hlwb rau tag nrho cov ntawv khej hauv ib daim ntawv yog 400,000.
- Tsam no muaj pes tsawg daim ntawv ntawm cov ntawv khom nqi rau cov ntaub ntawv tshiab yog ib qho.
- Muaj ntau tshaj 200 daim ntawv khom nqi ntawm ib daim ntawv zom zaws.
Daim Ntawv Xaiv Npe
Hauv Excel thiab Google Spreadsheets, txhua daim ntawv qhia muaj ib lub npe. Yog vim li cas, daim ntawv khom nqi muaj npe hu ua Sheet1, Sheet2, Sheet3 thiab hais txog, tab sis cov no tuaj yeem hloov tau.
Naj Npawb Qhia Npe
Yog vim, txij thaum Excel 2013, tsuas yog cov ntawv ua haujlwm rau ib phau Excel tshiab, tab sis qhov no tus nqi pheej yuav raug hloov. Ua li no:
- Nias rau hauv cov ntawv qhia zaub mov.
- Nias ntawm kev xaiv nyob rau hauv cov ntawv qhia qhib Excel xaiv dialog box .
- Hauv Kev Tshawb Fawb Ua Haujlwm tshiab thaum nyob rau ntawm txoj kab pane ntawm qhov kev sib tham, nce qhov nqi ntxiv ntawm Xws li ntau cov ntawv txheeb.
- Nias ntawm OK kom tiav qhov kev hloov thiab kaw lub thawv ntawv.
Lus Cim : Cov ntaub ntawv vim yog cov ntaub ntawv hauv Google Spreadsheets yog ib qho, thiab qhov no hloov tsis tau.
Cov Lus Qhia Tshaj Tawm
- Cov ntawv ua haujlwm ntxiv yuav muab ntxiv rau ib phau ntawv siv cov ntawv siv cov ntsiab lus teb los yog Daim Ntawv Ntxiv Daim Ntawv Ceeb Toom (ntxiv rau qhov kos npe) ntawm daim ntawv tab tam li pom hauv daim duab saum toj no.
- Nws yog ib qho ua tau los rho tawm los yog mus nkaum daim ntawv khom nqi rau ib phau ntawv.
- Nws kuj tseem tuaj yeem ua dua tshiab cov ntawv khom nqi thiab hloov daim ntawv tab tab xim kom yooj yim dua los txheeb xyuas cov ntawv txheeb npe hauv phau ntawv siv cov ntsiab lus teb.
- Hloov ntawm ib daim ntawv rau ib daim ntawv ua hauj lwm yuav ua tau los ntawm txhaj rau daim ntawv tab nyob hauv qab ntawm qhov screen.
- Nyob rau hauv Excel, cov lus nug nram qab no shortcut nram qab no tseem siv tau los hloov ntawm cov ntawv ua haujlwm :
- Ctrl + PgUp (nplooj ntawv) - txav mus rau sab xis
- Ctrl + PgDn (nplooj ntawv) - txav mus rau sab laug
- Rau Google Spreadsheets, qhov tseem ceeb ntawm ob peb ua ke hloov ntawm cov ntawv khom nqi yog:
- Ctrl + Ua haujlwm + PgUp - txav mus rau sab xis
- Ctrl + ua haujlwm + PgDn - txav mus rau sab laug